SQL Server 2016 Bug in R Integration?

 
I am studying the latest R integration with SQL Server 2016, and I believe I encounter a bug when using...

SQL Server Community Events

By David Postlethwaite

I have just come back from a successful SQL Saturday in Vienna, Austria where I had 60 people...

Career Corner: Go Beyond Networking

Networking with others is good for your career. You should do it. Don’t stop there. Keep going.
Networking builds contacts and...

Compare column names for case sensitivity

I’m reviewing the code for the upcoming Minion CheckDB, and one of the things we’re checking for is case consistency in...

DATEDIFF vs. DATEADD

Let’s talk about the DATEDIFF vs. DATEADD functions in SQL Server. Each one performs a different task. The former calculates...

Interactive query experience for SQL databases

This is a new feature where you can issue TSQL commands via a TSQL editor straight from the Azure portal,...

Querying My Named Instance in PoSh–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

Running SSMS 2016 in Read Uncommitted Mode

Back in July when we received the first official release of SSMS not tied to an engine release we got a new SQL PowerShell module and we also received...

Running SSMS 2016 in Read Uncommitted Mode

Back in July when we received the first official release of SSMS not tied to an engine release we got a new SQL PowerShell module and we also received...

Scheduling Statistics Maintenance in Azure SQL Data Warehouse

The power and capabilities of Azure SQL Data Warehouse are pretty amazing. However, it’s still basically SQL Server under the...