After struggling with a Failover Cluster combined with using Always On availability and having lots of problems, I would advise everyone to avoid using this as an architectural design. ...

Mental Gymnastics is a polite way to say that! But yeah, there is almost nothing I cannot do without some thinking and time...and NEVER make a DAX formula so...

You can script out a date table in Power Query but you have to know the M language...I am not thrilled about learning it so I tend to stay in...

In this case I typically use the Azure data marketplace and wire up to the Date Data source (free) and have a really detailed date table. I just see...

Thanks for the detailed article, however I would like to ask how all this work saves any time for a BI Developer as opposed to simply adding a role playing...

Thanks, yes I have deployed an AlwaysOn Availability group and these instruction are straight forward...what I am lacking is a guide to combine Fail-over Clustering with AlwaysOn Availability. I...

Thanks fro this article, but you don't actually say HOW to do this...I want to setup an AO group for an existing failover cluster and it isn't clear which wizard...

If you want to stop this database from growing, then you might want to consider turning off the search index feature. I assume that you either set this up...

I have been thoroughly frustrated using the maintenance plans in 2005...they were so much easier in 2000. Nothing seems to work right and I am constantly chasing down errors and...

Thanks, really wished Microsoft posted this on their site...why must we do all the work?!?!?!?  I guess they want to keep us employed

Has...