-->
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: April 2017

DBA 101: Tuning lookups

Sometimes it helps to go back to the basics and indexing is always a great topic. SQL Server has a wide variety of indexes; but, today we’re going classic and talking about Non-clustered indexes.

Microsoft has a lot of great resources discussing these topics, though I thought I’d take a… Read more

0 comments, 2,616 reads

Posted in Confessions of a Microsoft Addict on 27 April 2017

Query tuning 101: What’s a probe residual?

Query tuning is an important process that will probably never go away and sharpening your tuning skills is always a good idea.

I’ve spoken on this topic many times and talked about probe residuals before. Mostly at SQL Saturday events and for some online webinars.

A probe residual is important… Read more

1 comments, 2,202 reads

Posted in Confessions of a Microsoft Addict on 17 April 2017

DBA 101: Comparing two SQL plans

Simple post today: How to compare two plans in SSMS.

This task is a task that is often done by a DBA or developer who is wanting to compare changes of an index or perhaps even comparing queries between DEV and PROD.

As an example, we take the following AdventureWorks2012… Read more

0 comments, 1,667 reads

Posted in Confessions of a Microsoft Addict on 14 April 2017

Way Off-topic: Why cutting the cord was right for me

FYI: This one is way off topic so don’t expect to find any fancy SQL tips here.

I did it. I cut the cord on cable TV. I never saw this coming but a few weeks ago I decided it was time.

How it started

To be more clear, the… Read more

0 comments, 362 reads

Posted in Confessions of a Microsoft Addict on 14 April 2017

T-SQL Tuesday: Finding issues with your query plan

This is my first time blogging with a T-SQL Tuesday topic.  If you follow my blog you’ve probably noticed that one of the topics I enjoy the most is performance and query tuning.

While at Microsoft, I learned a lot from a lot of great people, such as Joe Sack,… Read more

0 comments, 358 reads

Posted in Confessions of a Microsoft Addict on 11 April 2017

Wait Stats, Here and gone again?

Microsoft recently introduced a handy new feature to query plans: waitstats. That’s right, you can get actual runtime waitstats for a query you run.

Though, I’ve seem to run into a small snag with this new feature. I’m running two Surface Pro machines. My older Surface Pro 3 has SQL… Read more

1 comments, 377 reads

Posted in Confessions of a Microsoft Addict on 5 April 2017