SQL MVP Available for Database Needs....
Recently, I wrote about and introduced us to, SQLBif, a
caricature of a SQL DBA who was down on his luck,...
2012-07-16
1,387 reads
Blog Posts
SQL SERVER:How Can I Get Notification Alert When Fail Over Happened ?
It was long time I was searching for simple solution to get notification alert in my inbox when ever fail...
2012-07-16 (first published: 2012-07-05)
5,075 reads
Talent Shift
Today a friend Kevin Edward Kline announced he was joining SQL Sentry. Last week Kevin announced his intent to leave...
2012-07-16
551 reads
Why Attending a Monday Pre-con Will Be Awesome
Why Attending a Monday Pre-con Will Be Awesome
PASS Summit 2012 Speaker
The SQL PASS Summit 2012 is coming up in a...
2012-07-16
1,136 reads
Speaker Selection for SQLSaturday Orlando–More!
More speakers from Florida! Scott Klein lives in Seattle now, but we still consider him an honorary Floridian according to...
2012-07-15
650 reads
2012-07-15
1,146 reads
SQLSaturday Site Wish List
Overall I find the site to be useful and responsive, but sometimes I see small things that I wish were...
2012-07-15
649 reads
Introducing Windows Server 2012 – Get the FREE eBook!
Introducing Windows Server 2012 - can be downloaded for free here.
This book provides the early, high-level information you need to begin preparing...
2012-07-14
2,268 reads
Lost in Translation – Deprecated System Tables – syscolumns
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-07-13 (first published: 2012-07-04)
2,688 reads
Not enough available space on destination..495GB available!
I bought a USB hard disk recently that I wanted to use to backup some VMware Workstation and some Hyper-V...
2012-07-13
1,006 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
Question of the Day
RegEx Functions II
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') AND BusinessEntityID IN (7,8)See possible answers