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

July 28, 2016August 11, 2016 Daniel Janik2 Comments

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 my friend using them to dial in to a BBS in the early 90’s. The BBS was in FT Worth, which was long distance for us on the other side of Dallas. He had a program that would dial a block of phone numbers all night long and give a report of which numbers gave a second dial tone. Could you imagine a phone call at 3:00 AM waking you? This was before Caller ID so no one could call him back or ever know who called.

If I recall correctly, I believe Hollywood had a few “Hacker” movies where the actor used diverters to mask their number.

SQL Server 2016 FK operator bug?

July 25, 2016July 29, 2016 Daniel JanikLeave a comment

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 it out. Here’s what I found:

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

July 23, 2016 Daniel JanikLeave a comment

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

Off topic–Would you SQL your license plate?

July 21, 2016August 11, 2016 Daniel Janik2 Comments

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.

Retrieving diagnostic data from SQL Server’s Default Trace

July 18, 2016July 20, 2016 Daniel JanikLeave a comment

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?

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

July 18, 2016July 18, 2016 Daniel JanikLeave a comment

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.

Azure SQL Database waits you should be aware of…

July 15, 2016 Daniel Janik1 Comment

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.

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

July 8, 2016July 8, 2016 Daniel Janik2 Comments

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.

New SQL Server community tool

July 4, 2016August 11, 2016 Daniel Janik3 Comments

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

I’ve spent the last couple years writing, improving, and using this tool at my customers. This health check now has more than 300 data points and even pulls out bad practice and concerns from your procs. As of today, I gift it to the community. #SQLFAMILY

SQL TECH BLOG

Month: July 2016