Category Archives: Uncategorized

File this under the list of “I didn’t know that function existed”. So today I was looking to add the day of the week next to the date of previous and upcoming appointments to a report for an Oncology practice, … Continue reading →

I enjoyed this article, How DBAs Can Adopt the Craftsman Mindset. This quote jumped out at me: Recently I finished the book So Good They Can’t Ignore You, by Georgetown computer science professor Cal Newport. While the book is certainly … Continue reading →

So one of the things I have to do a lot in my current job is build web pages in SQL Server. SQL is not normally what you use to build web pages, but it is what is available to … Continue reading →

So indulging some. My family growing up enjoyed following some Space news, starting with my dad, and now into his grand kids. It has become a family tradition to go to the Space Access conference in Phoenix http://space-access.org/. This year … Continue reading →

I was reading https://www.simple-talk.com/sql/t-sql-programming/checking-the-plan-cache-warnings-for-a-sql-server-database/?utm_source=ssc&utm_medium=publink&utm_content=checkingplancache And since I didn’t want to run his function for the ~150 databases I deal with on the production server, I wrote a variation to check the plan cache for warnings on all: — ============================================= — … Continue reading →

*Let me start with a disclaimer, this is not the right solution for most people.* So I ran into a situation where most times a OLTP database was using only 20MB of log space at a time.  I’ll have to … Continue reading →

I went to the SQL Saturday in Richmond, had a fabulous time, my first time at a SQL Saturday.  PASS (Professional Association of SQL Server http://www.sqlpass.org/) and the local user SQL Server user groups help organize the SQL Saturday events, vendors help … Continue reading →

One of the first tools that was a lifesaver in my role as an Accidental DBA was sp_whoisactive from Adam Machanic.  The situation was SQL server was unresponsive and we were trying to sort out what was happening.  The Activity … Continue reading →

I heard the term “Accidental DBA” and knew there were kindred souls out there.  For me has worked out as, “You’re not afraid of the database? Congratulations, you’re the new expert.”  This always made me feel like something was wrong, after … Continue reading →