SQL Server Diaries

In an earlier post I explained how we identified which indexes were being used, and the number of times used over a period of time. We had a good indication of a similar solution in a MSSQLTips article. [Read More]

A couple of scripts I use occasionally help me report the space used by FILEGROUP and the Log Space used are shown below in this article. [Read More]

In an organisation where Development, Test and Production environments are segregated and managed by a central team of DBAs sometimes developers or testers require a higher degree of privileges to specific users or groups of users in order to implement schema changes, creation of roles, etc. [Read More]

Sometimes we have a requirement to store unstructured files such as JPG, PDF, DOC, and even media files such as WAV, MP3, and AVI (to name a few) to an SQL Server database. Examples of such applications include forms (structured) which include photos, scanned images or documents, CV’s, and more.... [Read More]

There are various methods to load delimited files to a database. Some might opt to use SQL Server Integration Services (SSIS), others the BCP command line application, or write a .NET application which used the SqlBulkCopy Class, while some might choose one of the many non-Microsoft products available on the... [Read More]