Tag Archives: sql server

SQL Server on Linux is Just SQL Server

I’ve been working with the SQL Server on Linux (SSoL) version for quite some time, almost a year. In all of that time, I’ve for the most part found that SQL Server is SQL Server. When I connect, run demos, … Continue reading

Posted in Editorial | Tagged , | 1 Comment

Python in SQL Server

The Microsoft Data Amp event was this week, with a number of SQL Server announcements. We now know this is going to be called SQL Server 2017, which is no surprise. CTP 2.0 was also released, which includes a few … Continue reading

Posted in Editorial | Tagged , | Leave a comment

SQL Server on Linux (Ubuntu)–Updating from Early CTP

I’ve been testing the SQL Server on Linux for a long time. After the recent Microsoft Data Amp event, I saw the announcement for CTP-2. So I did what I’ve been doing for some time on my Ubuntu machine: sudo … Continue reading

Posted in Blog | Tagged , , | Leave a comment

SQL Server Telemetry

One of the things that I’ve seen blogged about and noted in the news over the last year is the amount of data being collected by various software systems. In particular, I’ve seen numerous complaints and concerns over what data Microsoft … Continue reading

Posted in Editorial | Tagged | Leave a comment

T-SQL Tuesday #89–Changing Times

This month the invitation is from Koen Verbeeck and it has to do with the cloud changes coming to the data world, especially SQL Server. That’s an interesting topic, not necessarily technical, but it is an interesting one to think … Continue reading

Posted in Blog | Tagged , , | 1 Comment

Using Trace Flags

At SQLServerCentral, we recently published a list of all the trace flags from Konstantin Taranov. It’s a great list, and thanks to Konstantin for compiling it. While I haven’t often used trace flags, there are some that have really helped … Continue reading

Posted in Editorial | Tagged , | Leave a comment

Global v Session Trace Flags

I wrote a short article on enabling and disabling trace flags. You can read it, but I didn’t really discuss the implications of session v global trace flags, which is something I’d like to do here. In the article, I … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Create a DACPAC to Move Databases–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. In my last post, I talked about what a DACPAC was. Now let’s create one. This turns out to … Continue reading

Posted in Blog | Tagged , , | 1 Comment

The Migration Checklist

One of the things I always recommend is that when you upgrade a SQL Server instance, you perform a side by side migration to a new host instead of an in-place upgrade. My main concern is risk. While the upgrade … Continue reading

Posted in Editorial | Tagged , | 4 Comments

Containing the Work

Containment is becoming more prevalent in the computer world. We have containers coming to Windows Server 2016 (or earlier versions with WinDocks), a concept that’s been embraced in the Linux world for some time. If you haven’t looked at containers, … Continue reading

Posted in Editorial | Tagged , | Leave a comment