IF RDBMS = SQL Server, NoSQL = ???
SQL Server is, arguably, the leading relational database management system out there. With continuous development and enhancement of exciting features...
2017-11-08
460 reads
The Future of the SQLSaturday Tools
Every year when many of the SQLSaturday event leaders meet at the Summit the topic of improvements to the tools...
2017-11-23 (first published: 2017-11-08)
2,091 reads
SQL Puzzle 4: The Beale Papers
I’ve not done a SQL puzzle for a while so thought it was getting overdue…
I set this one for my...
2017-11-24 (first published: 2017-11-08)
1,498 reads
Notes on the 2017 PASS Summit
Just a few notes:
Weather on Wed was great, ok on Thurs, cold on Fri. Have had worse years!Felt like I...
2017-11-08
437 reads
Is Transparent Data Encryption just security theatre?
I love theatre. In six months I am putting on two one-act plays for a local festival, because I don’t...
2017-11-08
336 reads
Five reasons to be a technology speaker
I don’t think everyone should be a technical speaker. But I wouldn’t object if everyone spent a season trying. Why be a...
2017-11-08
380 reads
Contained Databases setup
Last weekI wrote about what is a contained database, the benefits and challenges, today as promised I'll show you how to setup one, how to configure a user and...
2017-11-08
14 reads
I Thought I Was An Introvert. Turns Out I Was Anxious as #@*] (Dear SQL DBA Episode 53)
In this week’s episode, I’m not answering a reader’s question. Instead, I’m talking about my personal experience with anxiety. This episode touches on on healthcare, religion, and squishy emotions...
2017-11-08
9 reads
Power BI Custom Visuals Class (Module 76 – Image Timeline)
In this module you will learn how to use the Image Timeline Custom Visual. The Image Timeline is a great...
2017-11-21 (first published: 2017-11-08)
1,368 reads
More Collation Confusion. (tempdb)
I’ve talked about Collation Confusion before. We had the dev and test instances at one collation and the production instance...
2017-11-08
427 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