DB_NAME() vs ORIGINAL_DB_NAME()
I’d never seen ORIGINAL_DB_NAME until recently and I thought it would be interesting to highlight it out, and in particular...
2018-03-27 (first published: 2018-03-15)
2,885 reads
Blog Posts
How To Steal Data Using Second Order SQL Injection Attacks
One misconception some people have about SQL injection is that it can only happen when concatenating a user input parameter...
2018-03-27 (first published: 2018-03-20)
4,999 reads
Template Explorer Gold Mine
Sometimes as a newbie to SQL Server using SQL Server Management Studio (SSMS) you don’t know about the little gold...
2018-03-27
492 reads
T-SQL Tuesday #62 - Achieving Healthy SQL with MDW
Today:
Tuesday, January 13, 2015 is the 62nd entry and first T-SQL Tuesday
of the year 2015, and I am honored to...
2018-03-27 (first published: 2015-01-13)
8,754 reads
Women in Technology - All are welcome!
I was at SQL Saturday 723 in Rochester, NY last weekend. I was selected to deliver 2 sessions, and I...
2018-03-27
201 reads
Azure SQL Database and Cost Threshold for Parallelism
We all know that the magic figure for cost threshold for parallelism is 5 by default, meaning if the estimated...
2018-03-26 (first published: 2018-03-16)
2,328 reads
Backup and Restore Options for Azure SQL DB
I have decided to do a summary blog post on backup and recovery options for Azure SQL Database. If you...
2018-03-26
580 reads
Introducing The Blame Game
Introducing the Blame Game! Someone has messed up the new anatomy application’s (Mr. Body) performance and no one is willing...
2018-03-26
288 reads
Is the traditional data warehouse dead? webinar
As a follow-up to my blog Is the traditional data warehouse dead?, I will be doing a webinar on that very...
2018-03-26
536 reads
Is the traditional data warehouse dead? webinar
As a follow-up to my blog Is the traditional data warehouse dead?, I will be doing a webinar on that very...
2018-03-26
72 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