(Pinal Dave) A few months ago, I wrote a blog which tells us reasons about why we should use tools provided with the product rather than generic tools. Yeah, I am talking about services.msc vs. SQL Server Configuration manager.

(Chris Webb) One of the most confusing, under-documented and widely-misunderstood features of Power BI and Power Query (or Excel “Get & Transform” or whatever you want to call it) are the data privacy settings.

(Edward Elliott) To achieve gains from Database Lifecycle Management in general, and in Continuous Deployment in particular, it pays to aim for lightweight but consistent techniques and processes, refining them iteratively in the light of experience.

(Cate Murray) In our Job Search Strategies webcast, a question arose around getting a remote job. This is certainly a hot topic, as more and more employees want increased flexibility on where, when and they do their work. The specific question was “What recommendations do you have when applying for

(NEERAJ Sharma) Group By uses in SQL Server with select query to view column(s) as a group, only one row return for each group specified and if we want, we can perform aggregate functions for each group.

(NEERAJ Sharma) This article lays the foundations for my upcoming series on which we will learn why the clustered index should be Static, Unique, ever increasing and narrow. To understand and compare we are first creating an ideal primary key (Clustered Index) remember by default SQL Server create

(benjamin perkins) I wrote this article “Making changes to the applicationHost.config on Azure App Service” here which explains the details about creating an XDT file that supports the configuration of some properties found in the applicationHost.config file.

(Pinal Dave) I must confess that consulting has taught me much more than what I have learned in my regular job. Freelancing comes with advantages and disadvantages. For me, I am looking at advantages and I am happy with my decision. Let us see how to fix an error related to Login Failed and Deleting

(Robert Sheldon) What does the R analytics language offer to users, and how does it fit into SQL Server 2016 and 2017? Get answers to those questions and details on Microsoft’s various R technologies.

(Dennes Torres) SQL Server 2017 brings several improvements to us. Sometimes a simple new field in a DMV can turn possible interesting new functionalities. That’s what happens with differential backup in SQL Server 2017.