By default (which isn’t a good practice) the location of your databases are here: C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA Unlike yours, this particular one is ...

What new functionality, like SQL Server’s new cardinality estimator or a database's Target Recovery Time setting, would you like to take advantage of? An upcoming DBTA webcast, presented by Andy ...

Step-By-Step: Learn the basics of using DTS in Microsoft SQL Server ... data (Figure C). I also need to enter my source server name (STEVENW), my authentication method, and the database I want ...

Here are some best practices for transferring data and tips for school districts that are about to start a migration to SQL Server 2014. There a several options for migrating databases to new versions ...