Viewing 15 posts - 1 through 15 (of 139 total)
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...
February 5, 2020 at 10:45 pm
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...
October 11, 2018 at 10:15 am
gpolelo - Monday, September 25, 2017 6:34 AM
The best way is to print the results to text not grid.
Obviously, you did NOT...
September 25, 2017 at 11:52 am
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...
June 6, 2017 at 1:11 pm
Thanks for the nice article, Tomaz.library(Hmisc) is not a default installation, so I suppose I should install it manually, right?
February 15, 2017 at 3:09 pm
Ray Herring (5/17/2016)
The database provides data persistence, can help enforce data integrity, and simplifies many relationship oriented...
May 19, 2016 at 3:53 pm
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...
April 25, 2016 at 11:13 am
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...
March 3, 2016 at 4:40 pm
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#...
March 1, 2016 at 11:55 am
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...
February 10, 2016 at 1:46 pm
Steve Jones - SSC Editor (12/15/2015)
Yet Another DBA (12/15/2015)
December 15, 2015 at 1:52 pm
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...
December 8, 2015 at 3:06 pm
Iwas Bornready (12/2/2015)
ian.lee 73912 (12/2/2015)
Positive thinking senior manager: "What if we don't and...
December 2, 2015 at 2:48 pm
I kind of stop using invoke-sqlcmd for multi-line scripts due to its unexpected and ugly bug which I mentioned here
I usually have to run long and complex scripts...
December 2, 2015 at 10:36 am
jeffrey yao (8/28/2015)
But from pure technical perspective, I feel there is one special deficiency I do not like,...
September 24, 2015 at 10:34 am