As people look to incorporate R code into their SQL Server environment there are a lot of questions surrounding how it works.  As R is very memory intensive, is it possible that people running R code will prevent other processes from running? W...

It’s not often that a service pack release for Microsoft SQL Server deserves as much attention – let alone a keynote announcement – as the first service pack for SQL Server 2016 does. Most service packs don’t unlock key...

Azure Data Factory, Azure Machine Learning, SSIS in Azure VMs and 3rd party ETL tools from the Azure Marketplace Gallery all offer good options to move your ETL from on-prem into the Cloud with Azure.

This month I conclude the series by describing the last steps in logical query processing, which handle the SELECT and ORDER BY clauses, and the TOP and OFFSET-FETCH filters.

The Issue Recently I had someone reach out to me concerned they were about to incur an auto-grow event on a volume where they're already running low on space. They only had megabytes of space remaining on a 5 terabyte-sized data file.  This ...

Kelly Lockwood Primus, SVP, Strategic Client Solutions at Leading Women, was the keynote speaker at the annual PASS Women in Technology Luncheon that took place at the recent PASS Summit. Her talk was titled Leadership, The Missing 33%TM and...

Introduction There are not any individuals - no matter how dedicated an employee or proficient technically - that can work 24 hours per day every day of the year and every year after that year yet that is what is asked of Database Administra...

PASS Summit kicked off general sessions today after two days of full day pre-conference sessions. The day one keynote anchored by Joseph Sirosh, Corporate Vice President, Data Group at Microsoft, focused on aspects of Microsoft's data platform...

The democratization of analytics means more opportunities in the SQL world