Working with Azure SQL Server, is very similar to working with the traditional on-premise SQL Server. However when it comes to managing users some differences start to become apparent. The first noticeable difference is when trying to create a new login or user. The traditional and user friendly dialog will not appear but instead a … Continue reading 4 Steps to add an SQL managed user to Azure SQL Server
Category: MS SQL
MS SQL Logging and Recovery Lab
In our previous article MS SQL Logging and Recovery we showed how the logging mechanisms and recovery of MS SQL work. In this article we provide a demonstration of how log files work. The following steps demonstrates log file shrinking. Follow these steps in Microsoft SQL Management Studio. Step 1 Create database: create database [clounce] … Continue reading MS SQL Logging and Recovery Lab
MS SQL Logging and Recovery
A common question on mind of database administrators is to find out the best way how to back up and recover your data. This document describes some basic concepts about Microsoft SQL Server logging and recovery. MS SQL Server provides three recovery models – simple, full, and bulk-logged. The simple recovery model is best suited … Continue reading MS SQL Logging and Recovery
Shrinking the Log file
MS SQL stores database changes into a log file that as more activity occurs on the database the larger the log file grows. When it comes to disk space limitations and performance this becomes a considerable problem. MS SQL Server provides a command to truncate the log file DBCC SHRINKFILE(<log file>, 0, TRUNCATEONLY) The command … Continue reading Shrinking the Log file