Sql Server Special Table Types

Special
Table Types

Objective of this post is to provide a list of special
tables available in Sql Server and brief description of...

Reminder: Webinar today

This is a reminder that I’ll be giving a webinar today on managing SQL Server Agents jobs in a SQL...

Sql Server - Finding Duplicate Indexes

If you are reading this article, I assume
that you have basic knowledge of Index, its types and usage.

Over the...

Recap of My 24HOP Session – From XML to JSON

Yesterday I presented my session From XML to JSON as part of the 24 Hours of PASS online event. There...

This Week in Data – Episode 3 (What is the Internet of Things (IoT)?)

Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...

Kilt Day! PASS Summit 2016, Thursday

Thursday at the PASS Summit is Kilt Day.
This means you should wear a kilt. Whether you do it in support...

Defending your data

Which of these is more secure?

shilmar / Pixabay
Nicolas Chadeville / 500pxIt’s a trick question – the correct answer is “neither”.
Both castles and vaults...

Join me and Kalen Delaney today for 24HOP

I’m excited to be monitoring Kalen’s session on concurrency. The session is today and is titled “Locking, Blocking, Versions: Concurrency...

Top 5 SQL Server Books for the DBA

The Top 5 series has proved rather popular. My Top 5 books for Enterprise Architecture was the most popular post in...

Reminder: #SQLChat at lunch today

This is a reminder that we’ll having a #SQLChat this afternoon at 12 PM EDT. Here are the details:
SQLChat: Do...