Table valued parameters (TVP)
Table values parameters
How we can pass multiple rows in stored procedure or function as a parameter?
Table-valued parameters are a new...
2015-10-06
2,013 reads
Blog Posts
TechFuse Minnesota Follow Up
My Session: Using Azure SQL Database for Enterprise Needs
On 10/6/2015, I presented on Azure SQL Database at TechFuse Minnesota. Some...
2015-10-06
466 reads
Testing Sum By Month
I’ve been on a testing kick, trying to formalize the ad hoc queries I’ve run into something that’s easier to...
2015-10-06
663 reads
Testing Sum By Month
I’ve been on a testing kick, trying to formalize the ad hoc queries I’ve run into something that’s easier to...
2015-10-06
556 reads
The Future Virtualization of the Workforce - Telecommuting
Welcome to the 21st century! 20th
century habits die hard! What am I
talking about today? I’m talking about the virtuous virtue...
2015-10-06
1,495 reads
Today at 12pm Central: #MinionEnterprise Talk – Backup Management!
Register here. In our monthly series about Minion Enterprise – the new SQL Server management solution – Sean and Jen will show you how...
2015-10-06
641 reads
TUGA IT Conference 19-21st of May 2016
Between 19th-21st of May 2016, we (TUGA Association) are organising a major IT event in Portugal – TUGA IT.
Targeting Microsoft Data...
2015-10-06
546 reads
Backup Deployed Sessions
Having just completed several segments on the metadata for deployed sessions, it is time to bring all of that information together and see how it can be used -...
2015-10-05
3 reads
Deployed Session Settings
You may recall that I wrote about how to look at the deployed session metadata. Today, I will be talking...
2015-10-05 (first published: 2015-09-28)
1,231 reads
Detect Worst Performing SQL Queries During Peak Hour
on 10th oct 01.30 pm pst, i will be speaking on “detect worst performing sql queries during peak hour” @ sqlsaturday,...
2015-10-05
776 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