Availability group replica murdered in cold blood by WSFC
This problem was first flagged by a daily operational validation test I wrote using everything in my recent webinar to...
2017-03-15
223 reads
Blog Posts
Corrupt Database – I need that data now!
My database is in the recovery pending state and I want to get in and extract the data out into...
2017-03-15
364 reads
Create a BACPAC–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-03-15
609 reads
Dots, Skills, and SQL Clone: A Contest from Redgate
Redgate just launched SQL Clone, a new product that can provision copies of databases in seconds. By copies, I mean...
2017-03-15 (first published: 2017-03-06)
1,502 reads
PolyBase use cases clarified
I previously talked about PolyBase and its enhancements (see PASS Summit Announcements: PolyBase enhancements). There is some confusion on PolyBase use...
2017-03-15
626 reads
SQL Server Fixed Role Permissions
Roles and Permissions
Some of my recent articles have been focused on permissions and security. There is good reason for that – security...
2017-03-15 (first published: 2017-03-06)
3,103 reads
Summary of my Container Series
I’ve written a few articles on containers so I thought it’d be a good idea to have a page that...
2017-03-15
361 reads
The Livestream Product Launch
SQL in the City Streamed in 2016 was a success, with lots of feedback that people enjoyed the sessions and...
2017-03-15
688 reads
Webinar – Datacenter Madness – Application Altercation
I hope you all can join me for an upcoming webinar as part of theDatacenter Madness webinar series, presented by...
2017-03-15
327 reads
Extreme situations require extreme commands
The title is adapted from a child-hood movie of mine and is my daily (database-related) WTF moment and it is...
2017-03-14
383 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
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...
Forums
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts?
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
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...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers