What is SQL Static Code Analysis? Static code analysis is useful in parsing the source code and checking the syntax such that it complies with the bui...
Database Security Compliance Guidelines
Importance of database security Databases hold the backbone of organizations, it contains the most critical information of the company: its transactio...
SQL Database performance tuning
What is SQL Database performance tuning and its importance? SQL server is a great choice for getting your database applications up and running. The us...
The DBA and the Cloud
Role of the DBA in the cloud As more and more organizations are moving towards the cloud, there has been a debate about the future role of DBAs or dat...
Database Administrator and DevOps
Role of Database Administrator in DevOps The Database Administrator or DBA is the person responsible for all the activities related to maintaining the...
Monitor Log Shipping Script
Having multiple databases being log shipped could become a nightmare to monitor. The native SQL Monitor will just send too many emails and flood your ...
Fix Orphaned Users Automatically
When a database is attached or restored from one server to another, the logins IDS stored in the master database do not align with the login IDS store...
SQL Server LOB columns
LOB columns have certain restrictions such as the inability to perform online index rebuild. Identifying them maybe important for planning maintenance...
SQL Server Identify User Permissions
Identifying all permissions that a user has over certain type of SQL objects can be useful for audit and assessment purposes. The script below will re...
Identify SQL Server Broken Dependencies
Broken dependencies happen when the relationship between two objects is broken. Prompt identification may help identify and prevent failing processes....