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

The Voice of the DBA

How Do You Setup Your Instances?

I've set up a lot of SQL Server instances in my career. I've gone from manual only setup in SQL Server 4.2 to more automated means in the latest versions. The easiest was actually in Azure where I only need to specify a few parameters for a PoSh cmdlet. However, unattended setup is pretty easy as well for local SQL Server instances. If you've never done it, you're missing out. There are plenty of other ways to do this with tools like Chef and Puppet, AMIs in AWS, and more.

Erik Darling wrote a post recently called Setting Up SQL Server: People Still Need Help. Erik's point in the piece is not that installing SQL Server is hard, but that many people stick with the defaults once they've installed the instance, never changing anything. There are some basic things that you'll want installed all the time, so having a repeatable process is important.

This week I'm wondering how you install instances in your job. If you need to add a new SQL Server for production or development, what do you do? Let us know your process and procedure.

I don't set up too many instances, and in fact, I mostly add them as a lab instance on one of my machines. For the initial install at times, I'll just run through the manual install, but I then have a quick config script that I use to change a few items, but very few. In most cases, I don't do much more than add a few logins, limit memory, and enable the DAC. For the cases where I want to add a few different instances for testing, say for looking at patches or using mutli-server features, I'll use an unattended install script.

There are some amazing ways people have created for repeatable installs, such as the Finebuild project. If you've got a way that works for you, let us know. Just be sure that whatever repeatable process you use changes some of the defaults and ensures your SQL Server is better prepared for any workload to come.

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 ( 3..0MB) 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.

Write, format, analyze, and refactor SQL fast with SQL Prompt

Writing SQL is 50% faster with SQL Prompt. Your SQL code can be formatted just the way you like it, you can create and share snippets with your team, and with code analysis you get suggestions to improve your SQL as you type. Download your free trial

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

Question of the Day

Today's Question (by Steve Jones):

I have installed SQL Server 2017 RTM on Linux. I am creating a new login for a client. What are my password policy options?

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.

Design and configure SQL Server instances and databases in support of high-throughput applications that are mission-critical and provide consistent response times in the face of variations in user numbers and query volumes. Learn to configure SQL Server and design your databases to support a given instance and workload.

Pick up your copy of this great book today at Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I want to use a table valued parameter (TVP) in a procedure. How do I declare the structure of the TVP?

Answer: The structure is declared as a table type

Explanation:

The structure of a table-valued parameter is declared as a table type. The parameter is then set to this table type.

Ref: USe Table-Valued Parameters - 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 - Administration

Best way to mirror SQL database of customers to our SQL database - We have installed a SQL 2017 database on a Windows 2016 server at our customers (about 20) worldwide. We Installed a...

SQL Server 2016 : SQL Server 2016 - Administration

Cost Threshold For Parallelism - Your opinion - Hi, I'm not going to ask what its for or anything, I understand it and its whole history back to Nick's...

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

Updating in duplicate records -

Dealing with specific search in Dimensions with "large" row number - Good day, my question is if there is a way to deal with user related slow performance in Excel in pivot...

Importing from XML to SQL 2014 - This is my 4th day on SQL so I am a newbie. I created a query to import from an...

SQL Server 2014 : Administration - SQL Server 2014

SQL server redirect - Hi, Is it possible to redirect all the incoming request on InstanceA\DatabaseXYZ to InstanceB\DatabaseXYZ ? if yes how? What sorts of permission...

Linked Server Kerberos Double-Hop Problem - Dear Colleagues, I am having a kerberos-related problem. I have a network of two SQL Servers that reference each other via...

Unregistered Component Error in SSIS - I can't create any Data Flow Task. Once I create (tested and working) Connection (it doesn't matter if it is...

SQL Server 2014 : Development - SQL Server 2014

Is there a better way to fetch more than one parameter from a row? - Over the years I've developed the habit of doing this in circumstances where I need to fetch a couple of...

If branch then 'HDQ CityName, State - I have a table and a user requested a data and he wants me to format it in a way...

Does a check constraint with UDF has performance impact on Query? - Hi all We have a Master table that has a primary key with two columns ( Code char(4), location int ). We have...

SQL Server 2012 : SQL Server 2012 - T-SQL

Begin and Rollback transaction with Being Try and Catch and GOTO statement - I create a store procedure with Begin and Rollback transaction with Being Try and Catch and GOTO statement but getting...

Case statement with multiple values returned - Hello everyone! First time posting and i'm sure this is going to be an easy one as i'm not a...

SQL Server 2008 : SQL Server 2008 - General

How do I write a record for each day in a date range??? - Hi To make it simple I have a @StartDate and @EndDate I choose students with an admit date in that range from the...

code folding in ssms? - Hello - What are some techniques you use for code folding in SSMS? For example, in Visual Studio you can add...

SQL Server 2008 : SQL Server 2008 Administration

Restore backup from SQL 2017 to SQL 2008 - Hi. There is a lot of post about my question, but I have little different problem. We have an SQL...

Cloud Computing : SQL Azure - Development

Multiple queries in one - Hi I have a table with the following structure: CREATETABLE .

Reporting Services : Reporting Services

Stored Procedure versus SQL In Report - What are the pros and cons of using a stored procedure to produce the data for report versus putting the...

Data Warehousing : Integration Services

Deployed package with SQL Server authentication logon fails - Hi, I'm new to deploying SSIS packages so apologies if this question is a simple one. I have deployed a package that...

SQLServerCentral.com : Articles Requested

SQL Server 2016 SSIS Basics - We have the Stairway to SSIS, but things have changed. I had a request for installing SSDT and a basic...

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.