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

Query tuning 101: Non-trusted Foreign Keys

Foreign keys are an interesting feature of relational databases. They help enforce data integrity, sometimes help improve performance by eliminating joins, and sometimes slow down DML operations (inserts, updates, and deletes).

For this post I want to focus on what a non-trusted FK or constraint is. By it’s definition, SQL… Read more

4 comments, 2,659 reads

Posted in Confessions of a Microsoft Addict on 30 December 2016

Off topic: The two cycle engine and your career path

I’ve been in technology for twenty years now. I’ve seen hundreds of environments, nearly 300 while employed at Microsoft alone.

One thing that I’ll always remember is my first day at Microsoft and not because I found out that health care was 100% free; though, that was a pleasant shocker.… Read more

0 comments, 457 reads

Posted in Confessions of a Microsoft Addict on 30 December 2016

Using Memory Optimized tables for reporting

I recently worked on a project for fraud. This project needed to relate 67 million accounts to one another “Kevin Bacon” style. This means that each unique account may tie to another account on ssn, email, home phone, business phone, or any other PII type metric.

The goal is… Read more

0 comments, 627 reads

Posted in Confessions of a Microsoft Addict on 27 December 2016

Nintendo NES Classic Edition giveaway! #SQLFamily

I’ve managed to get my hands on a Nintendo NES Classic and I’m going to give it away. The details are as follows:

The winner will be chosen with random # generation via Microsoft SQL Server 2016. This is intended for the #SQLFamily community so I’m only posting this to… Read more

0 comments, 579 reads

Posted in Confessions of a Microsoft Addict on 13 December 2016

What keeps clearing my query stats?

I was building out a blog post about cardinality today and noticed that sys.dm_exec_query_stats was getting cleared my my Surface Pro 3 dev instance about every 30 to 60 seconds.

I opened object explorer to check if any jobs were running in SQL Agent that may be running DBCC FREEPROCCACHE Read more

5 comments, 1,635 reads

Posted in Confessions of a Microsoft Addict on 8 December 2016