(Rick Dobson) My organization maintains some critical business information in a database on an Oracle 11g server. However, we also have a community of report developers and business analysts who are familiar with generating charts and reports via SQL Server Reporting Services (SSRS) running with SQ

(Tim Chapman) In this blog post I am going to discuss a very little-known performance metric introduced in SQL Server 2012 that you can use to instantly get a baseline of the query performance for your system. The counters I’m referring to are under the Performance Monitor (perfmon) group SQLServer

(Arshad Ali) SQL Server 2016 introduces the Real-time Operational Analytics feature, which allows you to run both transactional/operational and analytics workloads on the same system – without having a need for another analytics system for reporting.

(Pinal Dave) Yesterday when I wrote about what I learnt from Vinod’s session at the SQL Server User Group meeting, one of my friends wrote back asking what else was discussed. Though I knew some of the tips and tricks he showed as part of the sessions, there were few that stuck in my mind.

(Chris Webb) There are a lot of cool new features in the September 2016 update for Power BI, so many in fact that several of the really important changes in the Query Editor are in danger of going unnoticed.

(Tim Smith) We have INSERT, UPDATE and DELETE scripts that we run in production and we’d like to create summaries of these scripts, telling us what the script contains, so that we can look at a report summary to reduce the overhead of looking through each script to identify which script may have cau

(Edward Elliott) As a developer, I need a SQL Server database against which I can develop and test code. There are several options to choose from, and various issues that you might need to bear in mind. In this article we will look at the choices, and the decisions you need to make.

(Rob Farley) I saw this tweet come through…

(Pinal Dave) I have an eye for details and I try to keep looking for something new to some of the tasks I have been doing for years together. This exploration and quest to learn new techniques is what has made me survive longer in this industry I suppose.

(Melissa Coates) We’re currently setting up Azure Automation as one component of an overall solution which uses PowerShell for managing members in an Office 365 unified group (per my recent post on the issue). I’ll post those details as soon as it’s completed and tested. In the meantime, this post i