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-5ae072e4e9e68019776946/] You need to do something like this:...

Database Administration is changing

Steve Jones (t|b) wrote a blog post talking about the death of the title Database Administrator.Mind you, he was talking about the title of DBA, not the actual job of being a DBA. Semantics, right? If you look across the inter-webs, the death of the DBA has been a...

A Month of SSMS

One of the things that has always frustrated me with Microsoft's tools like SSMS and Visual Studio, is the sheer depth of the tool. Figuring out how to create an SSRS or SSIS package in Visual Studio the first few times can result in half a day wasted. SSMS can be...

SQL version numbers

This is one of those tools I use all the time. I'm always looking at the version number to see which version of SQL with SP/CU version I am working with. SQL Version numbers and patch...

Error 18456 State x

I use this link all the time to troubleshoot login errors in the SQL error log. Aaron Bertrand recently moved his blog, so I wanted to make sure I had an updated link for my reference. https://sqlblog.org/2011/01/14/troubleshooting-error-18456

Oh look, another New Year…

Oh look, another New Year…

Yes, it's January already and that means it's a New Year. Which means, it's that time of year for reviews of the last year, resolutions for the new year, and hope springs eternal. Only, this year I haven't had time to look up to do a year in review, and I'm not...

New Job Update

I'm a bad DBA, at least from the standpoint of blogging. Only because I haven't done much of a lately. I did make sure to get a post in for TSQL2sDay to mention who I was thankful for. That was a great topic. So…if you're wondering why I haven't blogged, or have...

The Universe is funny about change

Interesting title on a blog dedicated to technical ideas like SQL Server huh? Well there's a reason for this, which I'll divulge shortly. After I moved back to Colorado from Oklahoma in 2014, I took a full time position as a SQL DBA for an area hospital. I've had the...

Group BY: SSMS Shortcuts

Every so often, you come across game changing information. Most of the time, this type of information costs money. So it is EXTREMELY rare to come across this type of information for free. With that being said, I want to give a shout out, and HUGE Thank You, to Brent...

Feeling refreshed

I mentioned in my last post that I was feeling a bit burnt out. Applying a lot of pressure to myself, feeling like I had to learn everything right now. I took 6 days off over the 4th of July weekend to go camping and a class on Fly Fishing. It put some things into...

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