Tag Archives: sql server

Faster Versions and More Support

When I started working with SQL Server, the versions came a strange paces. Three years between v4.2 and v6.0, but less than 1 before v6.5. Then two years to v7, one more to SQL Server 2000, but five until SQL … Continue reading

Posted in Editorial | Tagged , | Leave a comment

What Port Should I Use?–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is a quick post on checking the port for your SQL Server instance. It’s in line with Tim … Continue reading

Posted in Blog | Tagged , , | 2 Comments

A Python SQL Server App

I got a link recently from Microsoft on building apps easily for SQL Server. At the top of the page, they ask you to pick a language and OS. Since I’ve done a little Python and I used Windows, I … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

Finally, Create or Alter

There are lots of reasons to upgrade to SQL Server 2016, but this is the one for me. We finally get a CREATE OR ALTER statement in T-SQL. This not only makes lots of code easier to write, it means … Continue reading

Posted in Editorial | Tagged , | 2 Comments

Monitor All the Changes

Can you monitor every configuration change and setting on all your SQL Server instances? Can you get an alert every time code changes, or even if an option for an object changes, such as the changing of an EXECUTE AS … Continue reading

Posted in Editorial | Tagged , , | Leave a comment

A Joke Come True

Yesterday was the opening of Microsoft Connect 2016. If you didn’t have the chance to watch the opening keynote, I’d recommend you do so. Mostly because one of my jokes, or perhaps a dream, has come true. SQL Server runs … Continue reading

Posted in Editorial | Tagged | Leave a comment

A New Recovery Tool for Your Toolbelt

Those of us that administer databases and are responsible for ensuring the integrity and availability of data know that being able to restore systems is a core skill. In the SQL Server world, this should mean more than just being able to … Continue reading

Posted in Editorial | Tagged , , , | Leave a comment

What’s Your Backup Speed?

I ran across a thread recently where someone was looking to estimate the time it too to perform a 600GB backup. I’ve seen other threads with similar questions. The general advice is that you need to run a backup and … Continue reading

Posted in Editorial | Tagged , , | 1 Comment

The Forever Technology War

The Forever War is a classic science fiction novel. I’d highly recommend it if you enjoy that genre, but even if you aren’t a science fiction fan, this is a story that can really make you think. The gist of … Continue reading

Posted in Editorial | Tagged | 1 Comment

Where Do You Run Your R Scripts?

I know most of you don’t work with the R language. In fact, plenty of you might not know anything about R other than a cursory understand of this as some sort of data analysis language. If you want to … Continue reading

Posted in Editorial | Tagged , | 2 Comments