News

Learn how to use the Azure Portal to create a cloud-based SQL database with just a few mouse clicks.
Businesses and other organizations use SQL programs to access and manipulate the information and data in their databases and create and alter new tables. What is a database?
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.
Book Review: "Teach Yourself SQL in 24 Hours," by Ryan K. Stephens and Ron Plew, is an excellent primer for mastering the relational database model and all its intricacies.
During the last few articles, we have covered the basics of working with SQL server using the Server Management Objects (SMO) and PowerShell. We have covered things such as viewing the state of ...
SQL Server 2016 and Azure SQL Database both give you tables that automatically keep track of changes to your data. Here's how to both create those tables and alter existing tables so they track the ...
SQL Server lets you disconnect a database from the main server program, allowing you to make safe backup copies or send data to branch offices.
How to Create a Phone Number Database Viewable Online. To create an online database to display phone numbers, or any other stored data, you must move beyond basic HyperText Markup Language ...
Today’s README file explains how to create connection strings to SQL Server databases using Visual Studio’s built-in tools. To provide an example using real source, I created a simple Winforms ...
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.