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...

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...

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...

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...

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...

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...

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...

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 -...

Deployed Session Settings

You may recall that I wrote about how to look at the deployed session metadata. Today, I will be talking...

Detect Worst Performing SQL Queries During Peak Hour