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 the two. Who knows if my session will get accepted, but I am giving it a shot. Using SSRS reports to analyze SQL Server health Assessing the health of your SQL Server with Several …
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 the trouble that I ran into. SQL Server Setup has encountered the following error: There was a failure to validate setting CTLRUSERS in validaton function ValidateUsers. Error code 0x85640004. Then immediately after, I …
Error code 0x85640004 when installing SQL Server 2012 RC0 on a Non Domain Computer Read more »
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 best for you? If none of those times work, please add a comment with a suggested time. Thanks for your input.
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 dinner tonight. This query is using techniques from another recent posting on CSV formatting query output. Here is my Thanksgiving gift to you, the Thanksgiving day query. Don’t copy and paste, your browser …
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 run in a number of different compatibility levels, but how do you change it and how do you set it. These compatibility levels reflect the version of SQL server. 60 = SQL Server 6.0 65 …
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 SQL server. http://www.microsoft.com/download/en/details.aspx?id=28160 Hopes: I hope this is better than the original SQL Server driver for PHP. I hope this driver will work on other Linux distributions besides Red Hat.
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 if you had a SQL Server with 2 procesors (8 cores each), you paid for 2 licenses. Now in that same scenario, you would pay for 16 core licenses. Although the core prices are less …
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 restore, including log backups, it is very important to get the log chain in the right order, or it won’t work. To restore a full backup, then log backups, the chain of logs could be …
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 Server and built them out into a SQL Server 2008 SSRS report. I have decided to make this report available to anyone who want to run it. The SQL Server Health report is available to …
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, and 2008R2. This really depends on a number of factors, but generally the answer is NO, it is not a good idea to run DBCC SHRINKDATABASE regularly. For the purpose of this article, I am …