John Sterrett

Query Store for Workload Replays

UPDATE: 3/16/2020The first script below was updated from setting QDS to “Read_Write” instead of “Read_Only”. Martin thank you for pointing this out in your comment below. This month’s T-SQL...

2020-03-19 (first published: )

295 reads

Previous SQL Server Updates

Hello everyone, this is John your Austin SQL Server Consultant here and today I am going to answer a question that comes up often so I wanted to blog...

2020-01-20 (first published: )

434 reads

Join us for FryeDay!

Once again it is PASS Summit week in Seattle. This is the biggest event in the world for SQL Server and Microsoft Data Professionals to gather to connect, share...

2018-11-07

1 reads

Blogs

Daily Coping 7 Apr 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...

Reading a SharePoint List with Azure Logic App

By

Sometimes in life you have to do things you really don’t like to do....

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

Read the latest Blogs

Forums

Common schema in different Databases

By lfernigrini

Hi, I need to include a very simple schema in all of my database...

Permissions to Run CLR Assembly

By hawg

This is my first time dealing with CLR assemblies and we have setup some...

Convert date value

By pwalter83

Hi, I have a requirement to convert a date value like '7th March 2020' ...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers