Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
Redgate SQL Provision
The Voice of the DBA
 

Are Windows Containers a Good Choice?

I like containers. I think they're the future of the SQL Server data platform. I also think this is likely on Linux, with Linux versions of SQL Server. You might disagree, and that's fine, but that is where I see this moving over time.

Why? I ran across a great post from Joey D'Antoni of DCAC that outlines one reason: Kubernetes. This is the way we will start to orchestrate SQL Server instances in the future, whether disparate or scaled-out, and this is really Linux technology. If you go Linux, with Kubernetes and containers, you'll be able to easily move your systems as needed from your data center to developer machines (perhaps with SQL Provision from Redgate), to the Azure cloud, or over to the AWS cloud, a partner Kubernetes install, etc. It's flexible.

Windows Kubernetes will be less flexible. Inherently because less people use it, while more and more people are using, supporting and deploying Kubernetes on Linux.

This won't happen soon, as I think it's 5-10 years before a good majority of SQL Server moves to 2019+ and containers become more mainstream for app and data work, but this shift is starting.

This also doesn't mean Windows goes away. I really like Windows. I'm comfortable with it, and I plan on having a Windows laptop for the forseeable future. What's more, I can run Linux containers on Windows, thanks to the WSL. Even Microsoft sees containers with Linux as a future on Windows.

Like Joey, I don't want to dismiss or denigrate any work for Windows containers. I think it's a good idea, and certainly some people will want to run their Windows apps in Windows containers. I just don't think it's the future for the data platform.

Steve Jones - SSC Editor

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

Redgate SQL Provision
 
 Featured Contents

SQL-On-Hadoop: Hive - Part I

Frank Banin from SQLServerCentral.com

Running Interactive and Batch SQL Queries on Hadoop and other distributed clusters using SQL.

SQL Server Clustered Tables vs Heap Tables

Additional Articles from MSSQLTips.com

One very important design aspect when creating a new table is the decision to create or not create a clustered index. We will take a look at a few points to help with the decision.

Running Linux SQL Server as a Container

Additional Articles from Redgate

Phil Factor starts a series of articles that will demonstrate the use of temporary SQL Server instances, running in Linux containers, into which we can deploy the latest database build, stocked with data, for development and testing work. This initial article shows how to set up a SQL Server instance inside a Linux Docker container, create some sample databases, and persist data locally.

From the SQL Server Central Blogs - Interview with Grant Fritchey

damian.widera from Coding Family

This is the fourth interview we have done. This time our guest is Grant Fritchey! Probably you do not know that but Grant has started his career in …...

From the SQL Server Central Blogs - Behind the Scenes: How I Create Weekly Technical Videos

Bert Wagner from Bert Wagner

Be sure to watch this week’s video to get the full behind the scenes experience! Today I want to share my process for blogging and making weekly YouTube videos....

 

 Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

Intersection

If I have two sets and want an intersection of their members, which join do I choose?

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

 

 

 Yesterday's Question of the Day (by Steve Jones - SSC Editor)

Altering a Filegroup

I have a very large SQL Server 2017 database and I am very busy. I start a backup of my 1TB database that I know will take at least 15 minutes to run. While this is running, I want to perform some maintenance and add another file to my OLTP filegroup. What happens when I run the ALTER DATABASE command to add a new file?

 

Answer: The file is not added and an error is returned

