What SQL Server components are installed on this machine?
Figuring out what components of SQL Server are installed on a particular machine has always been a task that has...
2015-09-14
631 reads
SQL Server’s statistics
Again another interesting article from RED GATE …
SQL Server’s statistics provide the query optimizer with the information it needs to...
2015-09-14
880 reads
Split personality text editing in SSMS with Sublime Text 3
Split personality text editing in SSMS with Sublime Text 3
My preview post showed a demonstration of the multi-cursor editing power...
2015-09-14
207 reads
SQL Server – Methods to find running totals of a column
HI friends, in some working scenario or during interviews we got the task to find the running totals of a...
2015-09-14
620 reads
Houston TechFest Presentation Downloads
Thanks for joining me at Houston TechFest 2015 at the NRG Center in Houston, TX! Big congrats to Michael and...
2015-09-13
480 reads
HammerDB Performance Collection with SQL Server – Updated
A while back, my friend Mike Fal ( b | t ) released a PowerShell script that can sample the counter inside SQL...
2015-09-24 (first published: 2015-09-13)
2,414 reads
Step by Step SSIS learning What Data Conversion use in SSIS ? TIP#116
Dear Friends,
In the series of step by step learning of SSIS this is part #6 in which we are going...
2015-09-13
963 reads
GAM and SGAM
In my previous blog, I tried to explain How SQL Server Manages your data in pages and extents. (Link for...
2015-09-12
458 reads
GAM and SGAM
In my previous blog, I tried to explain How SQL Server Manages your data in pages and extents. (Link for...
2015-09-12
853 reads
How to use SORT control in SSIS ? TIP #115
Dear Friends,
In the series ofLearn SSIS step by step this is the 5th post. Now from this post we are...
2015-09-24 (first published: 2015-09-12)
2,304 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...
Split Large Queries in Athena with a Simple Modulo Trick
Comments posted to this topic are about the item Split Large Queries in Athena...
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