Leading Wildcards Aren’t A Good Default
SQL Server has LIKE, which lets us do various pattern matches, but most commonly we use the percent side as...
2011-03-05
1,165 reads
SQLAndy
Presenting in West Palm Beach on March 22, 2011
I’m pleased to be joining the West Palm Beach .Net group on March 22 to do a presentation on SQL...
2011-03-04
886 reads
The Power And Pain of Process–Part 1
Part of why I love IT is finding patterns and creating new ones. Patterns by themselves are interesting, but when...
2011-03-04
1,143 reads
Firefox and NTLM Authentication
By default Firefox doesn’t pass through NT credentials, not a big deal when you’re browsing Amazon by a big pain...
2011-03-01
933 reads
JTDS & Grails
Recently I had the chance to do some tuning on a system that was built using Grails (formerly Groovy on...
2011-02-28
2,475 reads
PASS Update #53 (Bylaws)
This week we posted some pending changes to the PASS bylaws. We try to do a review at least once...
2011-02-25
1,563 reads
A Plug for Wirefly
Wirefly is a website devoted to purchasing cell phones and plans. I found it when I was researching my Droid...
2011-02-22
850 reads
What Should PASS Be? I Challenge You
PASS isn’t what it should be. I hear that a lot, and in many ways I agree with you. We’re...
2011-02-18
553 reads
Notes from the February 2011 MagicPASS Meeting
I attended the second meeting of MagicPASS (no web site yet) on Feb 16 at Stetson University in Celebration, FL....
2011-02-18
552 reads
Who Is This Super Hero?
We recently switched from Brighthouse to DirectTV and of the first things we did was to find the kids channels...
2011-02-17
561 reads
Blogs
SQL Server 2025 RegEx and AI
By Steve Jones
One of the language changes in SQL Server 2025 that I’ve seen a lot...
T-SQL Tuesday #192: SQL Server 2025 Backup Changes
By Steve Jones
I hosted this month, but I decided to put my own entry in as...
Why Databases Still Fascinate Me
By Chris Yates
I get asked a lot about why or how I began working with databases...
Forums
How do you approach engineering services consulting?
I’ve been thinking a lot about the role of consulting in engineering projects. Having...
Columnstore index question
Hi experts, I’ve been going through several articles and videos about Columnstore indexes, but...
Transactional Replication
Recently stood up a 2022 Enterprise server. Have 8 publications with subscriptions on a...
Question of the Day
Identify a Slipstream Installation
I get a new SQL Server instance from my build team. How can I tell if the instance was installed using a slipstream installation later?
See possible answers