Hi Everyone, this is John Sterrett. I am a SQL Server Consultant in Austin, TX. Last year I blogged about a feature called Persist Sample Percent. It had a...
2021-09-22 (first published: 2021-09-14)
326 reads
Want to make sure you don’t have errors, validate performance, and save money while making changes with Azure SQL Database, Azure SQL Managed Instance, SQL Server RDS in Amazon...
2020-09-18 (first published: 2020-09-11)
263 reads
When a bug jumps out and surprises me I like to share it so others do not run into the same unexpected result. I don’t think there is any...
2020-09-03 (first published: 2020-08-24)
602 reads
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
74 reads
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)
345 reads
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)
606 reads
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)
2,611 reads
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)
447 reads
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
65 reads
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
104 reads
By Steve Jones
When I was presenting at the dataMinds Connect conference, I called on someone in...
By Kevin3NF
I was chatting with Jeff (b|t) on my team yesterday and the context escapes...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Comments posted to this topic are about the item Maybe It Is DNS
Hello experts, Is there a ready-made query out there that I could run on...
I want to insert record job allocations only for selected jobs I know the...
Ask SSC