Tag: SQL

SQL 2008

SQL Server 2008 Certified

SQL Server is something that most people in IT roles will touch one way or another in the course of their working lives. It is the engine behind many line of business systems, SharePoint, ERP and CRM systems. Having the basic skills to correctly install, configure, backup, recover and troubleshoot SQL Server issues is important and something that is often just assumed. Over the past … Continue reading SQL Server 2008 Certified

Steve1 Comment
SQL 2008

Moving SQL Express or MSDE Databases

Many applications use Microsoft MSDE or SQL Express instances to store application specific data. The default file location is usually somewhere on the C: drive, which may seem harmless until they start consuming valuable disk space. It is possible to move the databases without reinstalling the applications using this method: Install SQL Management Studio Express (or use SQL Management Studio if you have it) Locate … Continue reading Moving SQL Express or MSDE Databases

Steve
EBS

EBS 2008 Premium Server Overview

The premium edition of Essential Business Server 2008 (EBS) includes an additional Windows 2008 Standard Server licence and SQL 2008 standard license. While the three servers that make up the core of EBS are 64bit, the forth server can be either 32bit or 64bit. Here are a few ways this server can be used to enhance the network environment. Virtualisation With the included Windows 2008 … Continue reading EBS 2008 Premium Server Overview

Steve
Networking

DNS Aliasing

How many times have you had to upgrade a server and run around making changes to login scripts and group policies. How about migrating users to a new terminal server or migrating applications to a new SQL server. DNS aliases can be used to simplify these tasks and with a little bit of thought prevent the need to ever make those changes again. File Server … Continue reading DNS Aliasing

Steve