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...
Friday, December 16, 2016

Interesting SQL related links for the week of Dec 16, 2016

›
Here are some interesting articles I read and tweeted about this past week, I think you will like these as well. If you are bored this week...
Friday, December 09, 2016

Connecting to SQL Server when your default database is not available

›
One of our database on the development went in suspect mode today. This database was the default for a bunch of logins.  These people could...
1 comment:

Interesting SQL related links for the week of Dec 09, 2016

›
Here are some interesting articles I read and tweeted about this past week, I think you will like these as well. If you are bored this week...