Developer hearted / Relational minded
[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...
Date: 05/05/2015
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...
Date: 06/24/2014
Thanks to all the users, contributors and reviewers of the backup and restore procedure I...
Date: 05/14/2014
[Updated]: Light weight SQL Server procedure auditing without using SQL Server auditing version 0.2.1.0
The most recent version can be found here (The detailed Information of the solultion is mentioned...
Date: 03/15/2013
Update( 30.06.2014): Beside the below mentioned information, I have written an updated...
Date: 03/06/2013
( Download at the end of the blog entry ) Testing with realistic parameter sets Ever wanted to test...
Date: 02/25/2013
While becoming familiar and a really big fan of PowerShell, I faced the following issue. During a...
Date: 02/14/2013
I will write everyone who directed me directly again, but for those watching the blog, the...
Date: 02/08/2013
(You find the script at the end of the blog post) People who inherit databases encounter often the...
Date: 01/30/2013
One big advantage over recent database projects is the ability to do headless build on a...
Date: 01/28/2013
While recently writing a windows service which should be a multi-instance Service, I encountered the...
Date: 01/14/2013
Some of us might be still bound to VSDBCMD instead of using the new tools of SSDT like SQLPackage....
Date: 01/10/2013
As I am hosting my sample files on an external server, you may experience a 404 downloading them at...
Date: 09/28/2012
(Updated version available here) As suggested by M Merrill in my former post of SQLCMDScriptExpander...
Date: 06/25/2012
As I was asked about a functionality how to check a string for being of the type GUID and only...
Date: 09/07/2011
Nothing really fancy, but a small script I was now asked twice for. So I thought I publish it for...
Date: 08/28/2010
After many months of hard work, collaboration, short weekends and nights, the new ALM Rangers...
Date: 08/21/2010
(Updated version available in this blog post) How can we expand files from a .sql file referenced...
Date: 08/16/2010
For those asking a couple of times if the JobScripter for SQL Server Agent jobs is also...
Date: 08/13/2010
Database internal file versions– How to determine if the database was upgraded or created from scratch
In some cases it it interesting to know whether a database was directly created on the...
Date: 07/28/2010
In some cases you might face the problem that SQL Server Agent Service didn't come up or was...
Date: 07/23/2010
A common question is how to move back to the older version of the database once upgraded. The...
Date: 07/19/2010
Some time ago I did a blog entry for SQL Server Integration Services packages as a data source for...
Date: 07/11/2010
Some time ago I got an interesting questions why the following applies: --drop table a create table...
Date: 07/10/2010
(The project is attached to this blog post, if you have any questions, feel free to send me a...
Date: 07/10/2010
Ever wondered what New! means if you see a report in SQL Server Reporting Services Manager ?...
Date: 01/24/2010
(Download the dbo.fndblog2 function here) Update and word of caution: Be aware that the...
Date: 11/18/2009
(Sample code included at the end of the post) The initiator for this post was Dan Atkins who...
Date: 11/06/2009
Someone pinged me according the article I wrote about SSIS as a data source in Reporting...
Date: 10/26/2009
After skipping some internal version the 0.3.3.0 is available now, these are the new features:...
Date: 10/23/2009
These are the new functionalities comparing the 0.2.3.1 version: -Added n-m mapping for...
Date: 10/17/2009
Running SQL Server Traces on SQL Server Express SQL Server Express does not come with a SQL Server...
Date: 10/03/2009
Head up, the new CU is ready ! This one is CU (Cumulative Update) 4 for SQL Server 2008 SP1...
Date: 10/03/2009
As it was hard to find the cause of this error and the answer, I wanted to share some searchable...
Date: 10/03/2009
Thank for all participants attending my sessions in Mainz. As promised, here are the slide decks and...
Date: 09/30/2009
Thank for all participants attending my sessions in Mainz. As promised, here are the slide...
Date: 09/30/2009
My colleague Marvelous Jimmy (JimmyMay) and myself did a small project to parse and interpret...
Date: 09/27/2009
if you encounter the problem as follows: <PathToyourDBFile> cannot be opened because...
Date: 09/25/2009
Ever had an error in your application and you couldn't find the source of all evil and where the...
Date: 09/25/2009
At the beginning everyone is trying to tune the database by creating additional database files,...
Date: 09/18/2009
Ward Pond, one of the marvelous SQL geeks within Microsoft published a nice thing wich we had a...
Date: 09/06/2009
Simple and easy, no coding or direct access needed to the report server database, simply put the...
Date: 09/01/2009
Get the latest and greatest CU package for SQL Server 2008 (RTM) –> CU6:...
Date: 07/28/2009
(UPDATE: Updated technical version is available through this blog post here. The basic information...
Date: 06/08/2009
As a follow-up to my former post “Why you shouldn't´trust the friendship of NULL and the...
Date: 05/25/2009
(Update: Due to security reasons the functionality retrieving data from SSIS packages has been...
Date: 05/11/2009
Ever wanted to get feedback and interim results like a progress from a stored procedure ? Well, not...
Date: 05/11/2009
Coming as a simple sample with PBM (creating a policy with a condition that procedure names...
Date: 04/28/2009