SQL Data Generator–Getting a value based on another column
This is a series on SQL Data Generator, covering some interesting scenarios I’ve run into. If you’ve never tried it,...
2017-10-19
1,444 reads
Connecting to Azure SQL Database Primary Endpoint – Failover Groups
When you have setup a Failover Group in Azure for your SQL Databases connecting to the R/W (Read / Write) endpoint...
2017-10-19
698 reads
Introducing XESmartTarget
Three years ago, I started to work on a project called ExtendedTsqlCollector. I blogged about it multiple times here on...
2017-10-27 (first published: 2017-10-19)
1,280 reads
SQLSaturday Orlando 2017 Notes – Part 1
Part 1 will be about things we did (or didn’t) do and some lessons learned. In Part 2 I will...
2017-10-19
433 reads
Datalere Presents Data Science, Cloud, Business Intelligence and Data Warehousing at PASS Summit
Pacific North West, 4000 attendees, training, trends and worldwide industry experts. In a nut shell, the world’s largest conference for...
2017-10-18
161 reads
Don’t “Test” Against Production
A few months ago, I was participating in a threat hunting exercise on the security side. The gentleman leading the...
2017-10-30 (first published: 2017-10-18)
2,071 reads
Rebooting Ubuntu Linux from the Command Line–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-10-18
541 reads
Connecting to a Remote Instance of SQL Server Using Python
SQL Server’s integration of Python has been heavily marketed towards the machine learning and BI guys, but does it offer...
2017-10-18
1,210 reads
The perils of RAID
Recently, I was asked to assist an organization with getting their data back for a SQL Server that had experienced...
2017-10-18
649 reads
Does Your Code Have a Preamble?
Okay, here is a pet peeve of mine, I think every stored procedure, function, view etc. should all contain a...
2017-10-18
498 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