Speaking at SQL Saturday #782 Slovenia
In coming weekend I will be speaking at SQL Saturday in Ljubljana, Slovenia. I’m extra happy because I do it...
2018-12-06
220 reads
Blog Posts
SQL Server Find Unused Data Files
You know that old SQL Server you’ve left running the last 5 years and had numerous databases dropped and restored...
2018-12-06
683 reads
4 SQL Injection Techniques For Stealing Data
Watch this week’s episode on YouTubeI’m not advocating that you start using SQL injection to start stealing other people’s data.
However,...
2018-12-05 (first published: 2018-11-20)
3,377 reads
Advent of Code 2018 – Day 5 (Alchemical Reduction)
A T-SQL approach to solving the 2018 "Advent of Code" programming challenge. This solution includes a recursive case-sensitive string replacement.
The post Advent of Code 2018 – Day 5 (Alchemical...
2018-12-05
16 reads
Advent of Code 2018 – Day 5 (Alchemical Reduction)
Advent of Code 2018 – Day 5
As I explained in a recent post, I’m participating in this year’s Advent of Code...
2018-12-05
857 reads
Azure Data Factory v2 and its available components in Data Flows
Many of you (including me) wonder about it. Namely: Is it possible to move my ETL process from SSIS to...
2018-12-05
229 reads
Enabling Query Store
Performance tuning in SQL Server is one of the main jobs a DBA has. Starting with SQL Sever 2016 a...
2018-12-05
1,233 reads
Flagrantly ignoring the 10% rule
My friend Michael J. Swart has a rule of thumb he calls Swart’s Ten Percent Rule. If you’re using over...
2018-12-05
216 reads
SQL Data Discovery and Classification in SSMS 17.5
Data exploration and documentation can be cumbersome, classifying data can be one of those tedious but necessary things. With the...
2018-12-05
935 reads
UDL files and connection strings
A co-worker showed me a really neat trick the other day. We deal with a lot of connection problems and...
2018-12-05
7,292 reads
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers