Thursday, March 31, 2016

Microsoft releases SQL Server Horizontica, a Vertica killer

›
Amsterdam, Noord Holland, Nederlands, European Union. — April 1, 2016 — Microsoft Corp. on Friday morning announced that it has released...
3 comments:
Monday, March 28, 2016

The most interesting Build sessions for people working with data

›
Microsoft's  Build conference is happening this week, the schedule for all the sessions was just made available. Below are all the se...
Tuesday, March 08, 2016

How to get SQL Server on Linux?

›
In order to get SQL Server on Linux you need to go to the following page: https://www.microsoft.com/en-us/server-cloud/sql-server-on-linu...
Monday, March 07, 2016

SQL Server 2016 Release Candidate 0 now available for download

›
The SQL Server engineering team just announced the availability of SQL Server 2016 Release Candidate 0. To learn more about the releas...
Friday, March 04, 2016

Gotcha with the LEAD analytical function and date datatype

›
The other day some code that used the LEAD analytical function stopped working suddenly. It started to throw an error. Msg 206, Level 1...
Thursday, March 03, 2016

Did you know I have a github repository for stuff I run over and over?

›
There are queries or commands that I run every now and then. I typically don’t have these stored on my computer; to find this code I usu...
Wednesday, March 02, 2016

Easy running totals with windowing functions

›
Back in the pre SQL Server 2012 days, if you wanted to do a running count, you either had to run a subquery or you could use a variable. Thi...
Monday, February 29, 2016

#BackToBasics returning rows with maximum values from a table

›
In the  A challenge for 2016....... accepted! post I said that I would write a post once every month that would explain very basic stuf...
Sunday, February 21, 2016

How to store twitter search results from R into SQL Server

›
I was messing around with R and grabbing twitter searches from within R, after that I decided to store the result in a csv file. Instead of ...