10 years later, the same issue (i.e. drop table not captured by DATABASE_OBJECT_CHANGE_GROUP, which only captures create table statement) still exists on sql server 2019 (ver 15.0.4316.3).

The tip still applies,...

We have the exactly the same issue as the original poster, i.e. we are sql server 2016 EE and TDE encrypted, we are also on a 2-node HAG, and this...

This is a very interesting topic. CLR integration may not necessarily allowed in production most of the cases, but CLR integration can be of great help in non-production environments, such...

Generally speaking, the bigger "begin tran ... commit tran" block is, the more possible blocking / deadlocking event arise. In your case, I think you need to figure out the...

Thanks for the nice article, Tomaz.
library(Hmisc) is not a default installation, so I suppose I should install it manually, right?

Ray Herring (5/17/2016)

---

The attitude of many developers toward SQL and relational databases has always puzzled me.

The database provides data persistence, can help enforce data integrity, and simplifies many relationship oriented...

I would "shamelessly" (due to a bit of interest conflict as an SSC author before) suggest that SSC needs to greatly increase the payment for published articles. At a current...

Thanks, Solomon.

One thing I'd like to see is that I can create a CLR proc, which can connect to other sql servers via SMO, and then get some information I...

As always, a nice article full of valuable content.

I expect to see a few practical samples down the road, maybe you can open source a few functions in your SQL#...

Rule of thumb.

1. All FKs should have indexes on them (in minimum, FKs are covered by indexes)

2. FKs are the least expensive and should be the last sacrifice in terms...

Steve Jones - SSC Editor (12/15/2015)

---

Yet Another DBA (12/15/2015)

---

Unfortunately too many companies see frequent job changes as detrimental. I cant remember which of the forums veterans it was who made...

Always be cautious about using snapshot for VLDB dbs when your deployment code involves some big data change, such as dropping/recreating indexes, deleting/inserting big chunk of data. Other than the...

Iwas Bornready (12/2/2015)

---

ian.lee 73912 (12/2/2015)

---

Negative thinking senior manager: "What if we invest in training and developing our people and they leave us?"

Positive thinking senior manager: "What if we don't and...

I kind of stop using invoke-sqlcmd for multi-line scripts due to its unexpected and ugly bug which I mentioned here

http://www.sqlservercentral.com/blogs/jeffrey_yao/2015/10/25/be-cautious-about-invoke-sqlcmd-bug/

I usually have to run long and complex scripts...