Sql Servers

Plan Freezing with SQL Server 2008
Plan Freezing with SQL Server 2008 is a great Virtual Lab to see how to optimize query plans, move them from test server to production servers, and finally clone the plans amidst several SQL Servers if needed. I hate to admit it because ...

SQL Server - The Most Powerful Database Administration Tool
SQL servers have a large number of powerful tools that facilitate database maintenance, and administration. Among the most important ones are the Enterprise Manager, the Service Manager and the Query analyzer. ...

User’s guide to avoiding virus infections
Some viruses, mostly worms, can exploit through servers and affect other servers from servers that have been infected. A good example is the SQL slammer. This was a worm that affected SQL servers run by Microsoft IIS and Microsoft SQL ...

Sounds wont play in webview with replicated database
We have a backup WhatsUp server and second server running sql server 2005 in another datacenter. I have setup replication for the WhatsUp database between the 2 sql servers. Each transaction on the main sql server is sent to the backup ...

SQL 2005 Tools Install Experience is the suck
WTF? Didn't I just tell you I wanted 64-bit non-Itanium? 5) *Guess* that SQL Server x64 folder is where you'll actually find the installer. 6) Nope. Found folders for Servers and Tools. What was I trying to install again? ...

Availabe Consultants Excellent consultants available with us for ...
Experienced with DTS Packages (MS SQL Server 2000) Responsible for configuring and administrating IIS Servers and SQL Servers for various clients on production and staging environment. Have excellent communication and interpersonal ...

Instant SOA - The Patent has been Filed!
After starting up Instant SOA in your browser, you'll choose the database vendor (ie Oracle, Sybase, SQL Server, etc. - over 200 choices are available) that contains existing components (ie data or program units) that you wish to make ...

Do You Have Too Many Servers?
Extreme high performance servers are the top candidates for the 64-bit platform. Specially, large scale database management systems like Microsoft SQL Server 2000 (64-bit). The 64-bit environment allows a large addressable memory pool ...

Virtual Servers
... but sets of servers, as we wanted. Months of work have gone by. I just got the word through back channels… project scrapped. I documented the story into an article that’ll appear in SQL Server Central at some point in the future. ...

The Key Features of Microsoft SQL Server 2005
This server includes clustering and mirroring of records. really, an SQL server cluster is numerous servers that are configured matchingly. This allows several servers to take their part of the workload. There is an matching virtual ...