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.
Month: 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 to thank SQL Server Central, Brent Ozar, and the others that have reposted my blogs and sent traffic my way. #ThanksToAll!
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?
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.
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 you need doesn’t exist?
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 fare. 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 Clippy was included in SSMS?