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!
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 and CTRL-D for grid. Read More »
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.
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!
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?
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?
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 Clippy was included in SSMS?
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 a call from “Microsoft Tech Support” stating that my machine was infected and he wanted to access it to help me clean up the problem.
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.