| A community of more than 1,600,000 database professionals and growing |
| | | No More SQL Server Installs This occurred to me recently, and I'm wondering what some of you think of as the answer to this question: when will you expect to no longer install SQL Server? It's not that I think many of you are retiring from SQL Server work. It's not that your organization won't use SQL Server. It's that I wonder if we'll stop installing SQL Server on the host OS. We'll make use of SQL Server in new ways, which won't require an installation. Lately I've seen a lot of tweets, post, and more about SQL Server in containers or Kubernetes. Anthony Nocentino and Andrew Pruski are doing lots of work here, and I'm moving my work to containers for demos. With a container, you don't really install SQL Server. Instead you install the Docker engine and then "start" a pre-installed SQL Server image inside a container. You might modify this before starting it, but you aren't installing a version and upgrades are pulling a new image and then restarting the new image. With the better support for containers on Linux, this means I'm also starting to think Linux first. Plenty of you are also looking to do more work in Azure, AWS, or some other cloud service where you likewise don't need to install SQL Server. In those cases, you're really working with a service that implements a database, not an instance. There are some variations, such as the Azure Managed Instance, but you still don't need to install SQL Server. You apply your database code, point your application, and off you go. SQL Server 2019 is starting to feel like the first version where I'll be looking to ignore the SQL Server instance and think in terms of containers most of the time. I'll probably still install it, as I need to test and check things, plus, I'm still learning how to work containers into my workload, but I'm guessing that with SQL Server 2020, or 2021, I'll just stop installing SQL Server. Unless I need to document the installation for some of you, but in that case, I'll first try to get you to stop installing the binaries. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| | The Voice of the DBA Podcast Listen to the MP3 Audio ( 3.4MB) 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. |
|
|
|
| | ADVERTISEMENT | | | | How to track every change to your SQL Server database See who’s changing your database, alongside affected objects, date, time, and reason for the change with SQL Source Control. Get a full change history in your source control system. Learn more |
| | | | SQL Provision: Create, protect, & manage SQL Server database copies for compliant DevOps With SQL Provisions virtual cloning technology, databases can be created in seconds using just 1MB of storage, and sensitive data can be anonymized or replaced with realistic data to ensure it is protected as it moves between environments. Download your free trial |
|
|
|
| | | | | Press Release from Redgate In this blog, we review the key insights from last year’s State of SQL Server Monitoring report. One year on, how has this changed? Read the blog to find out how you can help us define the state of 2019 plus a chance to win a $250 Amazon voucher. More » |
| | Additional Articles from Database Journal Back to the basics: learn how to Create, Read, Update and Delete operations are pivotal for any database application. Plus, you’ll see how to use Stored Procedures to manipulate data on the database side instead of on the application side. More » |
| | Wayne Sheffield from SQLServerCentral Blogs I recently published a post detailing the new Scalar UDF Inlining feature in SQL 2019 here. That post introduced the... More » |
| | Anthony Nocentino from SQLServerCentral Blogs In Kubernetes we can leverage Controllers to help manage our application state, keeping them in the desired state. In this... More » |
|
|
| | | Today's Question (by Steve Jones): I have a SQL Server 2017 on Linux instance. The physical machine has 100GB of RAM. I want to set SQL Server to use 64GB of RAM. How do I do this? |
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: SQL Server on Linux. We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center. |
|
|
| Yesterday's Question of the Day |
| | |
| Database Pros Who Need Your Help |
| | Here's a few of the new posts today on the forums. To see more, visit the forums. PBM: script warning - Hello community, I want to use some policies on my sql servers. I have created them and everything works fine except... Use SQL Azure as read only reporting copy of SQL "on prem" VM? - We have some Azure IaaS (on prem) SQL database instances running. We would like to use an Azure SQL database (not... Query Help Please - I am still quite a beginner at this SQL querying, so I appreciate any help on this. I have pulled... Query to get all server properties - Does anyone have a good way of getting all of the server properties from SERVERPROPERTY()? I know you can write... SQL Server AlwaysOn on Single node cluster - Hi Team, We have some SQL Servers which are configured with Always on on Single node clusters. As part of the testing... PREEMPTIVE_OS_PIPEOPS Wait - So to start with, man, I sure have a lot of weird issues. I appreciate all the help and direction... SSMS 17.9 activity monitor grayed out - Hello community, I have a problem with the activity monitor on a sql server 2016 cluster. The processor time in the... adding securables to your own account. - Hope this is the right board for this, if not please let me know. I was asked to help with a... A question about the EXISTS operator - In the ye olde AdventureWorks2016 database if I run the following query it returns Exists, even though the sub-query returns... T-SQL Query To Find Memory Usage Per Resource Pool Per Database - Hi, I have just started using Resource governor in SQL Server 2016 and my manager has asked me to write a... How to replace NOT IN in WHERE clause - --SQL select distinct s.subscription_id, s.subscription_nm from #tmp_deal_hdr adh inner join al on al.lic_id = adh.lic_id inner join avt_user u on u.userid=adh.salesperson_i System Memory - I have system (win2012 r2) with 32GB, out of which 26 is allocated to SQL Server 2014 EE, I ran... Limit Size of Tables - I'm looking for a way to put a cap on the size of newly created tables or adding data to... DB Mirroring - As a part of application upgrade process, it would create bunch of objects and the data insertion would be made.... Find missing numbers in sequence 1 thru 5 - I have a table with records. Each set of records is numbered 1 thru 5. I need to iterate thru... Excluding values using NOT IN not working - I posted last week or so about joining results to an existing table and I tried all the responses but... Create new Central Line based on Trend - Hi, I have managed to get so far with creating a central line that changes depending upon trend that is... Sp_help for Oracle? - I'm building a set of SQL Server views that use OPENQUERY to run queries against an Oracle server. I want to... Integration Services - I install SQL 2008 R2 on a server. Integration Services works just fine on server. If I try to connect... Schedule Report After Data Is Processed - I'm new to SSRS and I'm trying to figure out how to have a report delivered once the data is... |
|
| This email has been sent to [email protected]. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the [email protected]. | 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. | This transmission is ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: [email protected] |
|
|
