Presenting at SQLSaturday 149
Next Saturday, September 29th, I’ll be presenting at SQLSaturday #149 in Minneapolis, Minnesota – my home town. This will be the second SQLSaturday I’ve been
Next Saturday, September 29th, I’ll be presenting at SQLSaturday #149 in Minneapolis, Minnesota – my home town. This will be the second SQLSaturday I’ve been
As Paul recently announced, the entire SQLskills team will be rolling out SQL Server content across several subjects on Pluralsight.com. My latest course, “SQL Server:
I’ve been interested in exploring what changes may be coming through in SQL Azure (Windows Azure – “SQL Database” now) around query execution cost models
Books Online documents a few scenarios regarding Replication and Availability Group interoperability. Today I tested out the process detailed here: Configure Replication for AlwaysOn Availability
There are already a number of data sources you can reference when investigating replication issues. One data source on my wish list was to have
I had a recent consulting engagement where a query had unpredictable performance on an isolated test environment. I had two initial questions: – What were
SQLServerCentral published an article today that I wrote about SQL Server 2012’s execution plan parallel thread usage statistics: SQL Server 2012’s Information on Parallel Thread
Today I learned that the video course I’ve been working on these last two months has been published on Pluralsight: SQL Server: Transact-SQL Basic Data
SQL Server 2008 execution plans include an optional MemoryGrant attribute in the QueryPlan element – but SQL Server 2012 significantly expands on memory grant related
SQL Server 2012 includes a new RetrievedFromCache attribute in the query execution plan. Let’s say I execute the following query immediately after executing DBCC FREEPROCCACHE:
This post shows a few examples of Sort related SpillToTempDb execution plan warnings and the associated SpillLevel attribute. This blog post is based on
Unrelated to cramming for certification exams, but back in March I started getting strange text messages in the middle of the night – sometimes multiple
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.