We were experiencing trouble installing SQL Server 2014 onto a Windows 2012 R2 VM. These are new production boxes so I was being very careful. The problem manifest itself in two ways: * A clean installation using our service account got almost all the way through and then failed with the…
You can download the latest version of ClearTrace [http://www.scalesql.com/cleartrace/download.html] from my consulting site: scaleSQL Consulting [http://www.scalesql.com/]. I’ve decided to stop using the year as part of the version. I did that to match SQL Server branding but it doesn’t…
I’ve seen this error off and on in our environment for a while. The full error looks like this: Login failed for user DOMAIN\login’. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: X.X.X.X] Error: 18456, Severity: 14, State:…
SQL Saturday #300 [http://www.sqlsaturday.com/300/eventhome.aspx] is coming up right here in Kansas City on September 13th, 2014. This is our fifth SQL Saturday which means it's the fifth anniversary of our now infamous BBQ Crawl. We get together on Friday afternoon before the…
PASS launched a Global Growth Initiative in the Summer of 2011 with the appointment of three international Board advisors. Since then we’ve thought and talked extensively about how we make PASS more relevant to our members outside the US and Canada. We’ve collected much of that discussion in…
There’s another update to my little utility to script a SQL Server’s configuration [http://scriptsqlconfig.codeplex.com/]. I use this for two purposes. First, I use it to keep my database mirroring servers up to date. Second, I capture the output in a version control system and keep…
I’ve been gradually adding features to my utility that scripts the configuration of a SQL Server [http://scriptsqlconfig.codeplex.com/]. Since my last post I’ve added the following features: * Skip any encrypted object in a database * Script alerts, alert notifications and operators * Script audits * Always script model, master…
Nihao!One of the largest changes PASS is going through is the the expansion outside the US and Canada. We’ve had international chapters and events in Europe since the early 2000’s. But nothing on the scale we’re seeing now. Since January 1st there have been 18 SQL…
The next Kansas City SQL Saturday [http://www.sqlsaturday.com/159/eventhome.aspx] is coming up on August 4th. We’ll have the usual SQL Saturday goodness: lots of technical sessions, great networking events and a fantastic speaker dinner. And we’ll have the Third Annual Kansas City SQL Saturday…
I’ve updated the beta for ClearTrace that support SQL Server 2012 [http://www.scalesql.com/cleartrace/download.aspx]. This requires SQL Server 2012 to be installed on the computer where ClearTrace is running. It will read traces from SQL Server 2008 R2, SQL Server 2008 and SQL Server 2005.…