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
3 reads
Blog Posts
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
13 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,618 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
153 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
486 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,004 reads
Music City Tech Rocked!
I know Nashville is most famous for Country music, but in the recent years, it has become home to more...
2018-06-05
283 reads
Power BI Custom Visuals Class (Module 105 – Text Wrapper MAQ Software)
In this module you will learn how to use the Text Wrapper by MAQ Software. The Text Wrapper allows you...
2018-06-05 (first published: 2018-05-29)
2,031 reads
SQL Database Corruption: Causes, Prevention, Fixing Techniques
“I had a Database File and I want to attach this MDF file to SQL Server 2014. However, whenever I...
2018-06-05
261 reads
SQLSaturday Orlando 2018 – Planning Update #2
Continuing the notes I wrote in Update #1, got a few more things done last week:
Received confirmation that the event...
2018-06-05
265 reads
Blogs
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
This Week's AI Trust Problem Became Everyone’s Problem
Comments posted to this topic are about the item This Week's AI Trust Problem...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers