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...
2012-10-18
1,677 reads
Basit Aalishan Masood-Al-Farooq
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...
2012-10-15
836 reads
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...
2012-10-15
1,032 reads
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...
2012-10-08
1,374 reads
2012-10-07
856 reads
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...
2012-10-07
1,621 reads
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...
2012-10-01
1,330 reads
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...
2012-09-21
1,528 reads
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...
2012-09-19
2,386 reads
Logon Triggers: SQL Server
As the name implies, logon triggers fire in response to the logon event that is raised when a user sessions...
2012-09-17
24,323 reads
Blogs
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
dataMinds Connect 2025 – Slides & Scripts
You can find all the session materials for the presentation “Indexing for Dummies” that...
Forums
Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
DBCC CHECKIDENT
Comments posted to this topic are about the item DBCC CHECKIDENT
Distributed Availability Group Health: T-SQL and Zabbix
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
Question of the Day
DBCC CHECKIDENT
What is returned as a result set when I run this command without a new seed value?
See possible answers