Data Breaches: All Your Fault
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…
Grant Fritchey
GDPR in the USA
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
Database Fundamentals #21: Using the JOIN Operator, OUTER JOIN
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…
Learning Jupyter Notebooks
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,…
Jobs That Beat The Caring Out Of You
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…
Containers Are The Present, Not the Future
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 […]
Can You Force A Parallel Plan in Query Store?
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…
Monitoring Your Databases and Servers and…
You absolutely need to know about the servers you have under management in your estate. You need to know about…
Monitoring Your Databases and Servers and…
You absolutely need to know about the servers you have under management in your estate. You need to know about the databases. Uptime, performance, behaviors, errors, corruption and a…
Compliance Ain’t Easy
I’m sure by now you’ve heard of the GDPR and some of the large scale data breaches that have occurred…
Blogs
CISA Accredited Trainer!
By Brian Kelley
My certification came in! I’m now accredited to provide training for the Certified Information...
Correlated Subqueries vs Derived Tables
By Bert Wagner
Correlated subqueries provide an intuitive syntax for writing queries that return related data. However,...
Video – Creating Azure SQL Database
By Arun Sirpal
A quick 2 minute upload (with sound, my voice) showing you how easy it...
Forums
Can Azure Stack Reduce Software Development Costs?
Comments posted to this topic are about the item Can Azure Stack Reduce Software...
Splitting a multi-dimensional Array in SQL Server 2012
Hello, I have data from an Orders table has the following columns; OrderId (int)...
Ask SSC