-->
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: June 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, 510 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, 767 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, 347 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