Category: Admin

Tip: COLLATE for “Cannot resolve collation conflict” error

Post author By Jen McCown
Post date March 17, 2014
Categories In Admin, Dev, sql server, sqlserverpedia-syndication, SSC, Tech and Learning, Tips
3 Comments on Tip: COLLATE for “Cannot resolve collation conflict” error

Some data professionals are VERY well versed with collation, and some never ever have to touch the concept. That second group tends works in shops that leave everything on default. A huge portion of my career has been spent as a member of that “Custom collation? What custom collation?” crowd, and so I rarely get an […]

Bad Ideas: Alert Storming

Post author By Jen McCown
Post date March 10, 2014
Categories In Admin, sqlserverpedia-syndication, SSC, Tech and Learning, Tips

Fellow DBA: There are so many alerts! It takes me a long time to get through them all. How do you filter through them? Me: That’s called “alert storming”, and it’s bad for that exact reason. Alerts are like money: People always seem to have way too little, or way too much*. If you have […]

Expiration dates: SQL Server 2008 and 2008 R2

Post author By Jen McCown
Post date February 24, 2014
Categories In Admin, sqlserverpedia-syndication, SSC, Tech and Learning
1 Comment on Expiration dates: SQL Server 2008 and 2008 R2

SQL Server is a software product, right? And software has a history of having bugs, getting updates, and having support for when things go wrong. If you’re not already aware, now is a good time to become aware that: SQL Server has an expiration date Okay, officially it’s not an “expiration” date, but it might as […]