Monday, February 20, 2017

The strange case of the missing indexes....

›
This past week I needed to run some queries on production to verify there were indexes added on a table. There were several scripts that n...

Importing The Metropolitan Museum of Art's Open Access Initiative data into SQL Server

›
The Met just made some data available for download. The Metropolitan Museum of Art presents over 5,000 years of art from around the worl...
Tuesday, January 17, 2017

Using bigint with FORMATMESSAGE

›
SQL Server 2016 added the FORMATMESSAGE function.  According to Books On Line, FORMATMESSAGE constructs a message from an existing message...
1 comment:
Monday, January 16, 2017

Creating the Wide World Importers sample database v1.0

›
Before SQL Server 2005, we had the northwind and pubs sample database, these actually shipped with the product. If you did a SQL Server 2...
2 comments:
Tuesday, January 10, 2017

T-SQL Tuesday #86: String or binary data would be truncated

›
This month's T-SQL Tuesday is hosted by Brent Ozar , he proposed the following Find the most interesting bug or enhancement request ...
Saturday, January 07, 2017

BULK INSERT and csv format, new in vNext 1.1

›
In SQL Server vNext 1.1 we now have the ability to import a csv via the BULK INSERT command without having to specify the field or row ter...
Sunday, January 01, 2017

Running queries against the songs you played with Alexa

›
My son got an Amazon Echo for Christmas. We use the Echo mostly to play music. I have setup IFTTT (If This Then That) to save the name o...
Thursday, December 29, 2016

The 15 most popular posts in 2016

›
Another year is almost over. As the last post of this year I decided to share with you the 15 most popular posts in 2016. I just used Googl...
Tuesday, December 27, 2016

Didn't go to PASS but want to watch the sessions?

›
You didn't go to the PASS summit this year, but you would still want to watch the sessions?  There is a way now, you can buy the USB ...
Saturday, December 17, 2016

SQL Server vNext version Community Technology Preview 1.1 available

›
A nice holiday present for you all has just arrived: SQL Server next version Community Technology Preview 1.1 Here is what is new in ter...