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.

Understanding Triggers

A trigger is a specialized stored procedure that activates (executes) in response to an event. There are two basic trigger types, ie data manipulation language (DML) trigger and data definition language (DDL) trigger, based on the type of event that causes them to fire. For example, a data manipulation language… Read more

0 comments, 137 reads

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

Possible ways to secure SSIS Packages

SQL Server Integration Services (SSIS) security is based around several layers that provide a rich and flexible security environment. These layers of security include the use of digital signature, package properties, SQL Server database roles and operating system permissions.

Checkout my article here, in which I gave an overview… Read more

0 comments, 166 reads

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

Back to basics: Transact-SQL programming fundamentals – (Part 2)

In the first of this three-part series, you will learned how to use scripts and batches, and basics of T-SQL variables.

Checkout the part-2 of this article series here, you will learn about Transact-SQL control-of-flow language, including BEGIN…END, IF…ELSE, CATCH, WHILE, BREAK, CONTINUE, RETURN, and WAITFOR.

This article is… Read more

0 comments, 425 reads

Posted in Basit's SQL Server Tips on 22 October 2013

Back to basics: Transact-SQL programming fundamentals – (Part 1)

SQL Server users use Transact-SQL programming to create sets of statements for ad-hoc execution. The aim of the Transact-SQL programming is to carry out its transformation objectives by using: Command statements, Variables, and Control-of-flow statements. In this context, a command statement is any executable statement. This includes Transact-SQL commands, stored… Read more

0 comments, 377 reads

Posted in Basit's SQL Server Tips on 22 October 2013

Manage your SQL Server databases with SQL DMVs

Microsoft ships SQL Server with several built-in tools that database administrators (DBAs) can use to manage their SQL Server environment. With SQL Server 2005, Microsoft introduced SQL dynamic management views, or DMVs, as well as dynamic management functions, or DMFs. They provide plenty of information about server and database state,… Read more

0 comments, 234 reads

Posted in Basit's SQL Server Tips on 17 September 2013

Understanding SQL Query Optimization – (Part 1)

Most of the activity of the database server is related to queries. Because of this, query optimization is often a major concern. SQL Server tries to optimize query performance itself, but its effectiveness in this may be influenced by several problems. Indexes and poorly designed queries can lead to unacceptable… Read more

0 comments, 257 reads

Posted in Basit's SQL Server Tips on 17 September 2013

Guide to SQL Server Table Indexes – (Part 4)

Checkout the part-4 of my five part article series on Guide to SQL Server Table Indexes here, in which you will learn about index design, and the suitable candidates for index key and non-key columns. I this article, you will also learn about various SQL Server indexes options, such… Read more

0 comments, 178 reads

Posted in Basit's SQL Server Tips on 17 September 2013

Planning for Recovery

A database server is generally a mission critical component. Having a recovery plan is essential to ensure the business can continue to function in case of hardware failure, natural disaster, or other catastrophe.

A backup server or a standby server (using Database Mirroring, AlwaysOn Failover Cluster Instances, AlwaysOn Failover Groups… Read more

0 comments, 106 reads

Posted in Basit's SQL Server Tips on 17 September 2013

Understanding SSIS Package Configurations

Managing changes to environment dependent variables is common and critical in any ETL application, especially during deployment of SSIS packages. This is because they need to be modified appropriately to ensure smooth deployment of ETL application. SQL Server Integration Services (SSIS) provides package configurations that help you to manage such… Read more

0 comments, 187 reads

Posted in Basit's SQL Server Tips on 17 September 2013

Understanding SQL Server Full-text Indexing – (Part 2)

Checkout the final part of this two part article series here, in which I discussed how to create full-text index using Transact-SQL, and how to manage and optimize full-text search catalogs and indexes.

This article is published on SSWUG.org.


Read more

0 comments, 138 reads

Posted in Basit's SQL Server Tips on 17 September 2013

Understanding SQL Server Full-text Indexing – (Part 1)

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, 150 reads

Posted in Basit's SQL Server Tips on 17 September 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, 201 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, 224 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, 211 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, 193 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, 250 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, 178 reads

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

Guide to SQL Server Table Indexes (Part 1)

One of the most important tasks for every database administrator (DBA) is to ensure that query times are consistent with service-level agreement (SLAs) or within user expectations. One of the most effective techniques to achieve this objective is to create indexes on tables for your queries. SQL Server uses indexes… Read more

0 comments, 422 reads

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

Understanding SQL Server Query Optimization Statistics

SQL Server query optimizer uses statistics to create query plans that improve query performance. For most queries, the query optimizer already generates the necessary statistics for a high quality query plan; in a few cases, you need to create additional statistics or modify the query design for best results. By… Read more

0 comments, 295 reads

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

Newer posts

Older posts