Modernizing Your T-SQL: Trimming Strings
This is one of several posts on modernizing T-SQL code with new features and functionality available in SQL Server.
Last year, you finally retired the last of your SQL Server...
2020-03-17
3 reads
Blog Posts
T-SQL Tuesday #124 – Query Store Summary
Happy St. Patrick’s Day (are you wearing something green)! For March I asked everyone to blog something related to Query Store, here is a summary of in alphabetical order...
2020-03-17
1 reads
T-SQL Tuesday #124 Query Store and Spin Locks #tsql2sday
This month’s T-SQL Tuesday invitation comes from Tracy Boggiano and she’s asking us to write about our experiences with Query Store. I thought about what I should write, I’m...
2020-03-17 (first published: 2020-03-10)
334 reads
Azure SQL DB – An instance-specific error occurred while establishing a connection to SQL Server.
The full message when connecting to your Azure SQL Database is: Reason: An instance-specific error occurred while establishing a connection to SQL Server. The public data endpoint on this...
2020-03-16
383 reads
Extended Events: system_health and a Long Running Query
Wouldn’t it be great to just quickly and easily take a look at your system to see if you had any queries that ran for a long time, but,...
2020-03-16 (first published: 2020-03-09)
559 reads
Improved VMware vCenter Performance Metric Logging
By default, the vSphere vCenter deployment contains a virtual appliance where the VMware management and orchestration platform, vCenter, resides and runs from. The default performance metric statistics collection interval...
2020-03-16 (first published: 2020-03-09)
270 reads
Learning some DAX
I’ve not done much BI work in my career, other than simple aggregates in reports. I’ve wanted to tackle projects, but I’ve rarely had a chance to spend time...
2020-03-16
216 reads
Power BI Sharing
There are many ways to share the dashboards, reports, and datasets that you create in Power BI. Below I’ll compare all such options (there are twelve!). First make sure...
2020-03-16
65 reads
SQLOrlando Update
We’ve cancelled our upcoming Meetups in April and May due the loss of our venue (due to corona virus worries) though we would have probably cancelled them anyway. Our...
2020-03-16
5 reads
SQLpassion in the time of Covid-19
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2020-03-16
1 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
Advice I Like: Praise
By Steve Jones
Don’t reserve your kindest praise for a person until their eulogy. Tell them while...
Forums
Is there a way to have dynamic table headers?
Hi everyone I have a SP which compares two tables and outputs mismatching entries:...
Learning a New Language
Comments posted to this topic are about the item Learning a New Language
is there a way to "detect" schema like changes on a server?
Hi, we have a few people who like to experiment on our prod sql...
Question of the Day
Copying Production Schema
If I use DBCC CLONEDATABASE, can I remove some of the information from the copy?
See possible answers