Dates and Times in SQL Server: the problem with DATETIME
Recently I wrote a post about date and time functions you should never use, which contained an opinion I’ve expressed...
2018-05-30
451 reads
Blog Posts
Getting value out of data quickly
There are times when you need to create a “quick and dirty” solution to build a report. This blog will...
2018-05-30
796 reads
Getting value out of data quickly
There are times when you need to create a “quick and dirty” solution to build a report. This blog will...
2018-05-30
364 reads
Importance of Statistics
Following up on my last post about the Cardinality Estimator let’s talk about column statistics and how they work and...
2018-05-30
587 reads
Lost that SQL Server Access?
Losing access to a SQL instance is never a desirable situation - for the DBA. When the people that are supposed to have access, lose that access, all hope...
2018-05-30
14 reads
Lost that SQL Server Access?
As a data professional can you recall the last time you needed to support a SQL Server instance for which...
2018-05-30
877 reads
The Importance of ORDER BY
Everyone, at the beginning of their SQL career, get’s told that it is important to include an ORDER BY if...
2018-05-30
421 reads
Azure PowerShell – List Virtual Machine Sizes
For those who use PowerShell to do things in Azure you will know that occasionally there is a parameter that you need to get right but are unsure of...
2018-05-29
125 reads
Cleaning up Azure Client IPs
I travel around, and as a result, I may find myself accessing my Azure databases from different locations. Since it’s...
2018-05-29
429 reads
Introduction to Biml – Webinar
On Thursday June 7th I’ll be giving a webinar for MSSQLTips.com (7PM UTC). The topic is Introduction to Biml – Generating your...
2018-05-29
247 reads
Blogs
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
The Book of Redgate: Mistakes
By Steve Jones
This is kind of a funny page to look at. The next page has...
ADF Pipeline Debugging Fails with BadRequest – The Sequel
A while ago I blogged about a use case where a pipeline fails during...
Forums
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
String Similarity II
Comments posted to this topic are about the item String Similarity II
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers