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

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

Hands-On Data Analysis With Power BI Desktop at PASS BA Marathon

I’m delighted to announce I’ll give a session at the next PASS BA webinar marathon. The topic of this marathon...

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

Monday Coffee 2017-03-06

Last week Docker announced the availablity of Docker Enterprise Edition. The existing version of Docker that I’ve been using has...

Queries with optional parameters

These are those queries where you are pulling for, let’s say, a first name, a last name, a state, and/or...

SQL Clone

Today is the launch of SQL Clone, a great new tool that helps you quickly and easily provision SQL Server...

SQL Server Fixed Role Permissions

It is very important to understand who has what level of access within the server and databases on that server. Sometimes we see users being granted server or database...

Using GROUP BY instead of DISTINCT

Recently, Aaron Bertrand (b/t) posted Performance Surprises and Assumptions : GROUP BY vs. DISTINCT. In it he says he prefers GROUP...

The Ebb & Flow of Community Participation

It’s an interesting moment when you discover the SQL community (or any other I suppose). It’s the moment of finding the...