Collation in SQL Server
Introduction You must have already heard the term “Collation” in SQL Server. Collation is a...
SQL Vulnerability Assessment
SQL Vulnerability Assessment is a feature available in the latest versions of SQL Server Management Studio (SSMS). This feature is very...
SQL Data Discovery and Classification
With the recent data protection laws and the implementation of GDPR last year, it is imperative for us to know the type of data our...
Overview of DBCC SHRINKFILE Command
Running DBCC Shrink commands is quite a controversial issue across the SQL Server community. In...
Overview of DBCC CheckDB Function
Introduction Regular database maintenance is an important part of a Database Administrator’s job which helps to ensure that critically...
How to Copy SQL Server Databases from One Instance to Another
Copying or moving databases is one of the most common tasks for data professionals who regularly deal with deploying scripts or new...