(last updated: 2019-03-15 @ 02:45 EST / 2019-03-15 @ 06:45 UTC )
Binary collations are, in many ways, simpler to understand than non-binary collations...
2019-03-13
12,019 reads
(last updated: 2019-02-26 @ 18:35 EST / 2019-02-26 @ 23:35 UTC )
IntelliSense in SQL Server Management Studio (SSMS) can be quite helpful. It...
2019-02-26
994 reads
(last updated: 2019-01-31 @ 22:45 EST / 2019-02-01 @ 03:45 UTC )
Today’s “Question of the Day” on SQL Server Central, Cleaning up the...
2019-02-20 (first published: 2019-01-31)
4,748 reads
(last updated: 2019-01-15 @ 19:50 EST / 2019-01-16 @ 00:50 UTC )
I haven’t seen a lot written about these particular behaviors so I...
2019-01-28 (first published: 2019-01-15)
2,289 reads
(last updated: 2019-01-08 @ 13:53 EST / 2019-01-08 @ 18:53 UTC )
There are times when I am working on a SQL script that...
2019-01-08 (first published: 2018-12-28)
4,379 reads
Demystifying What “sqlservr -q” Actually Does
(last updated: 2019-01-07 @ 02:25 EST / 2019-01-07 @ 07:45 UTC )
For various reasons, people sometimes find themselves...
2019-01-03 (first published: 2018-06-12)
8,430 reads
(last updated: 2018-11-01 @ 00:50 EDT / 2018-11-01 @ 04:50 UTC )
SQL Server 2017 introduced a new security restriction for SQLCLR in the...
2018-11-12 (first published: 2018-10-31)
3,348 reads
(last updated: 2018-12-26 @ 16:20 EST / 2018-12-26 @ 21:20 UTC )
(NOTE: For recent update, please see “Update for CTP 2.2” section)
For some...
2018-09-28
8,593 reads
(last updated: 2019-01-10 @ 18:00 EST / 2019-01-10 @ 23:00 UTC )
With the additional (and annoying) configuration step required to get SQLCLR Assemblies...
2018-08-27 (first published: 2018-08-09)
3,940 reads
Occassionally I want / need to change a Windows setting that is not configurable via Control Panel or Settings. For example:
Enabling...
2018-06-06
1,150 reads
The post The pros and cons of self-service BI: What every industry leader should...
By Steve Jones
As this publishes, I’ll get taxiing down the runway at DIA (fingers crossed) and...
By John
AI and ChatGPT are all the rage these days. Seems like around every corner...
I am running SQL Server 20.2. When I copy a query into the query...
Hi, i considered power bi with embedded for this. Not a big fan...
Hi everyone I am trying to implement parallelism in my SSIS package. There are...
Which cloud sources can be used for the current Data Migration Assistant (Sep 2024)
See possible answers