Blog Post

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...


305 reads

Blog Post

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...


1 reads

Blog Post

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...


1,005 reads


Extended Events in Azure Data Studio


I know I can use extended events (xevents) in Azure SQL DB when in...

Azure Workbooks


I’m saddened that the Workspace Summary is being deprecated in Log Analytics Workspace. I...

SQL Prompt Tips–Using $surroundtext$ in a Snippet


A user on the SQL Community Slack was asking about what the $surroundtext$ variable....

Read the latest Blogs


Reduction of installation time of sql server 2008 R2 Express

By IT researcher

The installation of SQL Server 2008 R2 Express on a virtual machine takes around...

Creating Aggregates

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating Aggregates

Getting Started with DDL statements of Cassandra Query Language

By Shivayan Mukherjee

Comments posted to this topic are about the item Getting Started with DDL statements...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers