-->
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.

Off Topic: Dream Car Garage: 6 Cars, $250k

I was reading Brent’s blog today and decided to make my own $250k dream car garage list. Mostly because I think about this topic a lot and probably spend way too much time researching cars I’ll never own. But you never know!

 

I wanted to differ a bit from… Read more

3 comments, 124 reads

Posted in Confessions of a Microsoft Addict on 18 July 2017

How to display more text in SSMS

Today’s blog post is going to be a short one but can be very helpful if you’re new to SQL Server. From time to time you may find the need to use the text result instead of the default grid result. You can change this by using CTRL-T for text… Read more

0 comments, 189 reads

Posted in Confessions of a Microsoft Addict on 14 July 2017

Reading the log on SQL for Linux

The SQL Server errorlog is a really helpful place to find all sorts of fun facts about your SQL Server instance. As last checked today (6/29/2017) the latest CTP build seems to have problems reading the log.

This can be a problem when trying to diagnose an issue. Here’s what… Read more

0 comments, 301 reads

Posted in Confessions of a Microsoft Addict on 29 June 2017

1 year of blogging

It’s hard to believe but a full year has now passed as of today. It’s my blogoversery! Can that be a word? Someone hash tag it please.

To date, I have just under 15,000 views and have touched 112 countries around the world! I couldn’t be more excited and wanted… Read more

2 comments, 208 reads

Posted in Confessions of a Microsoft Addict on 22 June 2017

Access to SQL Server is finally coming

Imagine a world where one of the software giants releases their brand new operating system and a new application architecture that doesn’t allow developers to natively connect to a database. Sounds silly right?

It may sound silly but it’s our world. It’s the “right now”.  It started with Windows 8,… Read more

1 comments, 278 reads

Posted in Confessions of a Microsoft Addict on 9 June 2017

Time saving trick for PowerShell and CMD

Real quick and simple post for today. Having grown up with a computer since the 80’s, I can tell you I still love DOS. In fact, I even have MS DOS mobile on my #WindowsPhone.

I have years of experience crafting batch files, playing of BBS sites before the… Read more

0 comments, 252 reads

Posted in Confessions of a Microsoft Addict on 8 June 2017

SQL Server Monitoring: Creating your own metrics

The one and only important factor in monitoring is data. How much of x and how little of y? If you don’t know these values then you’re shooting in the dark. Microsoft has done a great job adding critical data points over the years; but, what happens when the data… Read more

1 comments, 262 reads

Posted in Confessions of a Microsoft Addict on 5 June 2017

If Clippy found his way to SSMS

Recently my wife and I were comparing Cortana with Siri. It’s sometimes fun to compare virtual assistants to see how well they fair. Try asking Siri: “What time is it in GMT?”. We found a lot of others that Cortana knows that Siri doesn’t. This got me thinking. What if… Read more

8 comments, 1,884 reads

Posted in Confessions of a Microsoft Addict on 1 June 2017

Not SQL: Taking a stand against scammers

If you’ve read my blog you’ll probably know that I don’t like our lack of forward thinking when it comes to phones. Spoofing is something that should not exist and if we all took a stand to make changes to phone technology then it simply couldn’t exist.

I once got… Read more

1 comments, 293 reads

Posted in Confessions of a Microsoft Addict on 3 May 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,347 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, 1,951 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,512 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, 295 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, 273 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, 309 reads

Posted in Confessions of a Microsoft Addict on 5 April 2017

New SSMS bug?

It seems like SSMS has seen better days. Many developers I have worked with recently complain about Out of Memory issues and other bugs and I personally miss the days of Query Analyzer.

I discovered this issue while working in SSMS on my Surface and I’m wondering if it’s just… Read more

3 comments, 508 reads

Posted in Confessions of a Microsoft Addict on 22 March 2017

DBA 101: File growth

Maintaining a database is an important job of the DBA role. One of the many maintenance tasks is ensuring that the disk does not fill up and your files are able to grow over time.

Additionally, you don’t want the files to grow in massive amounts. 1024 MB (1 GB)… Read more

4 comments, 274 reads

Posted in Confessions of a Microsoft Addict on 3 March 2017

DBA 101: Unique Constraint vs Unique Index

Designing a rock solid application and database can be difficult. New features and overlapping features mean that you’re able to accomplish a single task in many ways. For instance the numeric and decimal data types. Which should you use?

While on the surface it would seem that unique constraints  and… Read more

0 comments, 2,779 reads

Posted in Confessions of a Microsoft Addict on 3 March 2017

DBA 101: What you may be missing with “Missing indexes”

If you’ve read my blog, I’m sure by now you know that I have no love for GUI tools. I will say they are improving every day and maybe, just maybe, we will see the day when you can click happily away and do everything you want. Sadly, this is… Read more

8 comments, 2,690 reads

Posted in Confessions of a Microsoft Addict on 8 February 2017

DBA 101: Altering a column

People always ask me what tools I use. Mostly this question comes from the topic of monitoring. I can honestly say that I don’t love any tools and you shouldn’t either.

My time at Microsoft placed me at nearly 300 different clients. As a Microsoft employee I never liked saying,… Read more

3 comments, 1,952 reads

Posted in Confessions of a Microsoft Addict on 2 February 2017

Older posts