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...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - Date: 02/14/2013

Blog Resources online again !

  I will write everyone who directed me directly again, but for those watching the blog, the...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - 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....

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - 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 ?...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - 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:...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - Date: 09/30/2009

SQLDays in Rosenheim Herbst 2009

  Thank for all participants attending my sessions in Mainz. As promised, here are the slide...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - Date: 09/27/2009

Problems opening your project files in Visual Studio ?

  if you encounter the problem as follows: <PathToyourDBFile> cannot be opened because...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - 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,...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - 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:...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - 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...

Author: Jens K. Suessmeyer - Date: 04/28/2009

Next>