Multi-server Script to Find Orphaned Data Files using PowerShell
In this article, we take the sledgehammer approach in searching for MDFs and then comparing them against files which are...
2017-08-23
499 reads
Speaking at SQLSaturday #635 in Vancouver this weekend
This coming weekend, at SQLSaturday #635 in Vancouver BC, I will be presenting a brand new talk about Temporal Tables,...
2017-08-23
129 reads
SQL Server vs Oracle: Substring
Continuing the comparison between these two database giants, we dive into the substring function. If you’ve been working with databases...
2017-09-05 (first published: 2017-08-23)
7,257 reads
Preparing for Microsoft Certification Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI
Late last month Microsoft released the certification exam for Power BI, 70-778: Analyzing and Visualizing Data with Microsoft Power BI....
2017-08-23
1,068 reads
VMworld 2017 SQL Server Sessions
Just a reminder – our SQL Servers sessions for this year’s VMworld 2017 conference in Las Vegas are starting to fill...
2017-08-23
131 reads
VMworld 2017 SQL Server Sessions
Just a reminder – our SQL Servers sessions for this year’s VMworld 2017 conference in Las Vegas are starting to fill...
2017-08-23
446 reads
Redgate Hub LiveStream
Over at Redgate, we’ve been working on a new way to get information to you. It’s called the Redgate Hub....
2017-08-23
202 reads
Redgate Hub LiveStream
Over at Redgate, we’ve been working on a new way to get information to you. It’s called the Redgate Hub....
2017-09-04 (first published: 2017-08-23)
862 reads
VLFs the Forgotten Foe
How many of you check the amount of Virtual Log Files (VLFs) your transaction logs have?
Working as a consultant now,...
2017-09-07 (first published: 2017-08-23)
2,103 reads
Changing the version of an SSIS package.
Of all of the annoying parts of SSIS, the major version sensitivity has to be the most annoying. Let’s say...
2017-09-06 (first published: 2017-08-23)
3,527 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Forums
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers