A community of more than 1,600,000 database professionals and growing

The Voice of the DBA

No More Downtime

At one point in my career, I worked for a wealth management firm. We managed funds for various customers, a part of which was making trades in the financial markets. Various brokers and companies used our platform to run their business, and performance was always an issue. At the time we were an NT 4.0/SQL Server 6.5 shop, though we moved to Windows 2000 and SQL Server 2000 while I was there.

While we were looking at upgrades, a number of potential customers asked why we weren't using AIX or Solaris or Linux. Management would come to a few of us technical leads to ask, and we usually had to provide some justification. Our success was hit and miss, though we did run into a few companies that were doing real time trading on the Windows platform, and a few of us had the chance to talk to them about how they managed their systems in an age when Windows hosts often needed patching, a requirement of which was rebooting. If you're interested, the company actually had a fairly server oriented architecture built on top of Windows, essentially managing work by just connecting to whichever boxes were running.

Things have changed. These days Microsoft has been working hard to build a better Windows OS to power Azure and they've done some amazing work. I saw a post on one of the things they're doing, which is finding ways to patch the underlying OS without disturbing applications, including VMs that are running on the host OS.

The work is amazing to me, and this is where we should have been going with all operating systems. We ought to be able to patch these without downtime, and certainly without disturbing guests or programs that might be running. As this rolls out to Windows hosts in our data centers, I could imagine an era when we have monthly patches for Windows that never cause downtime for SQL Server.

Well, I guess there is some downtime. Applications such as the hypervisor are paused, which some of us might consider downtime. However, if the time frame were in the single digits of seconds, I'm not sure many clients would this as downtime. It's along the lines of a network hiccup or a momentarily busy server. In some sense, this would be a great move forward for HA.

On the other hand, this would raise expectation. Clients and customers would be less tolerant of downtime, which is something we can't control with Windows and SQL Server patches. However, it is something we can control with our deployments. A system that is almost never down because of patches would put pressure on us to ensure that our enhancements to the database itself also didn't cause downtime.

While there's no magic in how we make changes to objects in SQL Server, there are techniques that can make changes in stages, perform additive work, and use automation in a DevOps style workflow to limit downtime and lower the risk of making changes. To me, this might be a bigger change than cloud systems. With that in mind, I'd urge many of you to learn techniques to avoid interrupting applications when you deploy changes. There are ways to do this, but it takes some effort and practice to build better skills and habits.

Steve Jones from SQLServerCentral.com

Join the debate, and respond to today's editorial on the forums

The Voice of the DBA Podcast

Listen to the MP3 Audio ( 4.8MB) podcast or subscribe to the feed at iTunes and Libsyn.

The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music.

Become a more efficient SQL developer with SQL Prompt

Learn how to write SQL faster and more efficiently with these exclusive short videos from Data Platform MVPs and SQL Server experts. With SQL Prompt you can strip out the repetition of coding and write SQL 50% faster. Check out the tips

Continuous Delivery for SQL Server Databases

Spend less time managing deployment pain and more time adding value. Find out how with database DevOps

Featured Contents

TRY_CONVERT

Matthew McGiffen from SQLServerCentral.com

An introduction to the TRY_CONVERT function, introduced in SQL Server 2012. More »

Tables Without Clustered Indexes

Additional Articles from Database Journal

When databases are being designed and developed, your developers might have overlooked creating clustered indexes on some of your database tables. Having a useful clustered index on your tables will improve the performance of your queries. Here Greg Larsen shows a simple script to identify those tables in your database that don’t have a clustered index. More »

From the SQLServerCentral Blogs - Power BI with Maps: Choose Your Destination

Rayis Imayev from SQLServerCentral Blogs

(2018-May-20) A childhood dream to travel around the world fueled by reading Gulliver's Travels stories and Robinson Crusoe attempts to survive on a... More »

From the SQLServerCentral Blogs - Power BI Custom Visuals Class (Module 104 – User List by CloudScope)

Devin Knight from SQLServerCentral Blogs

In this module you will learn how to use the User List by CloudScope. The User List by CloudScope is... More »

Question of the Day

Today's Question (by Steve Jones):

What are the Sources for the Data Migration Assistant?

Think you know the answer? Click here, and find out if you are right.

We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: Data Migration Assistant.

We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center.

The Phoenix Project: A Novel about IT, DevOps, and Helping Your Business Win

The company's new IT initiative, code named Phoenix Project, is critical to the future of Parts Unlimited, but the project is massively over budget and very late. The CEO wants Bill to report directly to him and fix the mess in ninety days or else Bill's entire department will be outsourced. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

