Webinar Followup: Migrating your SQL Server VMs to Azure with PowerShell
Earlier this week I presented a free webinar for Pragmatic Works where I discussed how to migrate virtual machines to...
2015-11-19
1,303 reads
Earlier this week I presented a free webinar for Pragmatic Works where I discussed how to migrate virtual machines to...
2015-11-19
1,303 reads
Note this fix only works on Windows Server 2012/Windows 8 or later. A different method is required on Windows Server...
2015-10-27
11,268 reads
If you happen to be in the central Florida or Daytona area head over to Melbourne on September 10th to...
2015-09-02
1,098 reads
Moving data from columns to rows can be a tricky task and accomplished in a variety of ways. That may be...
2014-11-17 (first published: 2014-11-11)
7,949 reads
I recently did a presentation and discussed some techniques for monitoring the performance of your business intelligence stack. I will be doing...
2014-11-10
1,241 reads
I recently celebrated my 5 year anniversary at Pragmatic Works. Boy, how time flies by. It feels like just the...
2014-11-02
1,646 reads
Updated 10-16-2014 at 11:20 AM Eastern
Yesterday I presented about Change Data Capture for the Pragmatic Works Free Training on the...
2014-10-15
1,514 reads
Have you ever wanted to find out if someone is logged into a computer or maybe who is logged into...
2014-07-29 (first published: 2014-07-23)
10,155 reads
Yesterday I presented about Change Data Capture for the Pragmatic Works Free Training on the T’s. I covered the basics...
2014-07-25
1,459 reads
SharePoint uses a series of SQL Server databases to save configuration information, security setups and all the user data that...
2014-07-21
1,433 reads
This comic was retweeted into my timeline on Twitter (I refuse to call it...
By Steve Jones
Recently I’ve been looking at archiving some data at SQL Saturday, possibly querying it,...
By Brian Kelley
Just as it's important to take care of our physical health (and I'm guilty...
My agency has been using the combo of on-premises SQL Server for the back...
Development Environment I am learning how to use pyodbc and accessing database in SQL...
We are seeing multiple frequent deadlocks occurring with the following extract of code, which...
I want to enable two trace flags, 4199 and 4137, for a single query. How should I do this:
-- A SELECT a.AddressID , a.AddressLine1 , a.AddressLine2 , a.City , a.StateProvinceID , a.PostalCode , p.FirstName , p.LastName FROM Person.Address a INNER JOIN person.Person AS p ON p.rowguid = a.rowguid WHERE City = 'SEATTLE' AND PostalCode = 98104 OPTION (QUERYTRACEON 4199, 4137); -- B SELECT a.AddressID , a.AddressLine1 , a.AddressLine2 , a.City , a.StateProvinceID , a.PostalCode , p.FirstName , p.LastName FROM Person.Address a INNER JOIN person.Person AS p ON p.rowguid = a.rowguid WHERE City = 'SEATTLE' AND PostalCode = 98104 OPTION (QUERYTRACEON 4199, QUERYTRACEON 4137); -- C SELECT a.AddressID , a.AddressLine1 , a.AddressLine2 , a.City , a.StateProvinceID , a.PostalCode , p.FirstName , p.LastName FROM Person.Address a INNER JOIN person.Person AS p ON p.rowguid = a.rowguid WHERE City = 'SEATTLE' AND PostalCode = 98104 OPTION (QUERYTRACEON 4199), (QUERYTRACEON 4137);See possible answers