Office Conditions

I have worked in an office environment for a long time. Going on twenty years in fact. I have worked in a number of different types of environments, but cubicles have been the standard. In fact, in my career I have only had a walled office a couple of times - shared...

read more

K. Fisher’s Homework – Create db

In December the topic of the month for #Tsql2sday was to talk about our learning goals for 2018. One of the goals I put forth was to get better at SQL development. As part of that goal, I also realized I have to get more familiar with Visual Studios. So to help with...

read more

Postgresql follow up

A couple of weeks ago I was given the task of helping a developer figure out why his Postgresql cluster wouldn't fail over. The specific problem was to test failover prior to launching the Postgresql cluster in to Production. Sounds easy enough,, right? Setting things...

read more

Update: Six Months later

Six months ago, I accepted a new position in Duluth, MN and moved to house we already owned in Wisconsin not too far from Duluth. And by not too far, my commute is about an hour, depending on the weather. It's about the same drive time I had in Denver, except there's...

read more

Wait Stats Library

Every so often you come across one of those tools that just changes everything. When it comes to troubleshooting tools, this is one of those defing tools. Paul Randal has assembled the greatest library of SQL wait statistics known to man - well to me anyway. If you...

read more

DateTime2 not like DateTime

I came across an article on SQL Server Central written by Claudio Silva (b/t) discussing that you can't do arithmetic operations on DateTime21 like you can with DateTime. For example: Old Way [crayon-5b775251940fb067584666/] You need to do something like this:...

read more

T-SQL Tuesday #101: Tools I forgot

The 101st addition to the SQL monthly blog party is being hosted by Jens Vestergaard (b/t). For the topic this month, Jens has asked which tools are essential to our daily job. Or rather, which tools do I depend on as a DBA. Interesting Topic I would love to say I...

read more

Space: Unused vs Unallocated

I had previously blogged about working on a SQL job that deleted data older than 13 months. Today I thought I would follow up with the database and check to see how much space was available in the database. So I ran a disk usage report out of SSMS and got the...

read more

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close