SQL Server Education (by the geeks, for the geeks)
This article first appeared in the SQLServerGeeks Magazine. Author: Satya Ramesh. Subscribe to get your copy. In this blog we will prove the point that both the truncated and deleted data …
Rollback the truncate using backups Read MoreThis article first appeared in the SQLServerGeeks Magazine. Author: Erland Sommarskog Subscribe to get your copy. This article is based on something I originally learnt from a blog post from my …
A tip about intersect Read MoreThis article first appeared in the SQLServerGeeks Magazine. Author: Josephine Bush Subscribe to get your copy. In this article, you will learn about the different methods for auditing in Azure SQL …
HANDLE AZURE SQL AUDITING WITH EASE Read MoreThis article first appeared in the SQLServerGeeks Magazine. Author: Amit Bansal Subscribe to get your copy. Let’s understand a few reasons why SQL Server (sometimes) does not show missing index hints. …
Why Missing Index Hints Are Missing Read MoreThis article first appeared in the SQLServerGeeks Magazine. Author: Erland Sommarskog Subscribe to get your copy. You probably use both inner joins and left outer joins day in and day out, …
A Tip about Full Outer Join by Erland Sommarskog Read MoreThis article first appeared in the SQLServerGeeks Magazine. Author: Bob Ward Subscribe to get your copy. A few weeks ago we announced the next major release of SQL Server: SQL Server …
Introducing SQL Server by Bob Ward Read MoreThis article first appeared in the SQLServerGeeks Magazine. Author: Matt Luckham Subscribe to get your copy. JSON has become the standard transmission protocol between front ends and your cloud API. Typically, …
Using JSON Objects with SQL Server 2016 and Above by Matt Luckham Read MoreThis article first appeared in the SQLServerGeeks Magazine. Author: Erland Sommarskog Subscribe to get your copy. I ended my tip in the most recent SQLServerGeeks Magazine with a cliff-hanger. In my …
A Tip About Packaging Permissions in Stored Procedures by Erland Sommarskog Read MoreThis article first appeared in the SQLServerGeeks Magazine. Author: Jason M. Anderson Subscribe to get your copy. Cryptographic verification in Azure SQL Database ledger In the above article, I covered the …
Azure SQL Database ledger PART 2 by Jason M. Anderson Read MoreThis article first appeared in the SQLServerGeeks Magazine. Author: Jason M. Anderson Subscribe to get your copy. Blockchains aren’t always the answer Blockchain has been a hot topic over the past …
Azure SQL Database ledger PART 1 by Jason M. Anderson Read More