In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

Next Steps Migrating your self-managed SQL Server database to a fully-managed Amazon RDS for SQL Server database is a high-payoff decision. Amazon RDS for SQL Server is a like-for-like (homogeneous) ...

SQL Server database backups in Azure, in either an IaaS or PaaS implementation, introduce several distinct features which may help optimize a backup plan. Of course, there are also a few drawbacks to ...

All, We currently have a SQL 2008 server running as a VM. We backup nightly using Veeam and my consultant also advise we backup on top of that via BackupExec. Lately, our Backupexec jobs have been ...

I needed to copy the SQL Server database, with its most recent schema changes, down to my laptop for a client demonstration at a location where Internet connectivity might not be available. Even ...

You create a data source name (DSN) to save database setup information, so you can open a connection to the SQL Server database without re-entering the server information.

Joey on SQL Server How To Automate Tasks in Azure SQL Database Knowing how to automate tasks in the cloud will make you a more productive DBA.