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 ...
Saturday, February 13, 2016

Quickly change m/d/yyyy dates to mm/dd/yyyy dates in Excel

›
Sometimes you get data in an Excel or csv file and it will be in a m/d/yyyy format. Here is an example 1/1/2005 2/1/2012 2/12/2012 1...
Monday, January 25, 2016

The one change I make to each tSQLt database

›
Whenever I put the tSQLt database on a server, I make sure that I make one change to a stored procedure that ships with tSQLt. The reason fo...
Monday, January 18, 2016

#BackToBasics: Returning all rows from one table that do not exists in another 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...
3 comments:
Sunday, January 03, 2016

A challenge for 2016....... accepted!

›
I was reading a challenge for 2016 post by Aaron Bertrand and in that post Aaron mentioned that Tim Ford challenged the SQL community to po...
Saturday, October 31, 2015

TempDB Database changes in SQL Server 2016

›
According to Books On Line, there are several changes made in SQL Server 2016 in regards to TempDB. Here is what Books On Line has on the to...
1 comment:
Thursday, October 29, 2015

SQL Server 2016 Community Technology Preview 3.0 is now available for download

›
Public service announcement!!!!! SQL Server 2016 Community Technology Preview 3.0 is now available for download. The download is 2.6 GB, y...

SQL Server 2016 Community Technology Preview 3.0 will be available this week

›
SQL Server 2016 Community Technology Preview 3.0 will be available this week. Some of the new and exciting stuff...... Advanced Analytic...