I'm generally a system table king of guy, but for mirroring all I have ever used were sys.databases and sys.database_mirroring. For SQL 2012 AlwaysOn it's a completely different story.

Great answer!

or use convert() with style 103

select convert(date, '14/02/2014', 103)

Are you considering installing SSIS on one server and SQL Server engine on another? First point to consider is that this will require a separate SQL Server license in...

One con of using AG for HA: HADR_SYNC_COMMIT waits. We cannot rebuild AG indexes in sync mode, have to switch to async, else blocking is intolerable. FCI achieves...

We've been using config like this for a few years. Besides the the primary we have one sync nonreadable replica for HA, one async readable replica for reporting and...

Confirmed. I was wrong to assume error would get thrown, sorry about that.

I think problem specifically comes from attempt to read definition column from sys.default_constraints. No error is...

My first thought was maybe this was SSMS bug and nobody could do this. But just verified that I (a sysadmin) can script out definition of such a table...

I realize I submitted this right before a long holiday weekend, but still surprised at zero replies. I guess either few people are using AGs, or they're all using...

Nice article! We've been doing similar problem solving for years, works fine. 2 things:

- instead of using SSMS to find xact_seqno vlues, we get them by querying distribution.dbo.MSrepl_errors

-...

I do not know of such a tool. But one of my coworkers years ago developed something similar years ago, based on Linchi Shea book regarding using Perl to...

Thanks for posting this. One thing that bothers me though. Microsoft's answer sort of pooh-poohs this whole problem, treats it as though we are merely upset by presence...

Leo Miller, I like your work-around. Due to lots of identity cols, have adapted it into a single sp_xxx system stored procedure that reseeds all the identity columns in...

Nice article, very interesting.

I'm mostly same as you, Andy. Have had a 9" tablet notebook for years, have tried various electronic entry forms, including typing & ink. OneNote seemed to work...