(Kenneth Fisher) It’s that time again. T-SQL Tuesday. The monthly blog party started by Adam Machanic (b/t) seven and a half years ago!! We have a host, who picks a topic (on the first Tuesday of the month) and then we all write about that topic over the next week and all post on the same day (the s

(Pinal Dave) Question: How to See Scripts Executing in sp_executesql?

(Chris Webb) Recently I’ve been building a lot of Power BI reports from csv and Excel files, and to make sure that scheduled refresh works I have been setting up data sources in an On Premises Data Gateway (what used to be called the Enterprise Gateway).

(Arvind Shyamsundar) SQL Server 2017 is one more step further in Microsoft’s philosophy of bringing advanced analytics capabilities closer to where the data resides. With Python now supported as an ‘external script’ language (adding to the existing support for R), customers have the full power of Py

(Melissa Coates) This is a quick tip about syntax for handling row headers in U-SQL, the data processing language of Azure Data Lake Analytics. There are two components: handling row headers on the source data which is being queried, and row headers on the dataset being generated by ADLA.

(Kenneth Fisher) If you didn’t see it last month I’ve started doing monthly SQL Homework. The first month was backups, this month it’s tables.

(Pinal Dave) Sometimes many DBAs are so expert in many areas like performance tuning or backup/restore, they miss simple stuff. One of my DBA friends was running Standard Edition of SQL Server 2016 in production and want to upgrade the edition to Enterprise – core based edition. Let us learn about E

(Arun Sirpal) We all want high performing applications and when you are in the cloud that is no different, if anything it is even more important. With this post I will discuss some areas where I have been “stung” by so you can learn from my mistakes when using Azure SQL Database. Then I will dedicat

(Yanan Cai) In this blog, you will learn how to create U-SQL EXTRACT script automatically using the latest version of Azure Data Lake Tools for Visual Studio.

(Manvendra Singh) SQL Server Agent support is included with the release of SQL Server vNext CTP 1.4 to enable DBAs and users to schedule any task using a SQL Server Agent Job on Linux. In this tip, I will explain how to create and run SQL Server Agent Jobs using T-SQL commands on a Linux based SQL S