INPUT and OUTPUT type parameters in stored procedures

Output-only parameters do not exist in the T-SQL procedures. They are all either input-only or input/output. The OUTPUT keyword in the procedure’s definition or its invocation, designates the input/output...

INPUT and OUTPUT type parameters in stored procedures

Output-only parameters do not exist in the T-SQL procedures. They are all either input-only or input/output.
The OUTPUT keyword in the...

Webinar: Performance Troubleshooting Using Wait Statistics by Paul Randal

Hi Folks, Join Webinar on Webinar: Performance Troubleshooting Using Wait Statistics. Tue 3/07/2017 from 10:30 PM to 11:45 PM ISTClick [Here] to join

Webinar: Performance Troubleshooting Using Wait Statistics by Paul Randal

Hi Folks, 

Join Webinar on Webinar: Performance Troubleshooting Using Wait Statistics. Tue 3/07/2017 from 10:30 PM to 11:45 PM IST

Click [Here] to join

Help Me, Help You, Deliver DevOps

I believe in DevOps.
Actually, that’s a pretty horrible way to put it. It’s not about belief, like keeping Tinkerbell alive.

I...

The $650 SQL Saturday

SQL Saturday #596 – Denver BI Edition was held on Feb 25, 2017. In keeping with my idea for a slimmer...

Power BI Custom Visuals Class (Module 41 – Image Viewer)

In this module you will learn how to use the Image Viewer Power BI Custom Visual.  The Image Viewer visual...

Copying your SQL Database

If you ever need to move a copy of a  SQL database in Azure across servers then here is a...

New Article – Application Database Security Design (Part 1 – Authentication)

In conjunction with the webinar I gave last month for MSSQLTips, I’ve started an article series on application database security...

How Row versioning impact tempDB ?

Scenario: DBA found that tempdDBdatabase usage is getting high and most of the size is consumed by row versioning. DBA...