SQL Saturday Jacksonville – May 14th, 2022
Hi Everyone, This is your Austin SQL Server Consultant and I will be speaking at SQL Saturday Jacksonville. I am happy to get back out and, on the road,...
2022-05-13
8 reads
Hi Everyone, This is your Austin SQL Server Consultant and I will be speaking at SQL Saturday Jacksonville. I am happy to get back out and, on the road,...
2022-05-13
8 reads
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)
439 reads
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-14
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)
285 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-11
1 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)
608 reads
Update: Sept 14, 2021 Persist sample percent is fixed. The fix is now rolled into SQL 2016 SP2 CU17, SQL 2019 CU10, and the future SQL 2017 CU26. When a bug...
2020-08-24
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
108 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
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)
349 reads
By Steve Jones
Here are the slide decks for my sessions at SQL Saturday Jacksonville 2022 Continuous...
By James Serra
When using Power BI and pulling data from Azure Synapse, you will use the...
By MAMIR
Azure Privatelink provides private connectivity from an Azure Virtual Network to Azure PaaS such...
Hi Everyone, Currently looking at tidying up some SQL servers and i have a...
I'm Johnson, and I've just joined these forums. I was looking on Google for...
\hello Guys, Mayyou help wuth the corect index filetred creation using modulo? ...