SQL Server Blog

Error 18456 is the generic error message for Login Failures in SQL Server. Depending on your situation this could be a simple misspelled password or the windows account does not have permission to the Instance and/or database. However I am not looking at those simple issues around this SQL Server error message. 

“Error: 18456, Severity 14, State 38. Login failed for user 'DomainServiceAccountName'.  Reason : failed to open the explicitly specified database.

High CXPacket Wait counts in an OLTP environment can be used as an indication towards performance issues relating to Query Parallelism in your environment due to having multiple cores available. 

With SQL Server 2012 due to be released sometime hopefully in the first half of 2012 some of us need..

As a DBA or Consultant, Database Maintenance is one of the most important tasks that needs to be implemented. What..

Microsoft introduced the Common Table Expression (CTE) with the release of SQL Server 2005, so it has been around for..

Microsoft Baseline Security Analyzer 2.2 (MBSA) is a tool that provides a streamlined method of identifying any missing security updates..

When preparing for a SQL Server installation, whether that be for a Stand-alone Instance or a clustered Instance, using a..

With the release of SQL Server 2012 sometime within the first 6 months of 2012, Microsoft released recently a data..

With the announcement that Microsoft’s SQL Server code-name ‘Denali’ at SQL PASS 2011 to be known as SQL Server 2012,..

Are you using a version of SQL Server Express 2005, 2008, 2008 R2? Well these editions do not have the..

Previously I blogged about the release of the Compression Estimation Tool available for download from CodePlex. To read more about..

Following on from my previous blog on SQL Server Agent for SQL Server 2005 Express, this post is to run..