SSIS Custom Logging Levels
In my ongoing series on ETL best practices, I recently wrote about the importance of logging in extract-transform-load processes. For...
2016-12-22
482 reads
Blog Posts
Windows Server 2016 and SQL Server 2016 – A match made in heaven!
For all these years Windows Server 2016 is the Windows version I was waiting for, and this blog post will explain why...
2016-12-22
1,257 reads
Windows Server 2016 and SQL Server 2016 – A match made in heaven!
For all these years Windows Server 2016 is the Windows version I was waiting for, and this blog post will explain why I’m super excited about this! With Windows Server 2016,...
2016-12-22
4 reads
Automating DBCC Page
Way back in 2006, Paul Randal documented DBCC PAGE on his Microsoft blog at http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/06/10/625659.aspx. In his post, you will...
2016-12-21
420 reads
Data gateway confusion
Microsoft has created data gateways as a way that cloud products such as Power BI and Azure Machine Learning can...
2016-12-21
417 reads
Optimize For Unknown
Hello Dear Reader! It's been a while. I was working with a friend and we came across an interesting problem....
2016-12-21 (first published: 2016-12-05)
3,320 reads
Power BI Custom Visuals Class (Module 30 – Linear Gauge)
In this module you will learn how to use the Linear Gauge Power BI Custom Visual. The Linear Gauge would...
2016-12-21
743 reads
Run Book, Run!!!
How many of you actually have a “Hit-by-the-Bus” handbook? What is that, you ask? It is a document that explains...
2016-12-21
1,225 reads
sp_helptext vs object_definition()
I’ve been using sp_helptext for years. Honestly I probably end up using it at least once a day. But I...
2016-12-21
1,768 reads
SQL Agent Permissions
Problem
I was contacted by a user asking if it was possible for his team to be able to execute specific...
2016-12-21
2,571 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