T-SQL aside: replace PRINT with RAISERROR
I was minding my own business innocently reading a blog post by Erik Darling, when this tip smacked me in...
2018-06-06
1,149 reads
Blog Posts
Understanding the Role of SQL Server Agent in SQL Server
SQL Server Agent is a component of Microsoft SQL Server that is responsible to execute & schedule tasks or jobs in...
2018-06-06
3,980 reads
Understanding the Role of SQL Server Agent in SQL Server
SQL Server Agent is a component of Microsoft SQL Server that is responsible to execute & schedule tasks or jobs in SQL Server. It runs as a Windows service...
2018-06-06
23 reads
4 Ways To Define Lookup Values In A Query
Watch this week's video on YouTube
Occasionally you may need to create a lookup table of values for a single query. Building a permanent table of these values is a...
2018-06-05
33 reads
4 Ways To Define Lookup Values In A Query
Watch this week's video on YouTube
Occasionally you may need to create a lookup table of values for a single query. Building a permanent table of these values is a...
2018-06-05
7 reads
Bring Your Own Key to Azure SQL Database TDE New UI
In a recent post I wrote about a new functionality for Azure SQL Database’s TDE feature: Bring Your Own Key. At the time the only way to bring your...
2018-06-05
17 reads
Choosing a Color Palette For Your Power BI Report
Color is a powerful attribute in data visualization. In a good visualization, it can focus attention and enhance meaning and...
2018-06-05 (first published: 2018-05-27)
2,641 reads
Did you know...you can change the default file encoding for new query on SSMS?
If you have been reading my last blog posts, you know that I’m currently working on a SQL code migration from Firebird to SQL Server.
The client provided the scripts...
2018-06-05
186 reads
Did you know…you can change the default file encoding for new query on SSMS?
If you have been reading my last blog posts, you know that I’m currently working on a SQL code migration...
2018-06-05
491 reads
Does a Query always wait in the SUSPENDED State?
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-06-05
1,022 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Automating OSM Data Refresh in Power BI’s Azure Maps Reference Layer
Comments posted to this topic are about the item Automating OSM Data Refresh in...
Database Mail Configuration
Comments posted to this topic are about the item Database Mail Configuration
Learn From History
Comments posted to this topic are about the item Learn From History
Question of the Day
Database Mail Configuration
If I want to get a list of the configuration settings for Database Mail using T-SQL, how can I do so?
See possible answers