(Brien Posey) Integrating data into Power BI for analysis can be a challenge, but Microsoft’s Common Data Service for Analytics technology is designed to simplify the process for users.

(Sandy Winarko) As we continue our march towards General Availability (GA) of SQL Server Integration Services (SSIS) in Azure Data Factory (ADF), we are excited to announce the release of Execute SSIS Package activity as the most direct and code-free method to invoke SSIS package executions within A

(Ahmad Yaseen) I know SQL Server can run queries in parallel, but how can I tell that a query uses a parallel execution plan and how can I get information about the number of CPUs used when a query executes in parallel? Check out this tip to learn how.

(Bert Scalzo) Every DBA has at some point asked: “What the heck happened to my database?” In this blog, we’ll review some of the more common scenarios where some little detail slips through the proverbial crack and that often results in some kind of database anomaly which momentarily raises tensions

(Thomas LaRock) SQL Server 2017 allows for the use of Python scripts called as an external script. SQL Server comes with some Python packages by default. Today I wanted to talk about adding Python packages to SQL Server 2017.

(Anoop Kumar) Adaptive query processing is the latest, improved query processing feature introduced in the SQL Server database engine. This method is available in SQL Server (starting with SQL Server 2017 (14.x)) and Azure SQL Database.

(Pinal Dave) Yesterday I blogged about the very famous Powershell free community tool dbatools. After writing this blog post, I received some interesting emails. I think lots of people confused this with native PowerShell.

(Jack Vamvas) There’s a number of things to consider in deciding on Change Data Capture (CDC) and deciding on the ideal use cases for CDC is very much dependant on the specific requirements. So it is important to understand in detail the project requirements.

(Prashant Pratap) This blogs talks about how to create a simple Durable Function App.

(Rajendra Gupta) In my previous tip, new interactive command line tool MSSQL-cli for SQL Server, we explored the installation of Python, MSSQL-cli and its important features such as auto-completion, syntax highlighting, auto escaping, join suggestions, etc.