T-SQL Tuesday 84 - Growing New Speakers
This month's #tsql2sday is being hosted by Andy Yun (b|t) and is about helping new speakers.
I have only been speaking...
2016-11-08
229 reads
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
711 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
13 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,040 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
771 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
27 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
799 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
926 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
8 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,607 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
advice on ssrs version control
Hi we're a bit behind on versioning ssrs. I think we have over 1600...
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers