Linked Server to Azure SQL Database
You may (or may not) have a requirement to setup a linked server to Azure SQL Database from a locally...
2018-06-13 (first published: 2018-06-05)
1,863 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
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....
2018-06-12 (first published: 2018-06-05)
1,905 reads
4 Ways To Define Lookup Values In A Query
Watch this week’s episode on YouTube.
Occasionally you may need to create a lookup table of values for a single query. ...
2018-06-13 (first published: 2018-06-05)
4,277 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
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
262 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
268 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
SQL Saturday #731 Athens 2018
In less than two weeks (on 16th June) it’s time for SQL Saturday Athens and I’m proud to announce that...
2018-06-04
302 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers