Learning NoSQL
NoSQL is an option for a database platform and Steve wonders if you can discuss and debate the use of NoSQL for your business partners? Or are you going to learn more? He is.
2024-01-17
282 reads
Uncategorized
Play To Your Strengths
I really enjoy playing with radios [ed: we know, you won't shut up about it]. Something as simple as checking in to a local net (basically saying hi to a bunch of people on the radio) is fun. However, there's so much more to it. In the last few weeks I've been testing a new […]
2024-01-13
103 reads
An In-Depth Look at MIXED_PAGE_ALLOCATION and Changes in Page Allocation
Learn about the benefits of mixed extent allocation in SQL Server 2016, along with how you can check this setting or enable it in your database.
2024-01-10
2,005 reads
A Thriving Community Lifts All Boats
I'm writing this on the last day of PGConf.EU, sitting here in Prague. I'm looking forward to sitting in several more sessions today, as well as having a few more conversations with the people at the conference. It's been a great event and I'm so happy I've been able to take part. Following the PASS […]
2023-12-16
73 reads
You Are An Inspiration
Hero, Champion, Inspiration. These are words that are bantered around about people regularly. Joe was a hero when he saved that puppy. Betty was the champion runner and won the race. Pat was an inspiration; they work so hard. Hero and champion are universally understood as positive things. Inspiration is typically used as a positive, […]
2023-11-25
119 reads
Advanced SQL Server installation using Powershell DSC
Introduction In the previous article, we learned how to install a SQL Server instance with basic parameters like InstanceName, Features, SourcePath, SQLSysAdminAccounts, etc using Powershell DSC. In this article, we'll discover how to enhance our SQL Server installation with additional configurations. We'll cover things like setting up service account credentials, custom installation directories, configuring TempDB […]
2023-11-22
5,895 reads
You Never Know
I'm writing this sitting at the PASS Data Community Summit. It's been a fantastic event. I gave a community session on Azure DevOps. I was able to help Redgate launch a new product. I've received a bunch of hugs from VERY dear old friends. I've met a ton of people. It's been great. Allow me […]
2023-11-18
92 reads
Scheduling SQL Agent Jobs on Alternating Weeks
Bi-week... semi-week... fortnight... "every two weeks" Recently on the SQL Community Slack group, someone asked if there was a way to schedule a backup to run on alternate weeks. I'm not exactly sure why (maybe they wanted to run full and differential backups on alternating weeks), but yes, we can do that. In part one […]
2023-11-17
2,561 reads
SQL Server Table Design Guidelines - Data Types, Designing for Deletes and Primary Keys
In this article, we look at three table design guidelines when building an SQL table including data types, designing for deletes, and primary keys
2023-11-15
Don't (Always) Be a Hero
When we need to be heroes in IT on a regular basis, that's a problem for Steve.
2023-11-06
290 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
Question of the Day
RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers