Query Store, Plan Forcing and Table Variables
This weekend I was in Stockholm in Sweden, talking Query Store and plan forcing with Steinar Anderson, when he mentioned the problems he had while forcing plans that had...
2019-05-06
155 reads
This weekend I was in Stockholm in Sweden, talking Query Store and plan forcing with Steinar Anderson, when he mentioned the problems he had while forcing plans that had...
2019-05-06
155 reads
One part of my job is to understand the compliance landscape. This means that I read a lot about the GDPR and related similar laws. I also have to...
2019-05-03 (first published: 2019-04-22)
491 reads
The OUTER JOIN returns one complete set of data and then the matching values from the other set. The syntax is basically the same as INNER JOIN but you...
2019-04-25 (first published: 2019-04-15)
693 reads
GDPR enforcement began in May of 2018, but if you are doing business in the US, you may not think it applies to you. Grant Fritchey explains why you might be wrong about that and why you need to act now.
2019-04-16
I’m starting the process of learning how to use Jupyter Notebooks. Notebooks are documents that contain live code, commentary, results, pictures and more. Jupyter Notebooks are used for presentations,...
2019-04-08
34 reads
I was inspired by Jen McCown’s story here. Read that first. It’s WAY better than mine. This is not an April Fools post. Fools are involved, but none were...
2019-04-01
111 reads
Last week was the MVP Summit. This year included a bunch of very technical discussions about some of the future of the Microsoft Data Platform (a big thank you goes to Slava Oks, Bob Ward, and all the team for a great job). I can’t share much since it was all under NDA. All I […]
2019-03-30
507 reads
I love the questions I get when presenting: Can You Force a Parallel Plan in Query Store. I haven’t a clue. The trick I think is going to be...
2019-03-25
81 reads
I’ve shown before how to use the DMVs that read the plan cache as a way to connect the missing...
2019-03-22 (first published: 2019-03-11)
2,357 reads
You absolutely need to know about the servers you have under management in your estate. You need to know about...
2019-03-19
465 reads
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Comments posted to this topic are about the item The Microsoft SQL Year in...
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Comments posted to this topic are about the item Your Value from a Conference
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A:
B:
See possible answers