Developer hearted / Relational minded

Perception vs. reality, how to keep your database schema changes of different environments aligned with VSTSDB and VSDBCMD.EXE Part 1

Yesterday at the PASS conference I met an former colleague and he asked me about a particular...

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

Consuming SSIS package data in Reporting Services (and using Web Services in addition) Part 1

(Update: Due to security reasons the functionality retrieving data from SSIS packages has been...

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

VSTS 2008 Database Edition GDR R2 is released

  The second release of the GDR was published today, it includes bug fixes as well as...

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

Getting relational data as well formed XML structures out of SQL Server

  I saw many times people having problems working with XML structures in SQL Server. It is that...

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

Getting a list of all facets and its properties

For those struggling as I did for getting the complete list of all facets and its properties...

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

SQL Server 2008 SP1 CU1 is out

For those waiting to update their CU4 fixed SQL Server 2008 server to upgrade to SP1 as they not...

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

SQL Server 2008 SP1 + CU1 or CU4 or what ?

I saw some confusion around the availability and difference of SP1 and CU4 on the web, therefore...

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

Who2 wants to process sp_who2 ?

SP_who2 has become a very handy tool for administrator, DBAs developers or all who are the...

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

Checking Failover after setting up a Database Mirroring

If you use database mirroring, the essence is that you use an additional connection property which...

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

TDS Protocol Versions meet client stacks

A colleague (Cornel Sukalla) asked me what the protocol_version in sys.dm_exec_connections is all...

Author: Jens K. Suessmeyer - Date: 03/02/2009

Need a good book for lonely evenings ? The new updated BOL 2008 (January 2009) is available !

For anyone who wants to dive into the differences to the previous version:...

Author: Jens K. Suessmeyer - Date: 02/03/2009

Script out Jobs in SQL Server

Do you want to script out the jobs available in SQL Server Agent ? There a many ways to skin the...

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

Change the edition in SQL Server 2008

Doing a SKUUPGRADE has changed a little bit in SQL Server 2008. Instead of using the SKKUUPGRADE...

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

Why a random row sometimes shows random data...

  Common scenario, you want a subset of data which is duplicate across some attributes but does...

Author: Jens K. Suessmeyer - Date: 01/19/2009

Determine the current status of a SQL Server Agent job

Due to the problem that there is no definite table for getting information about the current status...

Author: Jens K. Suessmeyer - Date: 01/08/2009

Tedious trigger generation getting simplified

While talking with a former colleague of mine, we were elaborating about methods for syncing...

Author: Jens K. Suessmeyer - Date: 01/08/2009

FriendlyDateDiff

One function which is often requested from my archived blog posts is dbo.FriendlyDateDiff. The...

Author: Jens K. Suessmeyer - Date: 11/03/2008

Basta / SQLCon 2008 Slides and samples online

Hi, here are the slides and samples from my presenations at the Basta. I will to a post-session blog...

Author: Jens K. Suessmeyer - Date: 10/01/2008

Merge it your own way -- Followup on the test

  After publishing the first test results on a previous post I got in contact with the product...

Author: Jens K. Suessmeyer - Date: 07/28/2008

CTP15 of the GDR release of VIsual Studio for Database Professionals is available

For everyone being curious about the product as me, here is the official announcement of the latest...

Author: Jens K. Suessmeyer - Date: 07/19/2008

Get all system databases of a server

The easiest way for querying all system databases of a server is to assume that databases create by...

Author: Jens K. Suessmeyer - Date: 07/16/2008

Problems installing Security Update for SQL 2005 SP2 (KB948109)

For the latest security update, there has been some confusion and problems installing it. There is...

Author: Jens K. Suessmeyer - Date: 07/16/2008

VSTS 2008 Database Edition GDR June CTP

Wow, the new release has just shown up. More information on...

Author: Jens K. Suessmeyer - Date: 06/04/2008

VSTS Database Edition having problem creating UnitTests

As some of you might already encountered and found this blog entry while searching the internet,...

Author: Jens K. Suessmeyer - Date: 05/07/2008

Changing the Login / Authentication Mode programmtically via SMO

Here are some instructions how to change the Login / authentication mode via Code. It just uses...

Author: Jens K. Suessmeyer - Date: 05/07/2008

Obfuscation is not a security feature – Spoofing the APP_NAME

SQL Server 2005 introduced an interesting and long demanded feature, the LOGON triggers. First only...

Author: Jens K. Suessmeyer - Date: 05/06/2008

Merge it your own way - Comparison of SQLAdapter vs. SQLCommand vs. MERGE

The question which always comes up in my sessions about SQL Server 2008 is according to my most...

Author: Jens K. Suessmeyer - Date: 05/04/2008

Linq to SQL materials of the SQL Server Developer Conference (SEK) in Nürnberg

Thanks for the interesting SQL Server Developer conference of Karl Donabauer. Scripts and Demos are...

Author: Jens K. Suessmeyer - Date: 04/30/2008

Enumerating Parameter Collection in SQL Server Reporting Services

Many of you often tried to and ask for how to enumerate the Parameters the collection. The MSDN has...

Author: Jens K. Suessmeyer - Date: 04/30/2008

We heard the voices... SP3 for SQL Server 2005 is coming

http://blogs.technet.com/dataplatforminsider/archive/2008/04/15/sql-server-2005-sp3-coming-soon.aspx...

Author: Jens K. Suessmeyer - Date: 04/17/2008

Determine the (available) amount of memory of a SQL Server (instance / machine)

Comming across a question of a colleague of mine, the following script can be used to determine the...

Author: Jens K. Suessmeyer - Date: 04/15/2008

Renaming sysprepred SQL Servers via script

Using syspreped images of SQL Server without any problems. There may be many of you using syspreping...

Author: Jens K. Suessmeyer - Date: 03/19/2008

Visual Studio Team Database Edition 2008 - Where to get SR1 for this ?

One of the most heard questions I get is: "Now that we have VS2008 Database Edition, where can we...

Author: Jens K. Suessmeyer - Date: 03/19/2008

Visual Studio 2005 Team System Database Professional post Service Release 1 (SR1) roll-up package 1 is now available

Long term, short story. Several issues and bugs are fixed within the rollup package which can be see...

Author: Jens K. Suessmeyer - Date: 03/12/2008

Custom Security in SQL Server Analysis Services 2005/2008

Sometime you might be stuck in a situation for Analysis Services where you have to pull of security...

Author: Jens K. Suessmeyer - Date: 03/05/2008

Basta Spring 2008 ! Slidedecks online

Vielen Dank an alle Teilnehmer meiner Sessions bei der Basta Spring 2008 in Mörfelden. Anbei die...

Author: Jens K. Suessmeyer - Date: 02/27/2008

Launch SQL Server 2008 samples online

Anbei die Slides und zusätzlich die Samples für TVF und Merge, die beim Launch für SQL Server 2008...

Author: Jens K. Suessmeyer - Date: 02/27/2008

SQL Server 2008 Launch Content und Fragen

Ich hoffe Sie haben das Launch Event in Frankfurt zu SQL Server 2008 / Windows Server 2008 und...

Author: Jens K. Suessmeyer - Date: 02/20/2008

A new blog was (re-)born !

Being blue-badged at the beginning of the current year, I moved my blog to the MSDN site, also due...

Author: Jens K. Suessmeyer - Date: 02/20/2008

<Previous