remi's adventures in the database realm

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