SQL Server ODBC Driver for Linux
The Microsoft SQL Server ODBC Driver for Linux provides native connectivity from Linux to Microsoft SQL Server. Just released 11/21/2011 – Linux ODBC driver for… Read More »SQL Server ODBC Driver for Linux
SteveStedman
SQL Server 2012 Licensing Changes
One of the big changes in the SQL Server 2012 licensing plans is the price is now per core, and not per processor. So previously… Read More »SQL Server 2012 Licensing Changes
Restoring A Log Chain
This is a followup to my Whats more important than a backup plan article posted a couple of months ago. When you do a database… Read More »Restoring A Log Chain
New – SQL Server Health report
Over the last couple of weeks I have taken a couple of the common queries that I use to analyze the health of a SQL… Read More »New – SQL Server Health report
Index Fragmentation and SHRINKDATABASE
Is it a good idea to run DBCC SHRINKDATABASE regularly? Download the sample file ShrinkSample. This article and samples apply to SQL Server 2005, 2008,… Read More »Index Fragmentation and SHRINKDATABASE
DevConnections – SQL Server Track
This week I am in Las Vegas attending the DevConnections conference on the SQL Server track.
Converting part of a result set to a comma separated list
One of the common task that I have come across is the need to convert a list of results into a comma separated list. There… Read More »Converting part of a result set to a comma separated list
Whats more important than a backup plan?
A restore plan of course is far more important than the backup plan. When things go wrong and you need to restore a database backup,… Read More »Whats more important than a backup plan?
Code Name Denali
SQL 2012 is being referred to by Microsoft as code name Denali.
Finding the names of all indexes on a SQL Server
I needed a way to list of of the indexes for an entire database, but I was running into a problem using sys.indexes that I… Read More »Finding the names of all indexes on a SQL Server