Monday, April 24, 2017

How to shut down SQL Server

›
The question how to shutdown SQL Server came up at work last week, I figured it would be a nice topic for the newer DBAs and SQL Server prog...
Saturday, April 15, 2017

Security in SQL Server on Linux Microsoft Engineering Town Hall

›
On April 20, 2017 10:00-11:00 AM Pacific Time (UTC-7) Microsoft will host a Security in SQL Server on Linux Microsoft Engineering Town Ha...
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...