Something for the Weekend – SQL Server Links 09/08/13
It’s Something For The Weekend(SFTW) time, I hope you’ve had a great week!
Some of you may have noticed that I’ve...
2013-08-09
1,244 reads
SQL Server Diagnostic Information Queries for August 2013
I have gone through and made some minor updates and bug fixes for all of my SQL Server Diagnostic Information...
2013-08-19 (first published: 2013-08-09)
3,616 reads
Disaster Recovery Docs–Offsite
Years ago I worked at an ISO certified organization, where we took our administration and planning seriously. We ensured everything...
2013-08-16 (first published: 2013-08-08)
2,314 reads
How implicit data type conversion slows down your query
Implicit data type conversion is one of those things you hardly think about or notice when writing your queries. But...
2013-08-08
1,477 reads
Best Practices to Deliver BI Solutions
If your company is planning to build a data warehouse or BI solution (see Why you need Business Intelligence), you need...
2013-08-08
1,527 reads
Survey: Are you a SQL Server Professional and running on Mac?
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
I know a...
2013-08-08
1,156 reads
Share Your Ideas for Improving PASS on September 9th (Suggestion Tsunami!)
My friend Aaron Nelson was in Florida recently for SQLSaturday #231 and we always find a few minutes to catch...
2013-09-06 (first published: 2013-08-08)
1,027 reads
Connecting to the Hortonworks Sandbox v1.3 through IP 192.168.56.101
I recently downloaded the Hortonworks Sandbox v1.3 Hyper-V VM and had a hard time connecting to the included web interface...
2013-08-08
1,651 reads
Extracting Data From Multiple Files with Power Query
In this post I’d like to demonstrate another way Power Query can solve simple data extraction problems without much time...
2013-08-08
963 reads
Normalisation
The purpose of normalisation is to remove redundancy and prevent conflict. 1st Normal Form (1NF) – Every field can have only...
2013-08-07
553 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