Weekly reading #2
Good morning! It is Monday! We spent the weekend in Kraków taking part in the SQLSaturday #824. It was a...
2019-02-11
116 reads
Blog Posts
Why You Shouldn't Use SELECT * In Production Systems (EVER!)
OK so the title is a bit of a bold statement but bear with me, I’ve been burned by this...
2019-02-11 (first published: 2019-01-23)
6,827 reads
Azure Virtual Machine Boot Diagnostics
If you have ever rebooted a virtual machine and feel like you are in the dark to it’s current state,...
2019-02-08
369 reads
Developing pipelines in Azure Data Factory using Template gallery
(2019-Feb-08) I often see demos of Azure Data Factory (ADF) development techniques with a modest set of activity tasks and not...
2019-02-08
688 reads
Performance on readable replicas in Availability Groups
I apologize in advance if I mess up the terminology.
I’ve worked with a moderate read workload on a readable replica...
2019-02-08
776 reads
Pro SQL Server Linux–Moving to Linux
As part of my learning goals for 2018, I wanted to work through various books. This is part of my...
2019-02-08
1,356 reads
Rotating Expired SQL Server TDE Certificates
In general, SQL Server TDE certificates will expire at some point. In SQL Server, if we have setup TDE using...
2019-02-08 (first published: 2019-01-23)
1,777 reads
Scheduling things to Run in SQL Server
A key part of the SQL Server Agent is the ability to schedule jobs. While you can create one schedule...
2019-02-08 (first published: 2019-01-23)
2,745 reads
SQL Server 2017 Reporting Services: The Basics Part 3
Note: I’ve been meaning to start a series on the basics of SQL Server Reporting Services (SSRS). The last time...
2019-02-08
746 reads
SQL Server Database Experimentation Assistant - How to Run a Capture
DEA
Very basic look at the setup as I couldn’t find much documentation on this when I last tried this out in 2018. Maybe it will help you get started...
2019-02-08
35 reads
Blogs
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...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
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