Next PASS Summit is Nov 6-9, 2012
After enjoying the entirely reasonable weather in Seattle in October this year we’ll return to our more traditional time frame...
2011-10-19
545 reads
Blog Posts
No longer just an admin but a DB Astronaut : A poem.
Today we have a guest post from Phil Factor as Brad is on vacation.
‘ I used to fettle databases as...
2011-10-19
551 reads
October 2011 SQL Server 2012 Diagnostic Information Queries
Since Microsoft released the official name for “SQL Server Code Named Denali” last week at the PASS 2011 Summit, it...
2011-10-19
831 reads
Query Memory Spills
When you sometimes look at Execution Plans, you can see that the SELECT operator has
sometimes a so-called Memory Grant assigned....
2011-10-19
5,151 reads
RSS Tuning Whitepaper notes and clarifications
This morning this caught my eye on SQLServerCentral.com: Maximizing SQL Server Throughput with RSS Tuning(it came with a catchy SQLCAT...
2011-10-19
674 reads
SQL Server – Moving table with LOB data to different file group
Last week, i posted about moving tables to different file groups by recreating indexes. However, this method does not *work*...
2011-10-19
2,695 reads
Using sys.dm_exec_requests to find a blocking chain
A query that calls sys.dm_exec_requests and pulls the statement text out of the request is a handy script for any DBA's...
2011-10-19
3,181 reads
We Are Community
Today I was planning on writing a summary post of PASS Summit experience but something happened last night that caused...
2011-10-19
1,154 reads
AWE has removed from SQL server 2012
AdvertisementsAWE has removed from SQL server 2012
AWE has removed from SQL server Denali onwards. Say bye bye to 32 bit...
2011-10-18
1,051 reads
ColoradoSQL. in October
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2011-10-18
1,249 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...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
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