November 2011

SQL Server ODBC Driver for Linux

by SteveStedman
November 21, 2011November 25, 2011
Other

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

SQL Server 2012 Licensing Changes

by SteveStedman
November 21, 2011November 27, 2011
SQL 2012

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

by SteveStedman
November 19, 2011October 20, 2012
Recovery

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

by SteveStedman
November 19, 2011November 26, 2011
DBA, Server Health

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

by SteveStedman
November 12, 2011November 23, 2024
Performance

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