Share via


Developer hearted / Relational minded

  (The new solution can be downloaded here) (The detailed Information of the solution is...

Date: 05/05/2015

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

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

  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

Next>