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: August 2013

Up or out? Deciding on SQL Server scalability

Scalability is the ability of a system to support an increased workload by adding incremental system resources without fundamentally changing the system design or architecture. We must distinguish the scalability from reliability, because reliability is the ability of a system to manage the workload without experiencing failures or stopping altogether. Read more

1 comments, 255 reads

Posted in Basit's SQL Server Tips on 6 August 2013

SQL Server upgrade paths: What to do before, during, after upgrading

Creating SQL Server upgrade paths from one version to another is a task that every database administrator is eager to undertake. However, upgrading SQL Server is not an easy task, and improper planning increases the chance of derailment and delays.

Checkout my article here, in which I discussed what… Read more

0 comments, 299 reads

Posted in Basit's SQL Server Tips on 6 August 2013

Guide to SQL Server Table Indexes (Part 3)

Checkout the part-3 of my five part article series on Guide to SQL Server Table Indexes here, in which you will learn about remaining index types available in SQL Server, and what are these indexes advantages and dis-advantages.

This article is published on SQL-SERVER-PERFORMANCE.COM.


Read more

0 comments, 277 reads

Posted in Basit's SQL Server Tips on 6 August 2013

Guide to SQL Server Table Indexes (Part 2)

Checkout the part-2 of my five part article series on Guide to SQL Server Table Indexes here, in which you will learn about the different types of indexes available in SQL Server, and what are some of these indexes advantages and dis-advantages.

This article is published on SQL-SERVER-PERFORMANCE.COM. Read more

0 comments, 232 reads

Posted in Basit's SQL Server Tips on 6 August 2013

Designing and Implementing Online Analytical Processing (OLAP) Architecture – (Part 2)

SQL Server allows applications and users to execute full- text search queries against character based data in SQL Server tables. Full-text search is applicable in wide-range of business scenarios. You use full-text search to create queries that search for a word or phrase in a column. You can use full-text… Read more

0 comments, 344 reads

Posted in Basit's SQL Server Tips on 6 August 2013

Understanding Data Normalization

Normalization, which is the key part of the OLTP databases logical design process, is a design requirement for OLTP databases. Normalization refers to a process used to design relational database tables. Its objectives include minimizing the duplication of information within OLTP databases, as well as reducing the overall size of… Read more

0 comments, 249 reads

Posted in Basit's SQL Server Tips on 6 August 2013