./ mssql

I am an Oracle DBA (So you know the perspective of this category about that other rdbms)… On my current site we are now in the process of becoming responsible for over +20 SQL Servers, I’ll post anything I come around that I think is usefull.

osql switches

mssql January 30th, 2008

Some osql switches. read more →

Remove SQL Server database from single-user mode

mssql January 23rd, 2008

Braindump of a session where I had to remove a SQL Server database from single-user mode. read more →

Microsoft SQL Server 2005 JDBC Driver (oracle GRID)

mssql September 12th, 2007

Microsoft SQL Server 2005 JDBC Driver java test program. read more →

Create, drop and rename a database

mssql / administration November 16th, 2006 / August 20th, 2007

Create, rename and drop a database in sql server … read more →

Control Structures

mssql / t-sql November 15th, 2006 / August 20th, 2007

Control structures syntax; IF THEN ELSE, CASE, WHILE . read more →

Use filters to keep your traces meaningfull

mssql / sql trace November 14th, 2006 / August 20th, 2007

Say you have an sql trace for the event ‘TSQL SQL:StmtCompleted’ you are, most probably, NOT interested in the sql statements executed through the SQL Server Agent for instance. read more →

cursors in tsql

mssql / t-sql November 3rd, 2006 / August 20th, 2007

Cursors in tsql, it can be done … read more →

return variables from dynamic sql - sp_executesql

mssql / t-sql November 1st, 2006 / August 20th, 2007

Returing values into tsql variables from a dynamic sql statement using sp_executesql stored procedure. read more →

environment

mssql / t-sql September 18th, 2006 / August 20th, 2007

Getting around in the mssql environment read more →

Date Time functions

mssql / t-sql September 17th, 2006

Date time functions (frustrations) in T-SQL. read more →