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]
This week I’m going to share a handy full database backup script which I find useful when I have to create an out-of-schedule full database backup. All I do is change the database name, the folder where the backup will be stored and execute. Of course this script does not...
[Read More]