-->
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: October 2016

Why Halloween slowed your queries

Let me start by saying that this isn’t your typical post about the Halloween problem. This is intended to describe a couple different performance problems you should be keenly aware of.

If you’ve never heard of the Halloween problem then I suggest you read about it from Paul White’s blog… Read more

0 comments, 471 reads

Posted in Confessions of a Microsoft Addict on 31 October 2016

Thank you to @MrDenny

I wanted to take a quick moment to thank Denny Cherry for selecting me for Speaker Idol this year.

For those of you that don’t know about Speaker Idol or SQL Summit you can find more about them here: http://www.sqlpass.org/summit/2016/Sessions/Details.aspx?sid=54321

The competition was great and everyone did very well. If… Read more

0 comments, 437 reads

Posted in Confessions of a Microsoft Addict on 29 October 2016

Why I don’t love SELECT INTO

Long ago there were locking / blocking problems with the SELECT INTO statement. That’s not the case anymore and for AdHoc operations and investigation of data SELECT INTO is very helpful.

If you’re not aware of what SELECT INTO is or its benefits here’s an example:

SELECT City, COUNT(1)…

Read more

4 comments, 557 reads

Posted in Confessions of a Microsoft Addict on 20 October 2016

Read this before using SQL 2016 Temporal Tables

I’ve been testing the new Temporal Tables feature over the past day to see about using it in one of our production databases. It’s a neat feature that honestly adds a boat load of possibility around logging.

In my testing I noticed that user created tables seem to store the… Read more

2 comments, 2,558 reads

Posted in Confessions of a Microsoft Addict on 17 October 2016

A quick note comparing ISNULL vs COALESCE

There are hundreds of blogs that compare the T-SQL ISNULL function with the ANSI standard COALESCE function. There are also plenty of arguments of why you should use one over the other.

I’m in the ISNULL camp. I once argued about this with a Microsoft MVP. He was adamant that… Read more

1 comments, 524 reads

Posted in Confessions of a Microsoft Addict on 13 October 2016

Off-topic: If you’re in Texas and 18+ yrs old

Today is the last day to register to vote in Texas. I’m not sure about other states in the US but I’m sure the time is almost up.

Check to see if you’re registered here:  http://www.votetexas.gov/register-to-vote/

This site also has information about registering. You’ll never see anything from me about… Read more

0 comments, 299 reads

Posted in Confessions of a Microsoft Addict on 11 October 2016

Making the case for CamelCase naming

Coding and database standards like a religion or politics. Some people are fanatics and others really don’t care whatsoever. Getting stuck between any combination of the right and left or those that don’t care can be entertaining and sometimes outright dangerous.

The HBO show Silicon Valley has a whole episode… Read more

10 comments, 3,078 reads

Posted in Confessions of a Microsoft Addict on 10 October 2016

Understanding the new MAXDOP settings in SQL 2016

If you have just begun using SQL Server 2016 or you have been using it for a while now you may not have noticed the new MAXDOP settings.

Here’s what you need to know

SQL Server 2016 introduced a really neat feature which allows you to configure MAXDOP and some… Read more

0 comments, 1,817 reads

Posted in Confessions of a Microsoft Addict on 5 October 2016

SQL 2016 SSMS memory leak?

Has SSMS (SQL Server Management Studio) been crashing on you? Have you been getting Out of Memory messages when attempting to run queries?

You may have noticed that this tends to occur after you’ve opened and closed 40 to 50 query windows. I’ve noticed this when I have had as… Read more

10 comments, 2,697 reads

Posted in Confessions of a Microsoft Addict on 4 October 2016

An observation about Unicode in SQL Server Management Studio

A week or so ago I read a blog post and tweet about using an emoji in SQL Server. This inspired me to use the ninja cat emoji for my demo database name and something interesting was discovered.

How to use an emoji

You can use emojis very easily by… Read more

3 comments, 1,837 reads

Posted in Confessions of a Microsoft Addict on 2 October 2016