(last updated: 2018-03-27)
Despite features added in SQL Server 2005 (yes, 2005!) that allow for very flexible, granular, and robust security,...
2017-12-30
3,781 reads
(If you’re reading this on SQL Server Central, please click here to see the “Featured Image” which will help explain...
2017-12-28 (first published: 2017-12-11)
1,820 reads
For thousands of years theologians have offered various thoughts on the question of what happens when we die. Does some...
2017-11-30 (first published: 2017-11-20)
1,999 reads
Some (or maybe most?) languages and operating system command shells allow for breaking up long lines into multiple lines (i.e....
2017-11-08 (first published: 2017-10-27)
10,383 reads
As I was testing whether or not the new “Variation Selector Sensitive” ( _VSS ) Collations in SQL Server 2017 would assist...
2017-10-31 (first published: 2017-10-16)
2,485 reads
“Trusted Assemblies”, a new feature starting in SQL Server 2017, is a means of whitelisting Assemblies that one feels pose...
2017-10-09 (first published: 2017-09-29)
2,318 reads
In SQL Server, each and every row in a table needs to be accessible by itself, whether or not you...
2017-09-19
1,676 reads
In the previous post in this series on SQLCLR in SQL Server 2017 — Part 4: “Trusted Assemblies” — The Disappointment — we...
2017-09-04
401 reads
Recap
Before we look at “Trusted Assemblies”, let’s take a moment to review the context of the situation. First, the “Good”:...
2017-08-28
1,297 reads
Welcome back, everyone. In the previous post in this series, I explained how to work within the new SQLCLR security...
2017-08-16
695 reads
By Ed Elliott
All Spark Connect Posts I recently published the latest version of the Spark Connect Dotnet...
By Steve Jones
opia – n. the ambiguous intensity of eye contact The entry for this says...
By Steve Jones
This was actually a cool tip I saw internally from one of the product...
RESTORE DATABASE [mydb] FROM DISK = N'e:\sqlbackups\mydb.bak' WITH FILE = 1, keep_cdc, NOUNLOAD, REPLACE,...
Comments posted to this topic are about the item Serverless Gets Faster
I have a task to check the connection managers as part of ssis integration...
I have a statistics objects with 2 key columns from my tables. How many histograms and their type are stored?
See possible answers