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 […]
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 […]
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 […]
Posted in SQL Server | 19 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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
Posted in SQL Server | 1 Comment »