Explanation: You cannot alter a database with file operations while a backup is in progress. Ref:  

 

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 - Administration
which linux - I would like to try to install SQL server and PostgreSQl on a linux system. It is a test environment This is just for explore and learn linux and how to work with database. What linux system do you recommend, Redhat or ubuntu?   Thanks
SQL Server Training - Can anyone recommend the best place to get the SQL training when the company is willing to pay for it?
Store Procedure... - Hi Is there anyone who can help me explaining, in real job field, in what kind of scenario I would need to use output parameters in my store procedures. And also I would like to know how data gets into tables, do we manually entered it or its gets inserted via back end file? Thank […]
Is DBA responsible for ETL operations and cube creation in DW design project? - If a company wants to build a DW from sketch, is DBA responsible for schema design, ETL extraction and transformation process, loading physical data from different sources into a DW database? Or DBA is responsible only for physical design, and tools like SSIS or SSAS should be used by developers.   Thanks
SQL Server 2016 - Development and T-SQL
Change data capture - is it possible Updates getting applied out of sequence - I am using the CDC objects in SSIS to do replication between two servers I have a large table that does not have a Primary key so must be set to all. Occasionally when I do validation between the two, the record count is correct but values don't add up. I am doing a simple […]
Changing @ExecutionTime parameter value in SSRS subscription - Hi Everyone,   Can you please guide me how to change @ExecutionTime parameter value in SSRS standard subscription and version is 2012? Thanks Kanagarajan S
How to disable Upload options to end user in SQL SERVER REPORT Services 2016 v? - Hi Every one,   Could you please help me to achieve this requirement? I am having a requirement like need to disable the upload RDL or IMAGE option to end user also, restrict to view hidden data sources list in reporting manager.   Thanks Kanagarajan s.            
How to do Count of values on mutiple columns - I have the folllowing data in a table If OBJECT_ID(N'tempdb..#OutputTable', N'U') IS NOT NULL DROP TABLE #OutputTable CREATE TABLE [#OutputTable]( [MainHoldingID] [int] NULL, [OfferingElementID] [int] NULL ) ON [PRIMARY] GO INSERT [#OutputTable] ([MainHoldingID], [OfferingElementID]) VALUES (1133535784, 58413) GO INSERT [#OutputTable] ([MainHoldingID], [OfferingElementID]) VALUES (1133535784, 58413) GO INSERT [#OutputTable] ([MainHoldingID], [OfferingElementID]) VALUES (1133535784, 58413) GO INSERT […]
Administration - SQL Server 2014
error upgrade ssis - Hello everyone I proceed to update my ssis package from SQL server 2008R2 to 2016 during the upgrade wizard phase I got this message   thank you for your help    
SQL Server 2012 - T-SQL
In a t-sql 2012, I can trying to make a case statement work in an update statem - In a t-sql 2012, I can trying to make a case statement work in an update statement and I am getting the error ' Msg 207, Level 16, State 1, Line 5 Invalid column name 'TOT_ABSENCES'. from the following sql: UPDATE Milestone set TOT_ABSENCES = case when (details.TOT_ABSENCES is not null) or isnumeric(details.TOT_ABSENCES) = 0 […]
SQL Server 2008 - General
identify stored proc calls with missing input parameters - I'm checking to see if anyone has already written a stored procedure that can be run to identify any and all stored procedure calls from within a trigger or other stored procedure that are missing some of their input parameters. For example, if I have a procedure named SP_MyProc and three input parameters whenever I […]
Free Webinar: SQL Server 2008 has gone out of extended support - Hi All I thought I would post, I'm not sure its the correct place, but thought I'd let you know that I'm putting on a free webinar on 31st July - midday UK time. With SQL Server 2008 and SQL Server 2008 R2 going out of extended support with Microsoft last week, the webinar will […]
Error: Database is already open and can only have one user at a time - Any idea how to resolve this error? seemingly a nightly process loads data into my joebloggs_DB database, its then copied from jobbloggs_DB database to LIVE DB. Issue is sometimes the process fails with the following error: Error: Database 'JoeBloggs' is already open and can only have one user at a time. It looks like the […]
Dynamic Pivot Query with three fields - Hi,   I am creating a dynamic pivot query to produce a simple monthly table showing clients on the left column, calendar dates across the top and simple text in the middle. Table are CREATE TABLE [dbo].[TblClientActivity]( [ID] [int] IDENTITY(1,1) NOT NULL, [ClientID] [int] NULL, [LocationID] [int] NULL, [ADate] [date] NULL, [Outcome] [nvarchar](10) NULL) Data […]
Integration Services
Upgrade file SSIS - Hello everyone I have two dtx file SSIS develloper EN SSDT 2008 AND I'm going to migrate it in SQL2014 If I import these files through SSDT 2013 the files are well imported then if I click on the button upgrade all package i have this message At least one package has to be selected […]
 

 

RSS FeedTwitter

This email has been sent to {email}. 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.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -