Ars Technica

SQL Server Managment Studio Express 2005 and SQL Server 2000

SQL Server 2000 is being used here at work for various clinical, sales & marketing tasks, and I utilize SQL Server Enterprise Manager/Query Analyzer 2000.<BR><BR>At home, I have a VPN setup to our ...
Computerworld

How to fix common SQL Server Management Studio ‘Connect to Server’ errors

When you are finished checking Log On accounts, open SQL Server Management Studio, and click the Connect to Server window’s Advanced button. Ensure that Authentication settings match the service ...
dbta

Navigating the Open-Source Revolution in Database Management

Open-source software has reshaped many IT disciplines, and the world of database administration (DBA) is no exception. The open-source community, and the software it has produced, has evolved into a ...
Ars Technica

SQL Managment Studio and small system drive

I have been having an issue. I am currently running a SQL Management Studio 2005 on Win Server 2005. I have about 7GB free on C drive and when i run a query that is expected to return ~85 million ...
MCPmag

Introduction to SQL Server Management Objects with PowerShell

Sometimes you become the accidental DBA, or you are the DBA by choice. Either way, you can choose to spend time working in SQL Server Management Studio (SSMS) to look at things such as backups or the ...