(Tim Smith) We’re planning to archive some old data in some of our SQL Server databases and wanted to know what we should consider before building a design to accomplish this.

(Tim Smith) We’re planning to archive some old data in some of our SQL Server databases and wanted to know what we should consider before building a design to accomplish this.

(Pinal Dave) Another email from one of my blog reader, which made me think about the incorrect information which is available on the internet.

(Pinal Dave) Another email from one of my blog reader, which made me think about the incorrect information which is available on the internet.

(Rob) Continuing my series on using Power Bi with my DBA Database I am going to show in this post how I create the most useful daily report for DBAs – The SQL Agent Job report.

(Chris Webb) There’s a new M function in the latest release of Power BI Desktop that I spotted: Tables.GetRelationships(). Here’s the help page for it:

(Jovan Popovic) In this article I will show you similarities and differences between SQl Server JSON and DocumentDB query syntax.

(Rajendra Gupta) Once Database Mirroring has been configured and put in place, one of the things you need to do is to monitor the mirroring status to make sure things are working as planned. In this tip we will create a process to generate a report, so you can see the status.

(Rob) Continuing my series on using Power Bi with my DBA Database I am going to show in this post how I create the most useful daily report for DBAs – The SQL Agent Job report.

(Chris Webb) There’s a new M function in the latest release of Power BI Desktop that I spotted: Tables.GetRelationships(). Here’s the help page for it: