Is There A Threat Inside?
If you’ve been involved in technology for any length of time you are aware of outside threats to your network...
2017-04-05
374 reads
Blog Posts
Normalization, The Sequel
If there’s one thing that SQL Server is really good at, it’s relationships. After all, a relational database management system...
2017-04-05
118 reads
Taking dbatools Test-DbaLastBackup a little further
In a previous post I showed how easy it is to test your backups using Test-DbaLastBackup
Today I thought I would...
2017-04-05 (first published: 2017-03-22)
1,929 reads
Wait Stats, Here and gone again?
Microsoft recently introduced a handy new feature to query plans: waitstats. That’s right, you can get actual runtime waitstats for...
2017-04-05
504 reads
What’s Next for SQL Clone?
I think SQL Clone is a useful, handy product. It’s what I’ve needed in a number of organizations, or it’s...
2017-04-05
650 reads
Alerts From Azure Automation
In a previous post, I showed how to set up statistics maintenance for your Azure databases using Azure Automation. However,...
2017-04-04
638 reads
Automating DBCC DBTABLE – obtaining the disk Sector Size
I was recently reading this msdn article on Ghost Records, and it mentioned that you could get the number of...
2017-04-04 (first published: 2017-03-22)
10,236 reads
Azure: SQL Database Elastic Pool and using Elastic Jobs
I want to show you how I went from having multiple single SQL databases in Azure to a database elastic...
2017-04-04
587 reads
DevOps at VSLive–Austin
You can see me in May at VS Live in Austin, where I and many others will be talking DevOps....
2017-04-04
533 reads
How I Became A…SQL Server Data Professional
Last night I saw a tweet from Matt Gordon (b|t); the topic caught my eye – “How I Became A…SQL Server...
2017-04-04
404 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