News

Learn how to use the Azure Portal to create a cloud-based SQL database with just a few mouse clicks.
How to Create a Table From Query Results in Microsoft SQL. If your business uses relational databases to store data, you may have used a SQL SELECT clause to create new tables from query results.
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.
One way that organizations are storing data in the cloud is by moving their databases to the cloud. What once meant building an entire physical server, patching it, installing software like Microsoft ...
Your database may get damaged due to several reasons. A backup will help you to restore the database lost in case of disasters and problems, like hardware failure, virus attack, or others. How To ...
How to Restore a SQL Database From a .MDF File. Computer database software such as Microsoft's SQL Server benefits all types of businesses, as it makes recordkeeping fast, flexible and secure.
SQL Server 2008 offers two options for collecting change tracking information within the database engine, using built-in features that offer reliability and performance advantages over tracking tables ...
In this second delve into data cleanliness (read the first, How clean is your data?, here), we’ll test-drive the data profiling tool provided with Microsoft SQL Server.
Procedure to move Microsoft SQL Server database to a new location, painlessly, if you’re running low on disk space, added a new drive array, or just curious.