Awarded – Microsoft Community Contributor Award 2012

Today, I’ve received an email from Microsoft stating that I’ve been awarded Microsoft Community Contributor. This is the first time...

How to secure SQL Server?

Databases are an important reservoir of sensitive information, and that is why it is important for us as a DBA...

Using SQL Server 2012 FileTables

Reblogged from Basit's SQL Server Tips:

SQL Server 2012 allows you to store file/directories in a special table called FileTable that...

Understanding DBCC CHECKDB, to deal with corrupt database

Database files are volatile, constantly being changed and updated, so that, like any other volatile files in the system, there...

Reasons Why People Who Work With Computers Seem To Have A Lot Of Spare Time…

Rebuild indexes based on fragmentation - sp_RebuildIndex

Reblogged from Basit's SQL Server Tips:
In my previous post here, I’ve discussed how we can detect fragmentation in SQL Server...

DML Triggers to track SQL Server Agent Jobs creation, deletion and modification events

SQL Server Agent jobs are crucial to any SQL Server environment, as they are used for scheduling and performing critical...

Transact-SQL analytic functions in SQL Server can help solve problems quickly

Like other mainstream commercial database systems, SQL Server supports analytic functions in Transact-SQL to depict complex analytical tasks. With the...

Database Recovery Advisor feature of SQL Server 2012

SQL Server 2012 introduces Database Recovery Advisor that provides significant user experience improvements to the ways DBAs can restore databases...

Logon Triggers: SQL Server

As the name implies, logon triggers fire in response to the logon event that is raised when a user sessions...