SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Basit's SQL Server Tips

Basit Farooq is a Lead Database Administrator, Trainer and Technical Author. He has more than a decade of IT experience in development, technical training and database administration on Microsoft SQL Server platforms. Basit has authored numerous SQL Server technical articles, and developed and implemented many successful database infrastructure, data warehouse and business intelligence projects. He holds a master's degree in computer science from London Metropolitan University, and industry standard certifications from Microsoft, Sun, Cisco, Brainbench, Prosoft and APM, including MCITP Database Administrator 2008, MCITP Database Administrator 2005, MCDBA SQL Server 2000 and MCTS .NET Framework 2.0 Web Applications.

Archives: December 2011

Why you may or may not consider using Database Snapshots!

Microsoft introduced database snapshots with SQL Server 2005. A database snapshot is a static, read-only copy of a source database that gives you a consistent view of a database as of a certain point in time. You can use the snapshot for operations supported by a read-only database, such as… Read more

0 comments, 8,174 reads

Posted in Basit's SQL Server Tips on 17 December 2011

Configuring and monitoring transactional replication between two SQL Server 2005 instances…

Replication often plays an important part in your database management strategy. An organization may use database replication for load balancing, offline processing, redundancy, and other typical administrative tasks. This blog post shows you how to configure replication between two Microsoft SQL Server 2005 systems using the SQL Server Management Studio Read more

0 comments, 2,111 reads

Posted in Basit's SQL Server Tips on 17 December 2011

Get drive & mount points space information in SQL Server 2005 by using CLR Stored Procedure?

As we know xp_fixeddrives can only be use to retrieve normal fixed drives space information. It cannot be used to retrieve information about the mount points. Mount points are now supported in SQL Server 2005. We implemented them on our production clusters and therefore needed a way to monitor them. Read more

4 comments, 1,763 reads

Posted in Basit's SQL Server Tips on 16 December 2011

My first blog post!

I’ve started my own SQL blog. Hopefully I’ll write some interesting SQL blog posts here soon.

Read more

2 comments, 488 reads

Posted in Basit's SQL Server Tips on 16 December 2011