2010-09-14
746 reads
PASS Election Ends Tomorrow (Sep 15, 2010)
If you haven’t voted I hope you will. Ballots were sent out via email to those members eligible to vote....
2010-09-14
558 reads
Failing Fast
I’ll have a longer post next week about my own risk strategy, but I wanted to write this first, both...
2010-09-14
622 reads
September OPASS Meeting Tonight!
Live Meeting: https://www.livemeeting.com/cc/usergroups/join?id=NQ65ZG&role=attend
Mini-Session
Topic: Using PIVOT – Going from Static to Dynamic
Sometimes data normalization results in a data structure that is not convenient for...
2010-09-14
460 reads
T-SQL Tuesday #10 - Indexes
It’s time for T-SQL Tuesday again, the brainchild of Adam Machanic (Blog|Twitter), and this month’s topic is Indexes. A thanks...
2010-09-14
1,642 reads
Task Manager - Don't Believe the System Idle Process Percentage
This morning my laptop went to a crawl. I looked, and sure enough, there was an AntiVirus scan running. Argh!...
2010-09-14
3,571 reads
The SQLSaturday Squirrel
A bit of mid week humor. Recently I met up with Jack Corbett to review our room options for SQLSaturday...
2010-09-14
539 reads
Common SQL Server Mistakes - Shrinking Databases
I don’t like there being an easy command to shrink databases, and I especially don’t like seeing the shrink option...
2010-09-14
5,643 reads
SQL Bloggers – Build Your Brand And Sponsor SQLSaturday #49
As you may know we like to try new stuff here in Orlando, and this is another new thing. I’ve...
2010-09-13
613 reads
Quote of the Day
I do not usually post a quote of the day but since this is my own quote I decided to...
2010-09-13
366 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Split Large Queries in Athena with a Simple Modulo Trick
Comments posted to this topic are about the item Split Large Queries in Athena...
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