(Chris Webb) Some time ago I blogged about the deprecated and discontinued functionality in SSAS 2014, so I thought it would be a good idea to follow my last post on what’s new in SSAS 2016 Multidimensional with a discussion of what’s going or gone from it.

(Michael J. Swart) I recently learned that when combining multiple operators in a SQL expression, AND has a higher precedence than OR but & has the same precedence as |. I expected the precedence rules for the logical operators to be consistent with the bitwise operators.

(Derik Hammer) On many occasions I have found myself installing SQL Server and/or its development tools for a non-DBA power user. It always frustrated me to do this because I feel that SQL Server is for advanced users and I would expect advanced users to be able to install software for themselves.

(Nakul Vachhrajani) When we were working on a particular SSIS package that was extracting data from a legacy SQL Server database. We kept running into meta-data and datatype mismatch issues on a couple of databases.

(Kenneth Fisher) Fair warning, this is a discussion piece. I had a task, I went through several possibilities and I’m going to share each of them and the results of those I tried. I will not be giving any specific examples or code. Feel free to give me your opinion in the comments below.

(Pinal Dave) The title of the blog is little weird, but it was a question asked to me by a developer. Have you ever got such error messages which are strange yet difficult to comprehend?

(Chris Webb) With the recent release of SQL Server 2016 some of you old faithful SSAS Multidimensional users out there might be wondering if it’s worth upgrading. There is an official page describing what’s new in Analysis Services 2016 here:

(Daniel Mellor) In continuation of the forced mirroring failover procedure I posted last week, this post describes the another level of pain you may encounter.

(Tim Smith) In the tip Queries To Debug SQL Server Replication Issues, I showed some queries to help debug replication. In the case of bi-directional merge replication, there are a few additional tables I look at as well, since merge replication has some pieces that differ from transactional and sna

(Kenneth Fisher) T-SQL Tuesday It’s Chris Yates (b/t) birthday! (I think he just tured 19.) And in honor of his birthday we are writing blog posts! Well, technically it’s T-SQL Tuesday again, but we can pretend we are writing for Chris’ birthday.