Kevin3NF

Data BIts – Episode 3 – Ginger Grant

Trainer and Consultant extraordinaire Ginger Grant stops by to talk Machine Learning, Data Bricks, Certifications, Norwegian pastries and proper chocolate frosting Find Ginger at Desert Isle SQL or on Twitter
The post Data BIts...

2020-04-01 (first published: )

186 reads

SQL Server HADR overview

My Pluralsight course for new SQL Server DBAs Image credit to Jeff (t) Back in June of 2019, I published this YouTube video covering the highlights of the various...

2020-03-25

32 reads

SQL Server Identity Skipping

My Pluralsight course for new SQL Server DBAs SQL Server may skip 1000 numbers on an Identity column if the server crashes. Here’s why: Too long, didn’t watch version:...

2020-02-04

Blogs

T-SQL Tuesday #125 – Unit testing databases – we need to do this!!

By

Welcome to the first April edition of T-SQL Tuesday. I’m honoured to be hosting...

T-SQL Tuesday Live–7 Apr 2020

By

Last week went a little crazy, and I learned something: don’t post a Zoom...

Getting Your dbatools Version–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Read the latest Blogs

Forums

Partitioning table techniques which one is best way?

By Saravanan_tvr

Hello All, I am about to do partitioning for my DW tables based on...

MAXDOP and cost threshold for parallelism settings

By vsamantha35

Hi All, On one of our newly migrated sup-prod azure vm which is running...

How not to have sql to restart on the same node but failover on 1st failure in a

By SQLRocker

Hi, By default sql tries to restart on the same node in case of...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers