It was a simple enough question, or so I thought. One I felt should be either a simple “yes” or “no”. “Do we block remote desktop connections here?” Sure enough, I got back the quick and simple answer I expected, along with a question for myself. “Nope. We don’t block any RDP sessions. Maybe you … Read more
Last week I was fortunate enough to attend Enterprise Data World in Washington DC. I was not just at EDW as an attendee, I was also presenting two sessions. Since it was my first EDW that meant I had no idea what to expect either as an attendee or as a presenter. On top of that I was … Read more
This week I will be attending Enterprise Data World in Washington, DC. I’m excited to have been given the opportunity to present not one but TWO sessions at the premiere data management conference in the world. On Wednesday, April 1st, I will be presenting a session titled “Designing For Performance or How I Learned To Stop Worrying … Read more
For years I have found myself often needing these three pieces of information with regards to SQL Server: When was the last time the server was restarted? When was the last time the SQL instance was restarted? When was the last time the SQL Server wait stats were cleared? If the server itself is restarted, then the answer … Read more
When you create a database in SQL Server and do not specify a file location for your data and log files SQL Server will rely on the default database file locations as defined in the server properties.
I love learning new things. I feel like a kid again at times, my eyes get wide as I imagine new possibilities using whatever things it is I have found. This is how I felt last week when I came across a feature of SQL Server Management Studio (SSMS) that I had not seen before … Read more
