Grumpy DBA

After upgrading a server to SQL 2012 that is running as a publisher of a merge replication publication, you may see an error from the subscr...

As businesses slowly migrate from SQL 2008 R2 to SQL 2012 and SQL 2014, you'll probably find you have multiple copies of Management Stud...

Something I'd forgotten when I was setting up a new SQL server, was how the UAC (User Account Controls) permissions affect connections t...

Personally I don't always trust the SQL depencies report, so I compiled a basic proc that will search the current database for a specif...

Moving a table in SQL from one schema to another is actually very simple, but as it can't be done via Management Studio, remembering the...

Further to a previous post about reports being blank on Chrome ( Report doesn't show on Chrome ), I've recently come across a simila...

I know this information is available in multiple other places, but I can never find it when I need it, so I'm putting it here for my ben...

If you use Templates in SQL Management studio to store your own code snippets, or team code templates, you may be reluctant to upgrade your...

A situation where SQL is helpful, but not quite helpful enough, is when it reports that a user is unable to access a certain database. SQ...

If you want to check which reports are being run (or not) in SSRS, or details about which users are running reports, you can pull this info...