Abstracts submitted to SQL Saturday
I just submitted abstracts to SQL Saturday #114 in Vancouver and #108 in Redmond. The Redmond SQL Saturday appears to be the more popular of… Read More »Abstracts submitted to SQL Saturday
SteveStedman
Error code 0x85640004 when installing SQL Server 2012 RC0 on a Non Domain Computer
Today I ran the install of SQL Server 2012 RC2 on another computer this time a Windows 7 computer not on a domain. Here is… Read More »Error code 0x85640004 when installing SQL Server 2012 RC0 on a Non Domain Computer
Virtual SQL Server Class Survey #1
I am creating a SQL Server web based class to be held on a weekly basis. If you were to attend, what time would work… Read More »Virtual SQL Server Class Survey #1
A Fun Thanksgiving Day Query.
Download the Thanksgiving query sample code here. I thought it would be fun to put together a query to get us in the spirit of Thanksgiving… Read More »A Fun Thanksgiving Day Query.
SQL Server 2012 Compatibility Level
SQL 2012 Compatibility Level With SQL Server 2012, there was a new compatibility level being introduced, level 110 the new SQL 2012 compatibility level. SQL Server can… Read More »SQL Server 2012 Compatibility Level
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
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