PASS Summit 2009 Day – 0
Monday at the PASS Summit. It’s always a big day. This year it’s the eve of the Summit and the...
2009-11-03
773 reads
The Best Day of the Year - The SQLServerCentral Party at the PASS Summit
Each year I host an opening night party at the PASS Summit. I set up a deal years ago with...
2009-11-03
1,435 reads
Basic iFTS Monitoring Queries
This is one of the scripts that I will be using for my presentation “Tips and Tricks for Using SQL...
2009-11-03
1,494 reads
Minor Setup Issue with SQL Server 2008 or SQL Server 2008 R2 on Windows 7
Microsoft’s Peter Saddow, who is a Program Manager on the SQL Server Setup team has a post in the SQL...
2009-11-02
436 reads
PASS Summit 2009 – Day -1
The official start date for the summit is Tuesday, but trust me, everything kicked off on Sunday when registration opened....
2009-11-02
373 reads
Day –2 (Sun) at the PASS Summit 2009
Flew out of Orlando direct to Seattle, leaving at 8:30 and arriving about 1130 am Seattle time. Nice flight, no...
2009-11-02
361 reads
Follow Up to Maintaining Security and Performance Using Stored Procedures Part I – Using Execute As
This is a follow up to Maintaining Security and Performance using Stored Procedures Part I – Using EXECUTE AS because of...
2009-11-02
476 reads
Fingers Crossed on a Short Flight
I'm heading to Seattle in a couple hours. Bags packed, I've completed my run for the day, and getting ready...
2009-11-02
369 reads
Free Books at Red Gate Booth at PASS Summit
Red Gate Software will be handing out a limited number of free paperback books at their booth at the 2009...
2009-11-02
593 reads
2009 PASS Community Summit Registration Starts Out Strong
Registration for the 2009 PASS Community Summit started out strong with many attendees registering early the Sunday evening before the...
2009-11-02
489 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