-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Confessions of a Microsoft Addict

Daniel Janik has been supporting SQL Server for 18 years as a DBA, developer, architect, and consultant. He spent six years at Microsoft Corporation supporting SQL Server as a Senior Premier Field Engineer (PFE) where he supported over 287 different clients with both reactive and proactive database needs. Daniel has spoken at several SQL Saturday events across the US and Caribbean and regularly speaks at PASS local chapters.

Archives: July 2016

Off-Topic: Phone number spoofing. Why is this still a thing?

A bit of history

Long ago there were such things called diverters. The phone company used them so employees could dial a number and get a second dial tone; this way when dialing long distance the charges would be billed back to the company and not the employee.

I recall… Read more

2 comments, 545 reads

Posted in Confessions of a Microsoft Addict on 29 July 2016

SQL Server 2016 FK operator bug?

I recently read an a blog on MSDN that covered new features for the query optimizer in SQL Server 2016. One of the topics covered was a new operator for foreign key checks.

This new operator certainly looked like it simplified the graphical plan considerably; so, I thought I’d test… Read more

0 comments, 1,728 reads

Posted in Confessions of a Microsoft Addict on 25 July 2016

I’m speaking at the first ever SQL Saturday San Antonio on 8/13/16!

San Antonio is such a great city with a lot to see and do, such as the Alamo and the river walk. I’m excited to be speaking at their very first SQL Saturday!!

My session is on troubleshooting and monitoring storage, including SAN, flash, and in Azure. If you ever… Read more

0 comments, 271 reads

Posted in Confessions of a Microsoft Addict on 23 July 2016

Off topic–Would you SQL your license plate?

I was recently browsing www.myplates.com and I’ll say it’s actually quite fun to see what plates people have randomly bought. I found it easy to spend 15 or so minutes typing in all sorts of fun and silly things into the search just to see what would come up.

Here’s…

Read more

2 comments, 371 reads

Posted in Confessions of a Microsoft Addict on 21 July 2016

Retrieving diagnostic data from SQL Server’s Default Trace

Have you ever tried to query the contents of the default trace and then spent more time trying to figure out the name of the oldest file than the actually analyzing the data?

A while back I wrote a query to quickly get the oldest file name in the default… Read more

0 comments, 318 reads

Posted in Confessions of a Microsoft Addict on 18 July 2016

I’m speaking at SQL Saturday Baton Rouge on 8/06/16.

If you’re in Louisiana or Texas this is one SQL Saturday you won’t want to miss. This annual event is one of the largest SQL Saturday events each year with over 600 actual attendees.

 

My session is titled “Everything you ever wanted to know about query tuning in SQL… Read more

0 comments, 218 reads

Posted in Confessions of a Microsoft Addict on 18 July 2016

Azure SQL Database waits you should be aware of…

I’ve been using Microsoft’s cloud database for some time now. I’ve had a few customers with various performance problems and thought I’d take a moment to highlight the interesting behavior you may run into as well.

As you can expect with any type of SQL Server solution, the normal wait… Read more

1 comments, 1,454 reads

Posted in Confessions of a Microsoft Addict on 15 July 2016

Join me for a free SQL Performance webcast on July 14th!

With less than we week away, I can say that I’m really excited to reach more people in the community and share my knowledge. I’ve delivered webcasts for Microsoft Premier customers before but never one for the greater SQL community.

This session will cover query plan analysis and the techniques… Read more

2 comments, 315 reads

Posted in Confessions of a Microsoft Addict on 8 July 2016

New SQL Server community tool

For those of us in the US, it’s our day of independence. A day that stands for FREEDOM and happiness. Fireworks will light up the sky tonight! For the rest of the world it’s another random day in July. But don’t worry everyone can celebrate “Free”dom with this new community… Read more

3 comments, 1,110 reads

Posted in Confessions of a Microsoft Addict on 5 July 2016