(Arshad Ali) Microsoft Power BI is a cloud based self-service BI solution for the enterprise. Power BI provides capabilities that can be leveraged by people with all level of skills including data analyst, power users, business users, data stewards and folks from the IT department.

(Michael Sorens) One of the downsides of learning a new computer language is that transfer of training doesn’t always work to your advantage. In fact, the habits you picked up in the past may now cause confusion.

(Pinal Dave) There is an interesting observation when querying the identity column of a table

(Chris Bell) We talked about whitelisting IPs before, but what about the opposite, blacklisting IPs that may never access your SQL Server.

(Kenneth Fisher) Recently we have been doing a number of instance moves as part of a large upgrade project. And as anyone who’s done many of these types of moves knows, orphans are a big pain.

(Ghanesh Prasad) I have a reporting requirement where users want to enter report parameters by either selecting values from a dropdown list or entering To and From range values. How can I do this in a Reporting Services report?

(Corlyn Voorhees) Last month, at the Microsoft Ignite 2015 conference, Microsoft CEO Satya Nadella announced a SQL Server 2016 public preview release for this summer, and attention centered on a host of new features — for example, one that lets SQL Server users “stretch” their databases into the cl

(Feodor Georgiev) It often pays to use a tool like R, in conjunction with a relational database, to quickly perform a range of analyses, and graphs, in order to ensure that you’re answering the right question, to explore alternative hypotheses, or to provide insight into a problem.

(Pinal Dave) I make a visit to the local user group whenever I get and keeping the community juices up and running for me. I get an opportunity to share some of the learnings and meet tons of new people.

(Prashant Shekhar) Our team wants to develop a Source Control process to apply SQL Server database code changes in various environments. As you can imagine the changes can relate to any of the following: creating new objects (tables, views, functions, stored procedures, etc.), altering objects, etc.