Up until SQL Server 2016, we had to write our own functions to split a CSV string into a table list. This was accomplished by writing a table value user defined function.
Join me and Kalen Delaney today for 24HOP
I’m excited to be monitoring Kalen’s session on concurrency. The session is today and is titled “Locking, Blocking, Versions: Concurrency for Maximum Performance”.Read More »
When should I use a CTE?
If I had a dollar for every CTE solution to a simple query in the forums (pick any SQL forum), I’d be Mark Cuban. With that said I thought it would be a good idea to ask if a CTE was actually the right solution or if it’s just the new trend and everyone uses them just because they can and all the cool kids are too. Let’s put it this way: If I had a dollar for every time a CTE was misused, I’d be Mark Cuban… or at least Robert Herjavec.
I’m speaking at SQL Saturday 563 in Dallas
This will be my second time speaking at SQL Saturday in Dallas. My first was last year and it was a great time. I enjoyed hanging out with all the attendees and speakers. Who wouldn’t want to have a chat with Kalen Delaney or Bob Ward? The Dallas edition of SQL Saturday is on 9/24 in Arlington at the University of Texas. Be sure to set the date I’m sure this will be a lot of fun and there will be plenty to learn!
My session is A DBA’s guide to whole stack performance troubleshooting. You’ll want to check this out.
You can register for this free event here: http://www.sqlsaturday.com/563/eventhome.aspx
Also, be sure to follow me on Twitter (@SQLSME) and on LinkedIn!
I’m speaking at SQL Saturday 553 in Oklahoma City
This will be my first time speaking in Oklahoma on 8/27 in Oklahoma City. I’ve been to several customers there but have yet to meet people from the users groups.
My session is Analyze your query plan like a Microsoft Engineer! (SQL 2016 Edition). If you deal with tuning, monitoring, or developing queries for SQL Server, you’ll want to check this out.
You can register for this free event here: http://www.sqlsaturday.com/553/eventhome.aspx
Using PowerShell to find Processor issues & more
One of the top three performance killers for SQL Server is lack of processing power. I’d say that it’s second only to storage latency and more of a concern than memory. Although with anything in SQL we can say it depends.
Inside the mind of a c# developer
I’ve been working with SQL Server for 18 years and over that long span I’ve seen a lot of different techniques for tuning and development.
There are essentially two principles of development, Code First and Database First. Naturally, being a life long database professional I’d say that Database First is the only way to properly approach a project. You’d start with a business analyst gathering requirements, build out the database ERD, and then start coding.
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 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?
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!
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!!
SQL TECH BLOG 