Row Numbers and Running Totals in SSIS
During data load or transformation processes, capturing a distinct row number for incoming data can be beneficial for the ETL...
2015-05-26
3,321 reads
Sysmail_help_profile_sp – SQL Server Database Mail Stored Procedure – Part 4
Hi friends, today we will learn how to get information about database mail profile using stored procedure sysmail_help_profile_sp. Sysmail_help_profile_sp stored...
2015-05-26
340 reads
4 Things You’ll Need Before Installing a Failover Cluster Instance
Your servers are either provisioned or racked, your sys admin has taken care of installing the Failover Clustering feature and...
2015-05-25
503 reads
Changing NULL to NOT NULL – Dealing with Data
I wrote recently on how to alter a column in SQL Server from NULL to NOT NULL in a simple...
2015-05-25
675 reads
Database Administration via CrowdSourcing
According to Wikipedia:
Crowdsourcing is the process of obtaining needed services, ideas, or content by soliciting contributions from a large group...
2015-05-25
334 reads
Database Administration via CrowdSourcing
According to Wikipedia:
Crowdsourcing is the process of obtaining needed services, ideas, or content by soliciting contributions from a large group...
2015-05-25
687 reads
2015-05-25
558 reads
Presenting To The Orlando .Net Users Group on June 11, 2015
I’ll be returning to ONETUG just less than a year from my last presentation, delivering technical content and evangelizing for...
2015-05-25
318 reads
Last Cumulative Update – 16 for SQL Server 2012 Service Pack 1 Is Now Available !
The 16th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft...
2015-05-25
705 reads
Cumulative Update – 6 for SQL Server 2012 Service Pack 2 Is Now Available !
The 6th cumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft...
2015-05-25
980 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