Will GDPR cause a “Database Run”?
What is GDPR, everyone’s (current) favorite acronym? It stands for “General Data Protection Regulation” and is an act / law / set...
2018-02-05 (first published: 2018-01-23)
2,405 reads
What is GDPR, everyone’s (current) favorite acronym? It stands for “General Data Protection Regulation” and is an act / law / set...
2018-02-05 (first published: 2018-01-23)
2,405 reads
The other day I ran into an odd problem trying to answer the following question on DBA.StackExchange:
How to filter out...
2018-02-01 (first published: 2018-01-22)
1,648 reads
SQL Server stores the full definition of certain T-SQL objects — Stored Procedures, Functions, Views, and Triggers — in their original form,...
2018-01-09
917 reads
(If you’re reading this on SQL Server Central, please click here to see the “Featured Image” which will help explain...
2018-01-04 (first published: 2017-12-08)
2,689 reads
(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
4,163 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,821 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)
2,004 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)
11,150 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,583 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,323 reads
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
By Kevin3NF
It’s Not Just Backup / Restore At some point every company faces it: the...
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item Can/Can't Do/Don't
Comments posted to this topic are about the item Strange String Splits
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers