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

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, 509 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, 303 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, 765 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, 346 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, 356 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

10 comments, 2,056 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, 361 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,614 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,200 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,666 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, 376 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, 556 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, 349 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,880 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,918 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, 2,036 reads

Posted in Confessions of a Microsoft Addict on 2 February 2017

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,656 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, 456 reads

Posted in Confessions of a Microsoft Addict on 30 December 2016

Newer posts

Older posts