SQL Server – RECONFIGURE
When you want to change configuration settings for your SQL Server you would either do it via Management studio (under...
2016-11-08
715 reads
Finding Deprecated Uses in SQL Server
Do you know that your Server logs 300 million deprecation events a week? Do you know if code needs to be updated or how to find deprecated uses in...
2016-11-07
15 reads
Finding Deprecated Uses in SQL Server
How well do you know your environment? You probably know all of the jobs that are running, the frequency that...
2016-11-07
2,044 reads
Please Lend Me Your Vote for Documentation of TMSCHEMA DMVs
I spent a good bit of time looking for the definitions/descriptions of the TMSCHEMA DMVs that allow us to view...
2016-11-07
775 reads
Monday Morning SQL Break – November 7, 2016
It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch...
2016-11-07
38 reads
Monday Morning SQL Break – November 7, 2016
It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on...
2016-11-07
809 reads
Power BI Custom Visuals Class (Module 24 – Globe Map)
In this module you will learn how to use the Globe Map Power BI Custom Visual. The Globe Map is...
2016-11-07
928 reads
When disks have different sector sizes for primary and secondary replica log files in an AlwaysOn Availability Group Config
Recently I was analyzing a stress test result for an AG configuration, and as usual I was reading to SQL error logs to see if there is anything out of...
2016-11-07
13 reads
When disks have different sector sizes for primary and secondary replica log files in an AlwaysOn Availability Group Config
Recently I was analyzing a stress test result for an AG configuration, and as usual I was reading to SQL error...
2016-11-07
1,615 reads
sp_executesql Is Not Faster Than an Ad Hoc Query
This requires an immediate caveat. You should absolutely be using sp_executesql over any type of non-parameterized execution of T-SQL. You...
2016-11-07
1,208 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Forums
SQL Server Storage Optimization: Multiple Files in a Filegroup vs Dedicated File
Hello, I would like to get some feedback regarding the best storage optimization strategy...
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers