Remotely Administering the Docker Engine on Windows Server 2016
Continuing on my series in working with Docker on Windows, I noticed that I always open up a remote powershell...
2017-02-22
703 reads
Read Statistics Histogram using DMV
DMV: sys.dm_db_stats_histogram (object_id, stats_id)
For a long time, the DBCC SHOW_STATISTICS command was the only way to get information about statistics....
2017-02-22
1,005 reads
JSON Support Is The Best New Developer Feature in SQL 2016 — Part 4: Performance Comparisons
This is the fourth article in my series about learning how to use SQL Server 2016's new JSON functions. If you haven't already, you can read Part 1?—?Parsing JSON,...
2017-02-21
26 reads
We Hired!
The response to our most recent job position was incredible, and I’d like to thank all of the folks who...
2017-02-21
398 reads
Heading Back to SQL Bits
I’m honored to be selected to speak at SQL Bits 2017 this April in Telford. This is my favorite SQL...
2017-02-21
564 reads
Giving a Security Webinar on Thursday
On Thursday, February 23rd at 3 PM EST I’m giving a webinar on designing a successful database security model with...
2017-02-21
367 reads
Power BI Custom Visuals Class (Module 39 – Waffle Chart)
In this module you will learn how to use the Waffle Chart Power BI Custom Visual. The Waffle Chart visual...
2017-02-21
1,018 reads
Permanent Employment v Contracting: How the figures stack up
In my latest learning tree newsletter, I discussed analysing some of the salary survey data that the good folks over...
2017-02-24 (first published: 2017-02-21)
3,501 reads
Error while loading Excel data into database
Issue: I am trying to load data from Excel 97 – 2003 sheet into a database table. I have written a...
2017-02-28 (first published: 2017-02-21)
4,886 reads
How to sign a SQL Server CLR Assembly in Visual Studio 2015
It took me quite a while to figure out how to sign a SQL Server CLR Assembly (like a CLR...
2017-02-22 (first published: 2017-02-21)
6,829 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers