Author: Basit Aalishan Masood-Al-Farooq

Pro Members SQL Server Standard Members

SQL Server monitoring and optimization–(Part 2)

by

SQL Server monitoring and optimization – (Part 2) Author: Basit A. Farooq Editor’s Note: In this first of the two part article series, you learned how to use monitoring tools, including System Monitor and SQL Server Profiler. You also learned how capture a trace file or table using SQL Server Profiler. In this second part, you learn how to use...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

SQL Server Monitoring and Optimization (Part 1)

by

SQL Server monitoring and optimization – (Part 1) Author: Basit A. Farooq To optimize the performance of your database, you need to monitor and tune. You determine the performance baseline, how SQL Server is currently performing, through monitoring. Your optimization process includes making changes and then monitoring their effect. This means adjusting two overlapping performance areas, that is, database server...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

SQL Server Encryption Options – Part 2

by

SQL Server Encryption Options – Part 2 Author: Basit A. Farooq Editiors Note: In the first part of this article series, I discussed the options for encrypting connections and learn concepts on how to encrypt confidential data in the database. In this second part, I will show you how to encrypt data using cell-level encryption, and how to encrypt database...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

SQL Server Encryption Option – Part 1

by

SQL Server Encryption Options – Part 1 Author: Basit A. Farooq Many database servers store confidential data, which must be protected from unauthorized access when it’s transmitted across the network and stored on the server. SQL Server provides support for encrypted connections, encrypting data, encrypting database and for encrypted storage. In this first part of this article series, I’ll discuss...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Bulk Transfers: Some guidelines

by

Bulk Transfers: Some guidelines Author: Basit A. Farooq Introduction Bulk transfers are a common way of importing large amounts of data into, or exporting large amounts of data out of, SQL Server databases. SQL Server supports bulk transfers run from an operating system command line or the SQL Server command processor. When performing bulk transfers, you must consider the implications...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Understanding Triggers

by

Understanding Triggers Author: Basit Farooq 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 (DML) trigger fires in response...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Possible ways to secure SSIS Packages

by

Possible ways to secure SSIS Packages Author: Basit A. Farooq In this article, I’ll first give an overview of SQL Server Integration Services (SSIS) security. Then I will talk about the different package protection levels and roles. Finally, I will talk about how to sign the SSIS packages. Overview of SSIS Packages Security Whether you are developing a SSIS package...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

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

by

Back to basics: Transact-SQL programming fundamentals – (Part 2) Author: Basit A. Farooq Editor’s Note: In the first of this three-part series, you will learned how to use scripts and batches, and basics of T-SQL variables. In this part, you will learn about Transact-SQL control-of-flow language, including BEGIN…END, IF…ELSE, CATCH, WHILE, BREAK, CONTINUE, RETURN, and WAITFOR. Control-of-Flow Transact-SQL provides special...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

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

by

Back to basics: Transact-SQL programming fundamentals – (Part 1) Author: Basit A. Farooq Editor’s Note: In the first of this three-part series, you will learn how to use scripts and batches, and basics of Transact-SQL variables. 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...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Planning for Recovery

by

Planning for Recovery Author: Basit A. Farooq 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 or Log Shipping...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
1 … 8 9 10 11 12 … 15