How to log SQL Server Custom Error in Windows Event Log ?
SQL server gives an option to log custom errors in windows event log. We have 2 options of achieving this.
Option...
2012-09-17
968 reads
Blog Posts
Logon Triggers: SQL Server
As the name implies, logon triggers fire in response to the logon event that is raised when a user sessions...
2012-09-17
24,360 reads
Running a SQL Server Environment at Home Using Native Boot Virtual Hard-Drives (VHD)
I’ve run into a road block. As a Microsoft Certified Trainer, I have all the software I need to get...
2012-09-17
1,178 reads
SQL Saturday 154 Rocked - Great Job St. Louis!
This last Saturday (09/15/2012) I traveled to St. Louis to present at #sqlsat154. My colleague David Klee (blog/@kleegeek) and I...
2012-09-17
895 reads
SQL Server : Usage of OVER Clause
Over clause can be used in association with aggregate function and ranking function. The over clause determine the partitioning and...
2012-09-17 (first published: 2012-09-10)
10,463 reads
SQLSaturday #160 – Get your SQL learn on in Kalamazoo
If you’re planning on being in the Kalamazoo, MI area this weekend, or just feel like taking a road trip,...
2012-09-17
748 reads
Why I dislike Third Party Database Monitoring Tools
I have to admit I am not a fan of the various 3rd party monitoring tools (after using a few...
2012-09-17
1,907 reads
SQL Server 2012 Diagnostic Information Queries (September 2012)
Here is the September 2012 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2012-09-16
1,221 reads
SQLSaturday #171, Pittsburgh
Date: October 6, 2012
Title: Searching for the Holy Grail of DDL Auditing
Abstract:
Who altered this view and how? When was that...
2012-09-16
693 reads
Attendant’s checklist to a SQL Saturday event
Weeks Before The Event
Check for conflict in Schedule
Family Activities (Y/N)Business Appointment (Y/N)Other Commitments (Y/N)Plan the Trip
Distance (calculate travel time)Budget $ (Gasoline,...
2012-09-15
711 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
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
RegEx Functions II
Comments posted to this topic are about the item RegEx Functions II
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