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
434 reads
SQL Server Soldier :: News from the frontlines of the database wars
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
442 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
491 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
461 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
461 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
574 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
699 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
769 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,115 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
717 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers