Thursday, May 19, 2016

Living in the NYC tri-state area? Attend the SQL 2016 Launch Event in NYC on June 2nd

›
Got this info from my co-worker Daryl earlier today. On June 2nd Microsoft will hold a SQL 2016 Launch Event in New York City. The Micr...
Wednesday, May 11, 2016

How to disable tests in tSQLt

›
The tSQLt unit test framework that we use to do our DB tests does not allow for disabled tests, this is because each test is just a stor...
Monday, May 02, 2016

SQL Server 2016 will be generally available on June 1, 2016

›
Mark your calendars, SQL Server will be generally available less than a month from now, June 1st 2016. You don't have a reason not ...
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 ...