Influence the Program
You have the opportunity to influence the makeup of the conference agenda for the PASS Summit
SSIS Package with a Derived Column
I created this article to demonstrate the use of derived columns inside a ForEachLoop Container for a client requirement for some auxiliary marketing reports. I found the Data Conversion tool useful to escape the problem of mismatched data types, which is an issue with versions of Microsoft SSIS.
Building a Custom Blocked Process Report
Blocking in SQL Server is normal behavior, but excessive blocking can lead to many complaints and is a symptom of poor performance. SQL Server contains a vast amount of information that can help when troubleshooting performance issues like blocking, but understanding and gathering that information when you need it is a lot of work. Darko Martinovic explains his solution for a custom blocking report.
Configure Read Only Routing
The advantage of Setting the readable secondary as Read-Intent Only will allow the secondary server to serve the read-only workload only if the connection string of the application contains Application Intent=Readonly parameter.
Finding the Right Data
Big Data hasn't been in the news, perhaps because more organizations are realizing they need the right data.
Add a SQL Server Database to an Existing Always On Availability Group
In this tip, Manvendra Singh will cover how to add another database to an existing Always On Availability Group.
Automatic Plan Correction
SQL Server 2017 lets you solve parameter sniffing problems - Automatically!
Bad Days
This Friday Steve Jones wants you to look back and cringe a bit. Share with the rest of the community what a bad day was for you and see if it was really as bad as you think.
Liberating the DBA from SQL Authentication with AD Groups
It's 15 years after the beginning of the century. Time to eliminate the security exposure of SQL logins, and implement integrated security. Active Directory Groups make this easy for the DBA.
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