[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

Setting things in the right compatibility view (Visual Studio 2005 / 2008 / 2010 / 2012 / 2013 / BIDS / BI Development SSAS SSIS SSRS SSDT, SQL Server 2005 / 2008 / 2008R2 / 2012 / 2014)

  A very common request and question is (as I have to confess that this is confusing) is which version of SQL Server (SSMS – SQL Server Management Studio, BIDS – Business Intelligence Development Studio, VS- Visual Studio) does works together with which version of SQL Sever which target version and which project type. Here…

2

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

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

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

Did your SQL Agent doze off and you don´t know which jobs to run afterwards ?

  In some cases you might face the problem that SQL Server Agent Service didn’t come up or was stopped for reason. Jobs scheduled in the downtime will not run automatically when the Agent service comes up again, and that is a good thing. I often hear people saying, why isn’t that supposed to be…

9