Reverse It
Recently I had a conversation with a colleague that wasn’t aware of the REVERSE function in SQL Server. I had...
2017-06-06
143 reads
John Morehouse | Sqlrus.com
Ola Hallengren: Output File
I’m a huge fan of Ola Hallengren‘s free utility scripts. If you aren’t familiar with it, it’s a great tool to...
2017-06-12 (first published: 2017-05-30)
3,859 reads
Ola Hallengren: Output File
I’m a huge fan of Ola Hallengren‘s free utility scripts. If you aren’t familiar with it, it’s a great tool to...
2017-05-30
364 reads
Experienced DBA: Rookie Mistake
M.A.S.H 4077. Mobile Army Surgical Hospital. One of my all time favorite TV shows that I still watch to this...
2017-06-05 (first published: 2017-05-23)
2,402 reads
Experienced DBA: Rookie Mistake
M.A.S.H 4077. Mobile Army Surgical Hospital. One of my all time favorite TV shows that I still watch to this...
2017-05-23
112 reads
Knowing the Options
Have you every executed a query in SQL Server Management Studio, looked at the execution plan, and noticed that it...
2017-05-16
406 reads
T-SQL Tuesday #90 – The Elephant’s Name is Database
T-SQL Tuesday is a monthly blog gathering for the SQL Server/Data Professional community It is the brainchild of Adam Machanic (B|T)...
2017-05-25 (first published: 2017-05-09)
2,073 reads
I’m Speaking! SQL Saturday #617 – Pensacola
In early June, I’ll be traveling to Pensacola, Florida for their annual SQL Saturday. This will be my second time...
2017-05-02
323 reads
SSIS – Adding Connections
Sometimes you get reminded that you don’t know everything about SQL Server and it’s various products Every time I run...
2017-04-27
567 reads
Quick Script: Finding Specific Columns
I like scripts. Scripts that help me do things.
Working in the financial industry, there are always things that you have...
2017-05-04 (first published: 2017-04-25)
1,469 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers