Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: April 2013

Identify the cause of SQL Server blocking

In my previous article (Different techniques to identify blocking in SQL Server) on MSSQLTips.com, I discussed about locks and blocks, and presented you with an overview on how to troubleshoot and resolve blocks using dynamic management views and Activity Monitor. After I wrote this article, I… Read more

0 comments, 447 reads

Posted in Basit's SQL Server Tips on 24 April 2013

The Public Role – a potential high risk security concern for DBAs

The public role is a special fixed-database role, which exists in every SQL Server database. The public role is different from all other database-level roles because in SQL Server, every database user is automatically assigned to the public database role, and you cannot remove public database role from SQL Server… Read more

0 comments, 1,254 reads

Posted in Basit's SQL Server Tips on 24 April 2013

SQL Server index related dynamic management views and functions (Part 2)

SQL Server uses indexes to sort and organize table data. It creates indexes based on ordering values from one or more selected columns. SQL Server automatically creates indexes when you define a primary key or unique constraint. You can use indexes to manage and track rows in a table or… Read more

0 comments, 336 reads

Posted in Basit's SQL Server Tips on 24 April 2013

Determining when statistics were last updated in SQL Server?

I received an email from friend today asking how he can see when statistics were last updated in SQL Server. Well, in SQL Server, there are two ways to access the last modified date of a statistic, which are:

  1. Through the header information using DBCC SHOW_STATISTICS.
  2. Through STATS_DATE() function…

Read more

0 comments, 314 reads

Posted in Basit's SQL Server Tips on 15 April 2013

Consolidating Error Logs from multiple SQL Servers using SSIS

SQL Server stores all informational messages, warning messages, and errors in operating system and application log files. As a database administrator (DBA), it is our responsibility to review the information in the error log files on a daily basis for any errors that have occurred in our SQL Server environment.… Read more

0 comments, 270 reads

Posted in Basit's SQL Server Tips on 14 April 2013

SQL Server index related dynamic management views and functions (Part 1)

Microsoft SQL Server provides DBAs and Developers with several index related dynamic management views and functions, which they can use to maintain, modify, tune and identify missing indexes. Some of these dynamic management views (DMVs) and functions (DMFs) you might use are listed as follow:

  • sys.dm_db_index_operational_stats — Returns information about…

Read more

0 comments, 278 reads

Posted in Basit's SQL Server Tips on 14 April 2013

The PUBLIC role – Do not use it for database access!

As per Microsoft Books Online and SQL Server Security best practice white paper, it is recommended to periodically review privileges granted to public role, and revoke any unnecessary privileges assigned to this role. This is because public role is a special database role that exists in every user database, and… Read more

0 comments, 1,640 reads

Posted in Basit's SQL Server Tips on 4 April 2013

SQL Server Reporiting Services: Migrating SSRS reports, data sources and subscriptions from one server to another

As part of our SQL Server infrastructure consolidation project, it was decided to consolidate multiple companies SQL Server 2005 / SQL Server 2008 Reporting Services instances to a new dedicated SQL Server 2012 Report Services instance. These existing SQL Server Reporitng Services instances hosts many business critical SSRS reports, data… Read more

10 comments, 5,379 reads

Posted in Basit's SQL Server Tips on 2 April 2013