sp_Blitz for All Servers

Are you a Microsoft SQL Server DBA managing one or more servers?  Then you should know about the First Responder Kit from Brent Ozar Unlimited.  This is a free...

2020-07-14

35 reads

BBQ Time in Texas

My first go at smokin’ a brisket is documented below. It is summertime and we are stuck at home in isolation, might as well find a new hobby. I...

2020-07-09

OLDEST_PAGE Log Reuse Wait type

Do you frequently use the “log_reuse_wait_type_desc” column in the [crayon-5f297eff3d7ff981952735-i/]  view? Have you ever seen the type of OLDEST_PAGE? You are not the only one!! Recently I was troubleshooting...

2019-09-24

17 reads

Blogs

VMworld 2020 – Top 10 Database Sessions (Part 1)

By

Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...

Daily Coping 24 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

VMworld 2020 SQL Server session preview

By

Join me, David Klee, Microsoft Data Platform MVP and VMware vExpert, for a preview...

Read the latest Blogs

Forums

Always On - tips for running large transactions

By NicHopper

Hi all, I wanted to get a second opinion on something, this weekend I...

Encrypted column copy

By IT researcher

I am using SQL Server 2008 R2. I have encrypted some of the columns...

SQL query error help

By rocky_498

Hi Guys, I have a table, around 320 fields. I am trying to use...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers