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

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… Read more

0 comments, 552 reads

Posted in Confessions of a Microsoft Addict on 27 August 2016

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… Read more

0 comments, 339 reads

Posted in Confessions of a Microsoft Addict on 25 August 2016

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,… Read more

0 comments, 417 reads

Posted in Confessions of a Microsoft Addict on 16 August 2016

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.

I’ve recently seen a lot of SQL Server instances… Read more

8 comments, 1,847 reads

Posted in Confessions of a Microsoft Addict on 11 August 2016

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… Read more

3 comments, 401 reads

Posted in Confessions of a Microsoft Addict on 10 August 2016