Does a Primary Key always have stats_id 1?

Back to the SQL Server Basics with Wayne

The Myth
I recently was attending a presentation where the presenter stated that the...

Mastering Index Tuning–Day 1

This is a short series of posts on the courses I took with Brent Ozar. I actually completed the courses...

Use SSMS with a Different Windows Account – Back to Basics

Runas should be a very common tool in the toolbox of all IT professionals - not just Data Professionals. Learning how to test different accounts is essential to being...

Use SSMS with a Different Windows Account – Back to Basics

One of the tasks I find myself doing on a fairly regular basis is running SSMS as a different Windows...

Check instant file initialization and lock pages in memory options

Study your server reports do the work for you!
Instant file initialization and lock pages in memory are 2 windows operating...

Notes From SQLSaturday Houston 2018

Various and possibly amazing notes:
Because I waited too long the best flight I could get was into George Bush instead...

Tools to connect to a SQL database

Today I'm getting back to basics, whether you are new or veteran with the database engine you need a tool to get into, write queries, do some monitoring, tuning,...

Power BI Custom Visuals Class (Module 109 – as Timeline)

In this module you will learn how to use the as Timeline visual. The as Timeline is a Gantt chart...

Tools to connect to a SQL database

Today I'm getting back to basics, whether you are new or veteran with the database engine you need a tool...

Update your production servers and stop making excuses about it

Folks, we all like to make sure we’re doing our level best to make things work smoothly. So why am...