Free SQL Data Compare

• by jsterrett

• John Sterrett

I am a consultant in Austin who can help make your data go fast, be secure and highly available. When I am engaged in a performance tuning project priority...

2020-04-20

20 reads

Query Store for Workload Replays

• by jsterrett

• John Sterrett

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: 2020-03-11)

323 reads

Import Databases to Azure SQL Database

• by jsterrett

• John Sterrett

I recently spoke at a conference and was asked what is the easiest way to import databases to Azure SQL Database. Therefore, I wanted to share how I do...

2020-03-12 (first published: 2020-03-04)

388 reads

Allow users to start/stop Azure VMs

• by jsterrett

• John Sterrett

Today I wanted to cover how you can grant the least privilege required to stop, start or restart an Azure VM. This is also a fun great example of...

2020-02-10 (first published: 2020-02-04)

953 reads

Previous SQL Server Updates

• by jsterrett

• John Sterrett

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: 2020-01-09)

438 reads

Free SQL Server Training Videos

• by jsterrett

• John Sterrett

Hello everyone! This is your SQL Server Consultant in Austin, TX and due to some posts on twitter about SQL PASS recordings costing $999 I wanted to share some...

2019-12-27

53 reads

5 Game Changers with SQL Server 2019

• by jsterrett

• John Sterrett

Microsoft made SQL Server 2019 Generally Available this week we want to share some videos and code examples of our favorite new features. Most of these will make your...

2019-11-05

101 reads

Join us for FryeDay!

• by jsterrett

• John Sterrett

Once again it is PASS Summit week in Seattle. This is the biggest event in the world for SQL Server...

2018-11-07

146 reads

Join us for FryeDay!

• by jsterrett

• John Sterrett

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

2 reads

Best Hidden Feature in SQL Server 2019

• by jsterrett

• John Sterrett

With Microsoft’s Ignite conference this week a lot of new features are being advertised all over the internet.  Most likely...

2018-09-26

519 reads