Dołącz do nas!

Wszystkie znaki interpunkcyjne za wyjątkiem kropek, łączników, znaków podkreśleń i spacji są niedozwolone.
Adres e-mail, koniecznie prawidłowy. Będą nań przesyłane wszystkie wiadomości e-mail od systemu. Adres nie jest udostępniany publicznie i będzie wykorzystywany jedynie w wypadku prośby o przesłanie nowego hasła lub do przesyłania informacji o nowościach czy innych komunikatów.
CAPTCHA
To pytanie ma na celu ochronę przed automatycznym spamowaniem oraz ustalenie, czy odwiedzający stronę jest człowiekiem.
Image CAPTCHA
Wpisz kod widoczny powyżej.

Logowanie

Nazwa użytkownika witryny Project Envision.
Hasło powiązane z nazwą użytkownika.
Prześlij nowe hasło

Krystian Zieja - blog

Sql Server Get Operating System Memory Statistics

Often Database Administrators would like to check memory usage on operating system level. Of course they can use many tools that works on operating system level. However Sql Server 2008 introduced the new dynamic management view sys.dm_os_sys_memory that enables DBA to use simple query to get those statistics.

The dynamic management view sys.dm_os_sys_memory returns returns a complete picture of memory on operating system level, including information about total and available physical memory, total and available page memory, system cache, kernel space and others.

How To Rename Microsoft Sql Server Database

From time to time Sql Server DBA have to change the database name. There can be several reasons to do so, for example durring the restore you assigned temporary name to a database. Another reason is that project for which you developed that database was renamed. From time to time such requirement comes from Management, who developed new naming convention for database names and you are responsible for implementing it.

Share Folder From Command Line in Windows

I often hear that Windows is a bad operating system, because you have to do everything from GUI, I totally disagree with such a statement. Windows has many very useful tool in its command line interface. Not to mention Power Shell, in which you can script almost everything. In that blog post I will present a quick How-To on sharing a folder from command line.

Categories:

Sql Server Display Column Name Using COL_NAME

In SQl Server Metadata Catalog we often see the use of the column named column_id. Usually it is not meaningful for us and we would prefer to see a real column name. Obviously we can always perform a join with sys.columns table and retrieve the column name directly, however quite often that join would only add unneeded complexity to our query. In such situations COL_NAME functions becomes very handy.

Backup and Restore MySQL Database

The possibility to backup and restore database is crucial for every Database Administrator. Below article presents the usage of mysqldump command line program for making backups of mysql databases. The restore of such a backup is done by mysql client utility.

Categories:

Configure Cisco Logging to Rsyslog on Debian

Quite often Network Administrators are obligated to keep logs from their cisco devices, either for troubleshooting or due to be compliant with IT Security Policy. In this article I will describe fast and easy way to setup saving logs from your Cisco devices to rsyslog server on Debian Linux.

Categories:

Disable Archiving Options in Outlook 2007 using GPO

Administrators often need to disable Outlook 2007 / Outlook 2003 archiving options for users, due to company policy requirements or because they use third party software to backup / remove old emails from Exchange Mailboxes. We always can instruct our users not to use those options, however as we all know, quite often giving the instructions to users is not enough. Hence we need to know the proper way to force our desired settings. The best way to reconfigure some settings is to use Group Policy Object, of course if we have Active Directory implemented, because it is the easiest and fastest way to change something for multiple computers or multiple users.

Categories:

Check Free Space on Disk in Windows

Sometimes it is handy for Windows Administrators to check free space on the volume from command line. That task can be accomplised by using fsutil command. The full syntax for checking free space on volume c: is fsutil volume diskfree c:

Categories:

How To Check Authentication Mode in Microsoft Sql Server

Microsoft Sql Server can operate in two Authentication Modes, the first is Windows Authentication, and the second is Mixed Mode. In Windows Authentication Mode only the users, which have Windows Accounts (either Active Directory or Computer Accounts) can login to Sql Server. In Mixed Mode we can create in Sql Server logins, which do not have corresponding Windows Accounts. Windows Authentication Mode is suggested by Microsoft as the best practice; however Sql Server DBAs often have to configure Mixed Mode, because there are numerous applications on the market, which requires it. Ability to quickly check authentication mode of Sql Server is crucial if we are performing an audit or we have to work on an instance, on which we do not know anything.

Special characters in C#

There are some characters in .NET that were labeled special. For example how would we represent a single quote in a string or a tabulator? We would use escape character, which is backspace (\). Escaping character just means putting backspace in front of special character. Below program shows this concept in more detail.

Categories: