Alias

How to setup and use a SQL Server alias

  • Article

I have an application that has a specified database connection that I either can't or don't want to change. However, I need to move the database to a new server. How can I do this easily without breaking other things that maybe using this connection and/or database?

2008-11-18

4,765 reads

Blogs

What the ???? T-SQL Tuesday #120

By

Hey, it’s T-SQL Tuesday again! I almost forgot about it what with Summit and...

First Time Speaking at PASS Summit

By

This week, I filmed my experience as a first time speaker at PASS Summit...

Azure SQL Best Practices?

By

A way to enforce good practice and standards is by Azure Policy. As stated...

Read the latest Blogs

Forums

CheckDB on VLDB, Geography data type

By el_Guapo

I've narrowed down a DBCC CheckDB issue to a set of tables with Geography...

sqlcmd

By sqlfriend

I found recently sqlcmd is missing on my computer. It used to be there....

Multi-column pivot table help

By Pete Bishop

I have the following data in [table_1]: last_updated type_desc size_bytes used_bytes 2019-05-23 LOG 1835008...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers