PASS Summit 2018 Pre-con: Digital Storytelling with Power BI
Mitchell Pearson, Brian Knight and myself will be presenting a full day pre-con as PASS Summit on Digital Storytelling with...
2018-05-10
739 reads
Mitchell Pearson, Brian Knight and myself will be presenting a full day pre-con as PASS Summit on Digital Storytelling with...
2018-05-10
739 reads
In this module you will learn how to use the Slim Data Bar KPI Visual. The Slim Data Bar KPI...
2018-05-22 (first published: 2018-05-09)
2,344 reads
This month I continued a new series with Manuel Quintana [Blog | Twitter] to help you stay on top of the...
2018-05-15 (first published: 2018-05-08)
2,905 reads
In this module you will learn how to use the Tachometer. The Tachometer for communicating performance against a goal.
Module 101...
2018-05-08 (first published: 2018-05-02)
2,232 reads
In this module you will learn how to use the Flow Map. The Flow Map is useful for tracking direction...
2018-04-23
499 reads
In this module you will learn how to use the Drill-Down Donut Chart. The Drill-Down Donut Chart allows you to...
2018-05-01 (first published: 2018-04-19)
3,509 reads
In this module you will learn how to use the Hierarchy Chart. The Hierarchy Chart displays hierarchical data in a...
2018-04-17 (first published: 2018-04-12)
2,491 reads
Welcome to a new series that Manuel Quintana [Blog | Twitter] and I are starting where we will cover some of...
2018-04-04
431 reads
In this module you will learn how to use the Enlighten Data Story. The Enlighten Data Story allows you to...
2018-04-10 (first published: 2018-04-03)
2,340 reads
In this module you will learn how to use the Enlighten Waffle Chart. The Enlighten Waffle Chart is a simple...
2018-04-03 (first published: 2018-03-27)
2,539 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