(Denny Cherry) When building an AlwaysOn Availability Group that’s hosted on VMs in Azure you may have issues querying through the Availability Group name/IP address from on-prem.

(Kenneth Fisher) Compressing your backups has very few downsides. It’s usually faster (the additional time for compression is less than the time saved by reduced IO) and of course, the backups are smaller. I have run into a few issues, however.

(Andy Mallon) When you’re deploying any application, one of the first questions that comes up is “What will this cost?” Most of us have gone through this sort of exercise for sizing a SQL Server installation at some point, but what if you’re deploying to the cloud? With Azure IaaS deployments, not m

(Ranga Babu) We are using SQL Server Merge replication and we have a need to setup a one way publication. We needed Data Manipulation Language (DML) changes on the publisher to get replicated to one of the subscribers, but not from that subscriber to the publisher. In this tip we look at how this c

(Pinal Dave) In this blog post we are going to learn about PRINTing Status Using RAISERROR With NOWAIT Option.

(Michael J. Swart) I had the privilege of listening to Itzik Ben Gan talk about “distinctness” in a talk he gave at PASS Summit.

(Scott Murray) What is the Power BI Native Query and how is it used?

(Margaret Cruise O’Brien) Although the techniques of Database Lifecycle Management can reduce the timescales for the delivery of new functionality to business systems, what if the database ‘layer’ consists of several large interdependent databases and data flows with replication and audit? Does DLM

(Arshad Ali) Microsoft introduced Azure SQL Data Warehouse, a new enterprise-class, elastic petabyte-scale, data warehouse service that can scale according to organizational demands in just few minutes.

(Denny Cherry) Recently we moved a client from their aging on-prem environment into Azure. As part of this there was a lot of system upgrading being done to get everything onto current versions. Part of this included upgrading SSRS 2008 R2 to SSRS 2016.