(Pinal Dave) In my earlier post on SQL SERVER – Delete Duplicate Rows, I showed you a method of removing duplicate rows with the help of ROW_NUMBER() function and COMMON TABLE EXPRESSION

(Jack Vamvas) Question: How do I create a graph table in SQL Server 2017?

(blobeater) Okay it is not really called Giant Azure SQL Database but its close. There is a new public preview vCore service tier called Hyperscale.

(Rajendra Gupta) SQL Server Reporting Services (SSRS) is used to deliver reports by representing data visually with graphs, charts, and create subscriptions to send reports through different methods.

(Kenneth Fisher) Did you know you can’t do this?

(Grant Fritchey) One complaint I’ve received frequently is that you can’t see stored procedure parameter values in Extended Events. That is patently not true. However, it does depend on where and how you capture the events and which stored procedure parameter values you’re going for.

(Tim Radney) If you are running SQL Server 2008 or SQL Server 2008 R2, what does July 9th, 2019 mean for you? With both of these versions of SQL Server reaching the end of their support lifecycle together, you will no longer be able to get critical security updates. This can cause serious security a

(blobeater) It is always a good idea to test your failover processes when you have setup failover groups in Azure.

(James Serra) As I first mentioned in my blog Microsoft database migration tools, the Azure Database Migration Service (DMS) is a PaaS solution that makes it easy to migrate from on-prem/RDS to Azure and one database type to another. I’ll give a brief overview of some of the key features:

(Chris Webb) I was super-excited when, a few days ago, the long-awaited integration of Power Query into Microsoft Flow was announced.