The Bit Bucket

SQL Down Under podcast Show 67–Kasper DeJonge and SQL Server 2016 Analysis Services

Last week I had an opportunity to record a new podcast with Kasper DeJonge from the SQL Server Analysis Services team. Kasper has also been working on Power Pivot and many other areas.

SQL Server 2016 is lining up to be a great release for Analysis Services with significant enhancements for both tabular and multi-dimensional data models.

I hope you enjoy the show. You’ll find it here:

https://podcast.sqldownunder.com

2016-04-09

Very pleased to see free developer edition of SQL Server

I spend a lot of my time working with ISVs (or software houses) and with individual developers. For SQL Server to have a long-term future, we need to be appealing to more and more new developers, to get them to understand that SQL Server is a great platform for building their applications above.

One of the most important aspects of this right up front, is making it really frictionless to get started with SQL Server.

2016-04-04

R Tools for Visual Studio

In recent months, I’ve been brushing up my R skills. I’ve had a few areas of interest in this:

* R in Azure Machine Learning

* R in relation to Power BI and general analytics

* R embedded (somewhat) in SQL Server 2016

As a client tool, I’ve been using RStudio. It’s been good and very simple but it’s a completely separate environment. So I was excited when I saw there was to be a preview of new R tooling for Visual Studio.

2016-03-10

BETWEEN vs >= and <=

I love it when I get queries that are actually easy to answer.

Today, one of my developer friends asked me if it was better to use BETWEEN or to use >= and <= when filtering for a range of dates.

From a logic perspective, I like the idea that a single predicate expresses your intent rather than needing two predicates to do the same. For example, consider the following two queries:

2016-03-02

My Sessions from Ignite Australia on the Gold Coast now online

Hi Folks,

Couldn’t make it to Ignite? The team from Microsoft Australia recorded all the sessions and they are online now.

Here are the three sessions that I delivered:

Azure Datacamp Power Hour:  NOTE: This event is now closed

Things I Wish Developers Knew About SQL Server: NOTE: This event is now closed

Working With SQL Server Spatial: NOTE: This event is now closed

Enjoy!

2015-12-11

AzureCon is this month–register now!

AzureCon is the main #Azure related conference each year, and of course, it’s an online conference.

It’s coming up at the end of this month (September).

It’s time to register to see what ScottGu and the people from the Azure team have to tell us.

NOTE: This event is now closed

2015-09-10