Three Ways to Create a Temp Table
Taking it back to SQL 101 today because I recently saw something that floored me. I’m a big fan of temp tables. I use ‘em all over the place...
2020-06-23
8 reads
Being seen and why PASS helped
One of my colleagues/friends read my earlier blog post on the future of PASS and said he was not aware that being seen as a minority person was among...
2020-06-22
9 reads
State of Database Monitoring
Redgate published a report that many of you helped with by providing information. First, thanks! Your info really helped. Second, do you want to see it? You can. Go...
2020-06-22
16 reads
Upload files to ADLS Gen2
I discover a small new feature the other day, but a very useful one. Previously, there was no way to upload files to an ADLS Gen2 storage account via...
2020-07-07 (first published: 2020-06-22)
267 reads
Collecting custom parameters/variables for Azure Data Factory deployment
(2020-June-22) It's a noble act to develop a very cool database solution that will bring value to your customers. In addition to this, you can help...
2020-07-07 (first published: 2020-06-22)
2,196 reads
Prevent the next data breach – a MinionWare snippet
Dozens of major data breaches have occurred in the last fifteen years. Each one illustrates the massive cost – both in dollars and in reputation – of lax security....
2020-06-22
33 reads
Prevent the next data breach – a MinionWare snippet
Dozens of major data breaches have occurred in the last fifteen years. Each one illustrates the massive cost – both in dollars and in reputation – of lax security....
2020-06-22
17 reads
Prevent the next data breach – a MinionWare snippet
Dozens of major data breaches have occurred in the last fifteen years. Each one illustrates the massive cost – both in dollars and in reputation – of lax security....
2020-06-22
13 reads
Prevent the next data breach – a MinionWare snippet
Dozens of major data breaches have occurred in the last fifteen years. Each one illustrates the massive cost – both in dollars and in reputation – of lax security....
2020-06-22
31 reads
Database Fundamentals #26: The Primary Key War
There is a war about primary keys in the database world. There are two camps. The first camp believes that primary keys should only ever be created on meaningful...
2020-07-06 (first published: 2020-06-22)
686 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