(Melissa Coates) In a recent Power BI post, I wrote about two ways to utilize Power BI: one being the “Report Only” and the other including the “Query, Model and Report” alternative. Since then I’ve done a Power BI POC for a new customer and seen a couple of twitter comments that inspired me to writ

(Jason Brimhall) So far, in this series, I have discussed the means to view the metadata associated with Extended Events. I also demonstrated some quick and simple means to retrieve some metadata via the catalog views and DMVs.

(Michael Sorens) It’s great to be able to monitor a counter or any other changing metric while engaged in development work. You’d think that the two alternatives would be using a third-party tool or hacking a PowerShell script. Well no, because there could be an existing open-source PowerShell modu

(Pinal Dave) When I get a chance to talk to Enterprise customers working with a really smart DBA team, I generally look out for options they use on a daily basis and are often missed in the bigger scheme of things.

(Robert Sheldon) Once hampered by limitations, in-memory OLTP will be more robust and complete in SQL Server 2016. Learn about the improvements.

(Manvendra Singh) In SQL Server there is a default Extended Events session named system_health to help with troubleshooting problems. This session records various important and critical events. Microsoft recommends that we should not stop or delete this session. Suppose this session was deleted by m

(Kenneth Fisher) I’ve you’ve run a query similar to the following:

(Greg Larsen) There is a lot of buzz around SQL Server 2016. Microsoft announced the release of SQL Server 2016 at the Microsoft Ignite Conference during the first week of May 2015. Since that time a number of Community Technical Previews (CTPs) have come out.

(Robert Sheldon) Once hampered by limitations, in-memory OLTP will be more robust and complete in SQL Server 2016. Learn about the improvements.

(Manvendra Singh) In SQL Server there is a default Extended Events session named system_health to help with troubleshooting problems. This session records various important and critical events. Microsoft recommends that we should not stop or delete this session. Suppose this session was deleted by m