Best FREE SQL Server Tools for Database Developers and Administrators!

Best FREE SQL Server Tools for Database Developers and Administrators!
Rate this post

This article provides a comprehensive list of the best SQL Server FREE tools for database developers and administrators! You can download the following tools and use it in your commercial projects!

Feel free to share the link with your colleagues and friends in Twitter, Facebook or any other way convenient for you! Read More

ROLLBACK TRUNCATE in SQL Server

ROLLBACK TRUNCATE in SQL Server
Rate this post

Have you ever accidentally executed the TRUNCATE command on a wrong table? This will lead to all data loss. The worst thing is that you will not have a chance to get your data back. In this article, we will have a look how to avoid such situations and have a chance to ROLLBACK TRUNCATE. Read More

Dive Into SQL Server Transaction Log — Part 2

Dive Into SQL Server Transaction Log — Part 2
Rate this post

This is the second article in a series of articles about SQL Server transaction log file architecture. In this article, we will have a look at two SQL Server statements that allow examining transaction log details. If you would like to get an introductory information about how SQL Server transaction log works, read Dive Into SQL Server Transaction Log — Part 1 Read More

Dive Into SQL Server Transaction Log — Part 1

Dive Into SQL Server Transaction Log — Part 1
Rate this post

Chances are you already know that every SQL Server database contains one or more transaction log files, in addition to data files, that records all the transactions and database modifications made by each transaction. The transaction log is an essential part of any database, and the database administrator must keep it under observation. One of the most important tasks for the database administrator is to truncate the transaction log file to keep it from overflow. Why? Because the transaction log plays the most important role when it comes to the database recovery. Read More

Retrieving SQL Server Metadata with Help of T-SQL

Retrieving SQL Server Metadata with Help of T-SQL
Rate this post

This article contains a list of scripts that mine the SQL Server metadata in the various system functions, stored procedures, tables, and catalog views. Metadata queries are really helpful in discovering information for a given database schema. You can copy all the T-SQL scripts that are listed in this article and use for your own purposes. However, please do some tests before apply to a production database.

Read More

Active Directory vs Azure Active Directory

Active Directory vs Azure Active Directory
Rate this post

Active Directory traditionally used to manage elements of a domain-based network. But companies increasingly implement various cloud services that require its own user accounts. A tool for creating and managing user accounts, that are used by different Microsoft cloud services, which a company acquires, is Azure Active Directory. Read More