SQL Server 2014 SP1 released, and revoked
Just a brief note today to point to an article by Time Ford on SQLMag.com announcing that SQL Server 2014 SP1 has...
2015-04-16
633 reads
Jen McCown
SSMS regular expressions: format text into a block
Sean’s RegEx for DBAs class must be finally sinking in for me. Today I was able to figure out a...
2015-04-07
515 reads
Connect the Nots
Today I learned that you can’t adjust the font size in SQL Server Management Studio’s Object Explorer pane. Nor registered...
2015-04-02
623 reads
“Thing IS NOT NULL” isn’t the same as “Thing != NULL”
I’ve talked about NULLs before. (Ref: Here’s a bit on ISNULL(), and here’s one about understanding NULL at a basic level.)...
2015-03-16
582 reads
Fun-fun-fun in the London sun (and Cardiff, and Exeter!)
We’re in London right now for SQLBits, which has been ABSOLUTELY LOVELY so far. If you happen to’ve seen our...
2015-03-06
447 reads
Powershell to Robocopy files (say, to back up your computer to protect against CryptoWall trojan)
We were having a good time on DBAs@Midnight, when Sean got a weird pop up message that said all his...
2015-02-07
1,130 reads
Minion Reindex 1.1 Release (and re-release)
We released Minion Reindex version 1.1 last week. The changes are fairly small: Made sure Minion Reindex handles all nonstandard naming...
2015-01-29
1,260 reads
Video: A Better Way to Reindex
Sean presented A BETTER WAY TO REINDEX for the Performance Virtual Chapter. Here are links to the video, and to...
2015-01-23
1,941 reads
Create a clustered index and a primary key on existing tables
It’s the simple things in life that can trip people up. I find that creating primary keys and clustered indexes...
2014-12-15
653 reads
Just an idea: Bare Bones SQL
I’m reading Andy Warren’s excellent essay “Thoughts on raising funds and spending funds for PASS chapters”, and it’s bringing together...
2014-11-13
869 reads
Blogs
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
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...
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