What migration sources can I use with the SQL Server Migration Assistant?

Answer: Access, DB2, MySQL, Oracle, and SAP ASE

Explanation:

The SQL Server Migration Assistant allows for these sources:

Access

DB2

MySQL

Oracle

SAP ASE

Ref: SQL Server Migration Assistant - click here

» Discuss this question and answer on the forums

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.

SQL Server 2017 : SQL Server 2017 - Development

Help with an Update Query - I use the query below to identify any records that have a match between the table and view. The query...

If today is Monday show Friday to Sunday - Hi Guys, I am using the below to show data relating to yesterdays date, It works great but on a Monday...

SQL Server 2016 : SQL Server 2016 - Administration

???????,???????USYD???Q/?501479313???????USYD???????????USYD???????????USYD????????????????USYD?????? - QQ??:501479313???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? 1. ???????????? 2. ??????????? 3. ???????? 4. ????????????????????????????????? 5. ??????

???????,?????????ANU???Q/?501479313?????????ANU?????????????ANU?????????????ANU??????????????????ANU?????? - QQ??:501479313???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? 1. ???????????? 2. ??????????? 3. ???????? 4. ????????????????????????????????? 5. ??????

???????,????????UC???Q/?501479313????????UC???.?????????UC????.????????UC?????????????????UC?????? - QQ??:501479313???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? 1. ???????????? 2. ??????????? 3. ???????? 4. ????????????????????????????????? 5. ??????

???????,??·????????GWU???Q/?501479313??·????????GWU?????·?????????GWU??????·????????GWU?????·?????????GWU???? - QQ??:501479313???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? 1. ???????????? 2. ??????????? 3. ???????? 4. ????????????????????????????????? 5. ??????

???????,?????????PPD???Q/?501479313?????????PPD?????????????PPD?????????????PPD?????????????PPD???? - QQ??:501479313???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? 1. ???????????? 2. ??????????? 3. ???????? 4. ????????????????????????????????? 5. ??????

????????,???????????UBC???Q/?501479313???????????UBC???????????????UBC???????????????UBC?????????????????????UBC???? - QQ??:501479313???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? 1. ???????????? 2. ??????????? 3. ???????? 4. ????????????????????????????????? 5. ??????

????????,????????UTSG???Q/?501479313????????UTSG????????????UTSG????????????UTSG??????????????????UTSG???? - QQ??:501479313???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? 1. ???????????? 2. ??????????? 3. ???????? 4. ????????????????????????????????? 5. ??????

???????,?????????Q/?501479313 ??????????????????????????????????????????? - QQ??:501479313???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? 1. ???????????? 2. ??????????? 3. ???????? 4. ????????????????????????????????? 5. ??????

???????,????????????UMD???Q/?501479313????????????UMD????????????????UMD????????????????UMD+?????????????UMD???? - QQ??:501479313???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? 1. ???????????? 2. ??????????? 3. ????????

???????,??????????UTAS???Q/?501479313??????????UTAS??????????????UTAS??????????????UTAS???????????????????UTAS?????? - QQ??:501479313???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? 1. ???????????? 2. ??????????? 3. ???????? 4. ????????????????????????????????? 5. ??????

SQL Server 2016 : SQL Server 2016 - Development and T-SQL

insert into: ignore identity column's value - Hi, is there any Chance to get this working? CREATE TABLE .( IDENTITY(1,1) NOT NULL, (10) NULL, ) Now insert something with...

YTD running balance including missing months - Hi All, I am trying to get the YTD Account Balances for a financial statement. There are accounts which does not...

SQL Server 2014 : Development - SQL Server 2014

ROWS_PER_BATCH - How does it work in SQL OPENROWSET - Hi, I am using SQL Openrowset to read the file and load the data into a table. The file contains about...

SQL Server 2008 : SQL Server 2008 - General

Read-only schema allows write - Once again, I thought I understood permissions, and once again, turns out I don't know jack. I have a view on...

Query - Hi I have below Data .

SQLServerCentral.com : SQLServerCentral.com Website Issues

A user you are following, "...", has posted new content: but I'm not following this user - Today I received an email A user you are following, "...", has posted new content:but I'm not following this user "Thom A", has...

Career : Certification

Exam 70-767: Implementing a Data Warehouse using SQL - Hi there, I was wondering if anyone has taken this exam recently (part of the MCSA: SQL 2016 BI Development path)?...

This email has been sent to newsletter@newslettercollector.com. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com.

This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.