Sysmail_help_Account_sp – SQL Server Database Mail Stored Procedure – Part 6
Hi friends, in this blog we will learn how to get information about database mail account using stored procedure sysmail_hep_account_sp....
2015-05-30
875 reads
Finding gaps or missing dates in a date range using TSQL
Here’s a quick how-to on returning temporal data set that includes missing dates. Suppose you are tasked to query an...
2015-05-29
16,371 reads
Query Progress Tracking in SQL Server for the DBA VC
This past Wednesday, I delivered my session, “Query Progress Tracking in SQL Server” to the DBA Virtual Chapter.
The session covers...
2015-05-29
1,426 reads
005 – Antiques Roadshow - WaterOx Consulting
Reading Time: 4 minutesAre You Running An Antiques Roadshow? In WOxPod!, episode # 005 –...
The post 005 – Antiques Roadshow appeared first...
2015-05-29
1,102 reads
hey its time for 2016!!!
Hi all Yeah its true microsoft announced SQL server 2016 and CP2 has been released to public also we can...
2015-05-29
1,222 reads
Detach and Attach All User Databases
Sometimes you are in a scenario where you need to transfer a large number of databases from one server to...
2015-05-29
1,123 reads
Installing SQL Server 2016 CTP2 – UI Changes
SQL Server 2016 CTP2 public build was released by Microsoft yesterday, and if you haven’t downloaded it yet, then drop everything(No,...
2015-05-29
3,262 reads
Earning my MCSE: Business Intelligence Certification
I earned my MCSE: Business Intelligence Certification on May 27, 2015. It was a long road, but I did it....
2015-05-28
1,524 reads
SQL Server 2008 R2 SP3 Install Errors
Whenever it is time to install a service pack every DBA silently hopes that nothing will go wrong. I would...
2015-05-28
2,105 reads
Notes on the May 27, 2015 PASS Town Hall
I attended the online Town Hall yesterday, the second one that PASS has held this year. The recording should be...
2015-05-28
859 reads
Blogs
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Force join by longest possible choice
Title pretty much says it. I want to join to a table that has...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
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