The evolution of SQL Server towards Digital Transformation challenges
SQL Server on Linux boosts the database market for Microsoft. Support of PolyBase (a feature to work with Big Data...
2017-10-09
367 reads
Power BI Custom Visuals Class (Module 72 – HTML Viewer)
In this module you will learn how to use the HTML Viewer. The HTML Viewer allows you to display the...
2017-10-17 (first published: 2017-10-09)
1,821 reads
SQL Server 2017 Encrypted Backups And Compression
Let’s work through some code to do an encrypted backup. This feature is available to you if you are using...
2017-10-18 (first published: 2017-10-09)
3,111 reads
Small identity columns
We frequently talk about dealing with outgrowing INT identity columns. What we don’t talk about all that often is small...
2017-10-17 (first published: 2017-10-09)
1,850 reads
Understanding ANOVA
ANOVA – or analysis of variance, is a term given to a set of statistical models that are used to analyze...
2017-10-16 (first published: 2017-10-09)
2,543 reads
SpeedPASS Download Naming Convention
This was the first time in a long time that I managed the check-in process of SQLSaturday Orlando and was...
2017-10-18 (first published: 2017-10-09)
1,522 reads
SQLpassion Online Training about Availability Groups
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-10-16 (first published: 2017-10-09)
1,264 reads
What is DBCC CLONEDATABASE ?
DBCC CLONEDATABASE is new feature comes up with SQL Server 2014 Service Pack 2 and above. DBCC CLONEDATABASE is used...
2017-10-13 (first published: 2017-10-09)
2,441 reads
Extracting Deadlock information using SYSTEM_HEALTH Extended Events
Extended Events is a powerful feature that was introduced into SQL Server 2008 and onwards. It keeps historical system health...
2017-10-12 (first published: 2017-10-07)
13,692 reads
Simplified Networking with a Wsky USB NIC
I used to share an office with my wife. We both needed Internet connections, with both desktops needing Ethernet cables....
2017-10-06
448 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