[Updated]: Light weight SQL Server procedure auditing without using SQL Server auditing version 0.3.0.0

  (The new solution can be downloaded here) (The detailed Information of the solution is mentioned here) After having seeing the solution settled in numerous projects and getting great feedback from you, I added the following request to the solution. Out-of-transaction support for Procedure Logging While you might run the logging within your own crafted…

0

The help for “The database schema provider could not be determined…”

Some of us might be still bound to VSDBCMD instead of using the new tools of SSDT like SQLPackage. As frustrating as it is, we need to also get around this and the limitations of the existing error Messages of VSDBCMD. The one you will encounter often is: The database schema provider could not be…

2

Update to SQLCmdScriptExpander => 0.2.0.0 is out

(Updated version available here) As suggested by M Merrill in my former post of SQLCMDScriptExpander (which can be found here), I added an option for providing the encoding of files. So I created another option where you can specify the encoding from the following options: /Encoding:[  ASCII |                     BigEndianUnicode |                     Default |                    …

6

Bulk Backup and Restore at the tip of your finger

(Code can be downloaded here) (A newer version of the code can be downloaded here) The Backup part “Can you please give me a recent backup of all user databases on that computer please ?” That is the sentence that will delay your planned work for the afternoon and will keep you busy for numerous…

14

IsGuid or not isGuid, that is the question…

As I was asked about a functionality how to check a string for being of the type GUID and only finding either solution with massive string operations, or using TRY..CATCH trying to CAST a value and then returning the CAST or CONVERT result, I created a new and simple one, based on a simple pattern…

2

Get the NULL percentage of values in a specific table dynamically

  Nothing really fancy, but a small script I was now asked twice for. So I thought I publish it for the public and for the reference for others. It simply calculates the percentage of NULL values for a specific table in all columns. The last request was originated from the post here. Be aware…

4

ALM Visual Studio Database Projects Guidance is out in the wild !

  After many months of hard work, collaboration, short weekends and nights, the new ALM Rangers guidance document is out covering Visual Studio Database Projects. Details about the documents and the documents themselves can be found here: Visual Studio Database Guide on Codeplex  You will find a General guidance Specific scenarios HOLs for each topic Solution…

3

Expand :r referenced files for SQLCMD into one file (SQLCmdScriptExpander)

(Updated version available in this blog post) How can we expand files from a .sql file referenced with the :r operator ? Ok, lets make a step back in the past and see how we used to reference files in .sql files and calling them via OSQL or ISQL. The answer is, we couldn’t. We…

5

Script out jobs in SQL Server v2

  For those asking a couple of times if the JobScripter for SQL Server Agent jobs is also available in 2008… here it is ! The only difference is that the version v2 is now targeting to SMO Assemblies of SQL Server 2008 which is version 10.0. This sure means that you are able to…

4