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
Bulk Backup and Restore at the tip of your finger
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
Finally, the family…united. SQL Server BI Project templates now available in Visual Studio 2012
Update( 30.06.2014): Beside the below mentioned information, I have written an updated...
Date: 03/06/2013
SQL Server Reporting Services Load Simulator v 0.2.0.0
( Download at the end of the blog entry ) Testing with realistic parameter sets Ever wanted to test...
Date: 02/25/2013
PowerShell StdOut go out, StdErr go everywhere
While becoming familiar and a really big fan of PowerShell, I faced the following issue. During a...
Date: 02/14/2013
Blog Resources online again !
I will write everyone who directed me directly again, but for those watching the blog, the...
Date: 02/08/2013
Where have all the objects gone, long time passing ? (Version 0.1.0)
(You find the script at the end of the blog post) People who inherit databases encounter often the...
Date: 01/30/2013
Headless build can make you scratch your head (Part 1)
One big advantage over recent database projects is the ability to do headless build on a...
Date: 01/28/2013
Why the name of the service ist not the ServiceName, is not the ServiceName
While recently writing a windows service which should be a multi-instance Service, I encountered the...
Date: 01/14/2013
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....
Date: 01/10/2013
Outage: External sample server down
As I am hosting my sample files on an external server, you may experience a 404 downloading them at...
Date: 09/28/2012
Update to SQLCmdScriptExpander => 0.2.0.0 is out
(Updated version available here) As suggested by M Merrill in my former post of SQLCMDScriptExpander...
Date: 06/25/2012
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...
Date: 09/07/2011
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...
Date: 08/28/2010
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...
Date: 08/21/2010
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...
Date: 08/16/2010
Script out jobs in SQL Server v2
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
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...
Date: 07/23/2010
Database internal file versions–Where is the Undo button for a database upgrade ?
A common question is how to move back to the older version of the database once upgraded. The...
Date: 07/19/2010
SSIS as a data source for SSRS–where is it gone for SQL Server 2008 R2
Some time ago I did a blog entry for SQL Server Integration Services packages as a data source for...
Date: 07/11/2010
Usage of @@Trancount in DML statements
Some time ago I got an interesting questions why the following applies: --drop table a create table...
Date: 07/10/2010
Light weight SQL Server procedure auditing without using SQL Server auditing version 2
(The project is attached to this blog post, if you have any questions, feel free to send me a...
Date: 07/10/2010
The New! report in town
Ever wondered what New! means if you see a report in SQL Server Reporting Services Manager ?...
Date: 01/24/2010
Want to know what happened on your database by reading the transaction log ?
(Download the dbo.fndblog2 function here) Update and word of caution: Be aware that the...
Date: 11/18/2009
An “secret” SSIS XML Destination Provider you might not found yet
(Sample code included at the end of the post) The initiator for this post was Dan Atkins who...
Date: 11/06/2009
SSIS as a data source needed ? Watch out for configuration traps
Someone pinged me according the article I wrote about SSIS as a data source in Reporting...
Date: 10/26/2009
SQLIOSIMParser 0.3.3.0 is available
After skipping some internal version the 0.3.3.0 is available now, these are the new features:...
Date: 10/23/2009
SQLIOSimParser 0.3.1.0 is available
These are the new functionalities comparing the 0.2.3.1 version: -Added n-m mapping for...
Date: 10/17/2009
Jump on the Express Trace if you can – SQL Server Express server side tracing
Running SQL Server Traces on SQL Server Express SQL Server Express does not come with a SQL Server...
Date: 10/03/2009
New Cumulative Update for CU4 for SQL Server 2008 SP1
Head up, the new CU is ready ! This one is CU (Cumulative Update) 4 for SQL Server 2008 SP1...
Date: 10/03/2009
Project corruption after upgrade VSTSDB & Unit tests
As it was hard to find the cause of this error and the answer, I wanted to share some searchable...
Date: 10/03/2009
Basta Herbst 2009 in Mainz
Thank for all participants attending my sessions in Mainz. As promised, here are the slide decks and...
Date: 09/30/2009
SQLDays in Rosenheim Herbst 2009
Thank for all participants attending my sessions in Mainz. As promised, here are the slide...
Date: 09/30/2009
Need more spare time ? Use SQLIOSimParser to interpret your IO results !
My colleague Marvelous Jimmy (JimmyMay) and myself did a small project to parse and interpret...
Date: 09/27/2009
Problems opening your project files in Visual Studio ?
if you encounter the problem as follows: <PathToyourDBFile> cannot be opened because...
Date: 09/25/2009
Cannot find the source of a SQL Server error ?
Ever had an error in your application and you couldn't find the source of all evil and where the...
Date: 09/25/2009
(Log) resistance is futile – how to drop log files
At the beginning everyone is trying to tune the database by creating additional database files,...
Date: 09/18/2009
Database Programming: Did You Know IN Can Do This?
Ward Pond, one of the marvelous SQL geeks within Microsoft published a nice thing wich we had a...
Date: 09/06/2009
List reports of a Reporting Services instance via rs.exe script
Simple and easy, no coding or direct access needed to the report server database, simply put the...
Date: 09/01/2009
CU6 for SQL Server 2008 / CU3 SQL Server 2008 SP 1 are out
Get the latest and greatest CU package for SQL Server 2008 (RTM) –> CU6:...
Date: 07/28/2009
Light weight SQL Server procedure auditing without using SQL Server auditing
(UPDATE: Updated technical version is available through this blog post here. The basic information...
Date: 06/08/2009
The “magic” about trustable relationships with NULL and NOT IN
As a follow-up to my former post “Why you shouldn't´trust the friendship of NULL and the...
Date: 05/25/2009
Consuming SSIS package data in Reporting Services (and using Web Services in addition) Part 2
(Update: Due to security reasons the functionality retrieving data from SSIS packages has been...
Date: 05/11/2009
Getting feedback / progress from batches and stored procedures
Ever wanted to get feedback and interim results like a progress from a stored procedure ? Well, not...
Date: 05/11/2009
A long (but not missed) friend revisited, prefixing stored procedures with SP_
Coming as a simple sample with PBM (creating a policy with a condition that procedure names...
Date: 04/28/2009