Systems Engineering and RDBMS

Search Results

SQL Server 2008 R2 Utility

Posted on June 1, 2010

SQL Server 2008 R2 has introduced SQL Server utility as part of it’s multi-server administration enhancements – it is the center of operations for consolidating and monitoring the managed instances of SQL Server.  You can launch the utility explorer from the View option in the Menu in SSMS.  If you are launching it the first […]

Read the rest of this post...

Posted in SQL Server | 2 Comments »

Using SCCM for unattended Deployments

Posted on June 5, 2009

In case you have not started using SCCM (System Center Configuration Manager) from Microsoft, we would strongly encourage you to take a look.  MSFT also has two virtual labs to help you become familiar with it – one an introduction to SCCM and the other one deals with upgrading from Systems Management Server 2003 to […]

Read the rest of this post...

Posted in Windows | Leave a Comment »

No Surface Area Configuration Tool in SQL Server 2008

Posted on January 29, 2009

So, you thought that you have by now become comfortable with the Surface Area Configuration Tool in SQL Server 2005 and are ready to do the configuration once you install SQL Server 2008.  Well, the tool does not exist anymore in SQL Server 2008 and has been added to the deprecated feature list. As you […]

Read the rest of this post...

Posted in SQL Server | 20 Comments »

Start Up Options in SQL Server 2005

Posted on January 25, 2009

A reader recently asked how to access the start up options in SQL Server 2005.  In SQL Server 2000, they were able to access it through Enterprise Manager.  In SQL Server 2005, you can do so from the SQL Server Configuration Manager.  As you can see from the image below, you can right click on […]

Read the rest of this post...

Posted in SQL Server | Leave a Comment »

Looking at all the SQL Server Instances in the network

Posted on July 21, 2008

In SQL Server, one way to look for the instances that one can connect is to simply run: osql -L or sqlcmd -L which will list out all the instances on the network that you can look at. You can also look at this through the GUI as shown below: However, when doing this I […]

Read the rest of this post...

Posted in SQL Server | Leave a Comment »

Two small problems resolved

Posted on May 9, 2008

Two small problems were resolved today for one of the client developers – you might have faced this as well, so we are posting the solution here: 1) The developer had migrated a lot of DTS/SSIS packages and was getting connection timeouts.  The reason was that he was using (localhost) in servername for connection.  And […]

Read the rest of this post...

Posted in SQL Server | Leave a Comment »

Finding the Port Number for a particular SQL Server Instance

Posted on January 2, 2008

One of the developers recently asked me this question: “I have a SQL Server instance running – how can I tell what port it is running on?”.  There are a couple of ways of finding this information. 1) Using the GUI: In SQL Server 2000, you can use the Server Network Utility and in SQL […]

Read the rest of this post...

Posted in SQL Server | 4 Comments »

Network Protocols Configuration in SQL Server Express

Posted on October 12, 2007

SQL Server Express Edition is typically used in those applications which access data locally i.e. the SQL Server Express Edition is installed on the same machine where the application is running. Because of this, the “Shared Memory” protocol is the only one that is enabled by default. However, if you have an application that needs […]

Read the rest of this post...

Posted in SQL Server | Leave a Comment »

Start up parameters in SQL Server

Posted on June 20, 2007

Very rarely does one need to add to the start up parameter list in SQL Server but when you do need to (when working with MSFT PSS or trying to add trace flags), you should know what those parameters do and where to add them. In this blog post, we will go over the start […]

Read the rest of this post...

Posted in SQL Server | 1 Comment »

 
Follow

Get every new post delivered to your Inbox.

Join 81 other followers