Podcast with SQL Data Partners on Patching Best Practices
Recently, I joined Carlos L Chacon (site|@CarlosLChacon), Steve Stedman (blog|@SqlEmt), and the rest of the SQL Data Partners Podcast team...
2017-10-23
444 reads
Robert Davis
- Interests: Poker, computers, reading/writing horror fiction
Webcast: Troubleshooting SQL Server Connection Issues
I will be doing a live webcast on Thursday, November 9th 2017 at 3 PM Eastern Time (8 PM UTC...
2017-10-23
441 reads
Checklist: DR Plan Sanity Check
If a disaster struck tomorrow, are you ready for it? Are you sure you thought of everything? I cannot count...
2017-09-04
494 reads
31 Days of Disaster Recovery Revisited
A few years ago, I did a blog post series dedicated to disaster recovery (backups, restores, corruption, etc). 31 blog...
2017-08-18
466 reads
Patching SQL Server and SSMS? Order matters.
If you’ve been living under a rock, you may not have noticed how frequently SSMS is getting updated. The SQL...
2017-08-14
469 reads
T-SQL Tuesday #93: 3 Jobs I Didn’t Take and 1 I did
It’s T-SQL Tuesday again, and this month’s host is Kendra Little (blog|@), and the excellent topic selected by Kendra is...
2017-08-08
577 reads
Real-life SQL Server Performance Troubleshooting at SQLSaturday Columbus
Join me Friday, July 21, 2017 for a day of Real-life SQL Server Performance Troubleshooting as part of SQLSaturday Columbus...
2017-06-26
705 reads
T-SQL Tuesday #90: The Death of the DBA in a DevOps World Has Been Greatly Exaggerated
It’s time for another iteration of the blog party known as T-SQL Tuesday. This month’s theme is Shipping Database Changes...
2017-05-09
774 reads
Why Log Shipping is Better than Database Mirroring for Migrations
This topic has come up several times recently, so I feel the need to blog on it. As the person...
2017-05-05
1,126 reads
24 Hours of PASS: Security: Session Files
Thanks to everyone who attended my presentation for the 24 Hours of PASS event on May 3rd. This iteration of...
2017-05-04
719 reads
Blogs
The CDO’s Playbook for AI Driven Decision Making
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
sp_snapshot – The easy way to take database snapshots of one or more databases – V3.0
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
SELECT *
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...
Forums
Extract sql data in psh
# Load ImportExcel module Import-Module ImportExcel -ErrorAction Stop # File paths $outFile = "C:\Reports\SQLReport.xlsx"...
caught off guard by some greek lettering in a warehouse feed
Hi we run 2019 standard. Our warehouse's ssis based etl is klunky but so...
Unlocking High-Concurrency Inserts in SQL Server with OPTIMIZE_FOR_SEQUENTIAL_KEY
Comments posted to this topic are about the item Unlocking High-Concurrency Inserts in SQL...
Question of the Day
Vector Datatype
The new Vector datatype in SQL Server 2025 is a binary type that has a few parameters. What parameters are required?
See possible answers