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