Tuning Azure SQL Elastic Pools
The below image is a beautiful picture, now it could be worse. The red line and the green line could peak at the same time and for a very...
2019-04-11
151 reads
Blog Posts
Database Recovery Monitoring with XE
Database recovery (crash recovery) is a nerve wrenching situation under the wrong conditions. It can be as bad as a root canal and just as necessary to endure that...
2019-04-10
8 reads
Notes from SQLSaturday Tampa 2019
Late notes! Great signs at the event, all hand written on flip chart paper. Cheap and effective, the “different” nature of the signs made them easy to spot Rooms...
2019-04-10
12 reads
Power BI Now Has Keyboard Accessible Visual Interactions
The March 2019 release of Power BI Desktop has brought us keyboard accessible visual interactions. One of Power BI’s natural...
2019-04-10 (first published: 2019-03-21)
1,870 reads
SSIS and Data Quality Webcast
On Thursday the 2nd of May, I’ll be giving a webcast for MSSQLTips.com about data quality and SSIS. The abstract: SQL Server Integration Services (SSIS) has been around for...
2019-04-10
23 reads
Uppercase All String Columns (and in a Single Query!)
(last updated: 2019-03-21 @ 15:00 EST / 2019-03-21 @ 19:00 UTC )
Intro
The other day, Steve Jones published a short post with a quick...
2019-04-10 (first published: 2019-03-20)
1,476 reads
Using a home-grown Azure Blob Storage solution for SQL Server backups
I’m here for the small organizations, the shops that can’t afford expensive solutions to maintain their environments. I’m here for them because that’s me: the one-person consultancy. I’ve built...
2019-04-10
20 reads
Data Type Precedence and Implicit Conversions
Watch this week's video on YouTube
SQL Server needs to make sure data types match when performing operations that involve multiple pieces of data.
When the data types do not match,...
2019-04-09
1 reads
Data Type Precedence and Implicit Conversions
Watch this week's video on YouTube
SQL Server needs to make sure data types match when performing operations that involve multiple pieces of data.
When the data types do not match,...
2019-04-09
5 reads
Delete activity in Azure Data Factory - Cleaning up your data files
(2019-Mar-20) File management may not be at the top of my list of priorities during data integration projects. I assume that...
2019-04-09 (first published: 2019-03-20)
4,530 reads
Blogs
Troubleshooting TempDB Log Full Errors When SSMS Won’t Connect
By gbargsley
Have you ever received the dreaded error from SQL Server that the TempDB log...
Accelerating AI with Confidence: Why Microsoft Purview is Key to Responsible Innovation
By Chris Yates
Artificial intelligence is no longer a distant concept. It is here, embedded in the...
The Mystery of SQL Server 2025’s New Tricks – Scooby Dooing Episode 5
Every Scooby-Doo mystery starts with a haunted house, a strange villain, and a trail...
Forums
statistics callection intervel in query store ?
Statistics Collection Interval: Defines the level of granularity for the collected runtime statistic, expressed...
Rounding Off issue in SQL Server
I am using Microsoft SQL Server 2022 (RTM-CU17) (KB5048038) - 16.0.4175.1 (X64) Microsoft Corporation...
how to get notification that my database has corssed 8gb
i have sqlexpress on rds, is there any way i can get notifacation that...
Question of the Day
SQL Server, Heaps and Fragmentation
A table without a clustered index (heap) will NOT suffer from fragmentation during frequent updates or deletes. True or False?
See possible answers