MVP Data Platform
Holy Cow! I still can’t believe it, I was awarded the Microsoft MVP – Data Platform today. I guess I really...
2018-01-04
612 reads
Azure SQL Analytics
Azure SQL Analytics is currently in preview mode, still it is very impressive. The goal of this feature is to...
2018-01-04
1,002 reads
Sharepoint Diagnostics and XE
In this article I have introduced you to a quick session setup that comes from using the SPDiag tool that could plausibly be useful in the troubleshooting of various...
2018-01-04
59 reads
Sharepoint Diagnostics and XE
One of the all-time greatest and most beloved applications among DBAs happens to be Sharepoint. Most of us would be...
2018-01-04
1,653 reads
How Secure is Transparent Data Encryption (TDE) – and How to Prevent Hacking
TDE is commonly described as “at-rest” encryption, i.e. it protects your data wherever it is stored on disk. This includes...
2018-01-15 (first published: 2018-01-03)
3,195 reads
DevOps Does Not Make Admins Obsolete
As a follow up to my tweet, I stand by my belief that DevOps does not make administrators obsolete. I...
2018-01-11 (first published: 2018-01-03)
1,055 reads
Kicking Off The New Year With A Bang
Back in 2015, I said would think about speaking in my #TSQL2sday #61 post. Well here it is 2018 and...
2018-01-03
389 reads
Tab Groups (Day 3)
Have you ever wanted to have two different queries open up at the same time where you could see them,...
2018-01-03
334 reads
Creating a SQL Server Test Lab On Your Workstation – Part Two, Creating a Domain Account and Joining a SQL Server to the Domain
In the second part of our series on creating a SQL Server test lab on your workstation, I’m going to...
2018-01-12 (first published: 2018-01-03)
2,334 reads
Welcome to 2018
I have been working on a new information session, which I’m hoping to deliver this year. It’s about one of...
2018-01-03
311 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