Startup Parameters Tabs in Configuration Manager – New feature in SQL Server 2012

With each new SQL Server Version, plenty of new features and enhancements are released. In SQL Server 2012, one of those new additions is the Startup Parameters Tab in SQL Server Configuration Manager. Using this you can make changes to SQL Server startup parameters. 

Let us learn where to find the newly added tab.

On the machine where SQL Server 2012 is installed, go to Programs and Microsoft SQL Server 2012 (in this case this RC0, but in the final version Release to Market Version, you would see only Microsoft SQL Server 2012). Then click on Configuration Tools to expand that node, you should see SQL Server Configuration Manager, click to open. (Pic below)

You should see a console which has 2 sections, on the left hand side click services upon which the SQL Server components that are installed on that machine are displayed as shown below. Right click on the Service SQL Server and select Properties.

The Properties window is displayed and there are 6 tabs in total. Click on Startup Parameters Tab to bring it to front. (pic below)

You can see the current startup parameters in this Tab and add new one if required.

Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post.

— Bru Medishetty

What’s new in Installing SQL Server 2012

You might be aware about SQL Server 2012, the next version of SQL Server. As always, there are a lot of new enhancements features announced in SQL Server 2012. Covering all of the new features and enhancements in SQL Server 2012 in detail might not be accomplished in a single blog. Hence I have decided to break that down to a series of blogs. So in this blog we shall look at some changes new additions / deprecations which are related to installing SQL Server 2012.

The following are the changes in installation of SQL Server 2012. 

  • Changes in the Editions, (BI Edition introduced and Datacenter Edition discontinued), I’ve already written a blog on this, read it here..
  • Business Intelligence Development Studio (BIDS) is gone, making way to SQL Server Data Tools (SSDT)
  • Installation of Data Quality Services (DQS) can be done from the SQL Server setup itself.
  • SQL Server failover clustering supports the nodes being in two different subnets, called as SQL Server multi-subnet clustering.
  • SQL Server editions are no more available for Itanium based systems, so if you don’t see I64 directory in the installation software don’t panic.
  • All Operating Systems would need at least SP1 to be installed (Windows 7 and Windows Server 2008 and R2)
  • All applicable updates can be installed along with the main product, so that your SQL Server product is up to date at the time of installation..

Note: The information in this blog is up to date as of SQL Server 2012 Release Candidate 0 and might change at a later time, visit Microsoft SQL Server official site for more updates.

Updated on 11/20/2011: Read Step by Step Installation of SQL Server 2012 RC 0

Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post.

— Bru Medishetty

Querying Multiple Servers in SQL Server 2008

SQL Server 2008 provides the functionality of querying multiple Servers from a single query window. This is helpful for tasks like retrieving server information such as Version, Edition, Instance Name, logins available across each instance, databases on the servers etc.

In order to query multiple servers the only prerequisite is that the servers need to be registered prior to run the query and of course, there should be a valid login to connect to those Server. The SQL Servers can be of other version such as SQL 2000 or 2005. In this example I have two SQL Server 2005 instances and one SQL Server 2008 instance all of them are installed on a single Machine.

For the purpose of this article, I assume you know how to register a SQL Server in the Local Server Groups. Open registered servers from View menu or using keyboard short-cut Ctrl + Alt+ G (picture below).

 

Right click on the server group, from the pop up menu choose New Query as shown in the picture below.

 A new query editor is opened which has is similar to a normal new query editor. The only difference you find is the status bar down at the the bottom of the query editor. The picture below displays the status bar and we see the difference with a usual query editor status bar. This status bar does not a single instance name rather, displays the Server Group Name, also SPID information is not displayed.

I am running a simple query to retrieve the list of the user Databases on all the instances in the server group. The query results is displayed along with the query. The Database names are displayed along with SQL Instance name.

Those of us who would like to find the backup information of the critical databases or to find the SQL Agent Jobs that failed across several instance, that can all be done from a single query in SQL Server 2008.

Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru that let’s you know when there is a new blog post.

–Bru Medishetty