Cindy Gross: SQL Server + Big Data

Cindy Gross - SQL Server and Big Data Troubleshooting + Tips

February, 2010

Posts
  • Cindy Gross: SQL Server + Big Data

    How to Rename SQL Server

    • 1 Comments
    How to rename a SQL Server varies a bit depending on the SQL version, whether it is clustered or not, and whether you want to rename the server/virtual server part of the name (works except for SQL 2000 clusters) or the instance part of the name (requires...
  • Cindy Gross: SQL Server + Big Data

    SQL DAC

    • 0 Comments
    When you start SQL Server (2005+) it creates a separate "Dedicated Administrator Connection" or DAC using a special TCP port. One sysadmin at a time can connect with this DAC connection by specifying Admin:ServerName\Instance. From SQLCMD you can either...
  • Cindy Gross: SQL Server + Big Data

    Remote Desktop Options

    • 0 Comments
    You probably use remote desktop to connect to your servers or other desktops. You may see Remote Desktop referred to as RDP, RDS, or MSTSC. One common concern is how to resize the remote desktop connection. You can use mstsc.exe to open your connection...
  • Cindy Gross: SQL Server + Big Data

    SQL 2008 R2 Developer Kit now available!

    • 0 Comments
    You can download a free developer kit for SQL Server 2008 R2 (there's also one available for SQL 2008, the link is at the bottom of the R2 download page). Each kit has videos, samples, labs, and more to help you learn about new features. For instance...
Page 1 of 1 (4 items)