Professional Association for SQL Server

Articles

In this section you can read articles regarding SQL Server.

Performance tuning

Why object Qualification is important.

Importance of Upsert.

SQL 2005 - 2008

Row Level Versioning

CLR UDT Change Manglement

SQL Injection

Transparent  Data Encryption

The SQL Server Administrator's Console

NET-OOP Primer

Regular Expressions: CLR Super Strings

SQL Server Configuration - Part 1

SQL Server 2005

The Birth of YUKONJACK

Try and Catch the Wind - Further Adventures of YukonJack

The AdventuresWorks of Yukon Jack (Using Visio to Visualize Schema Separation)

Monitoring

Database Monitoring Strategy

SQL  Runbook

Database Development

Hitting the Ground Running with Reporting Services (The Best Thing Since...)  


Transactional Meditation: T-SQL Commitment Control  (The Perfect Transaction does Not Live in SQL Server)


Checksum and Distributed Query Performance


sp_depends - Don’t stake your project maintenance on it!


Automation and T-SQL

.Net for the DBA

Bill Wunder’s DDL Archive Utility meets VB.Net


Using the SQLDataAdapter and the SQLXMLAdapter in a VB.Net Application – Part 1


Using the SQLDataAdapter and the SQLXMLAdapter in a VB.Net Application – Part 2


Using The .Net Framework 1.1 Configuration Tool - A DBAs window into the Global Assembly Cache

 

Log Shipping with SQL LiteSpeed

Heavy Duty LiteSpeed Log Shipping Part 1


Heavy Duty LiteSpeed Log Shipping Part 2


Heavy Duty LiteSpeed Log Shipping Part 3


Heavy Duty LiteSpeed Log Shipping Part 4


Heavy Duty LiteSpeed Log Shipping Part 5


The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting, educating, and promoting the Microsoft SQL Server community. From local user groups and special interest groups (SIGs) to webcasts and the annual PASS Community Summit � the largest gathering of SQL Server professionals in the world � PASS enables knowledge sharing, in-depth learning, access to the Microsoft SQL Server team, and the ability to influence the direction of SQL Server technologies. PASS was founded in 1999 by Microsoft and CA and continues to enjoy executive level endorsement from both organizations. As the number one user community for Microsoft SQL Server, Microsoft looks to the PASS community for valued feedback, input, and inspiration. PASS Mission Empower the global Microsoft SQL Server community to connect, share, learn and be inspired through networking, knowledge sharing, peer-based learning, and the ability to influence the direction of Microsoft SQL Server products and services.

Sponsors

PASSChapterLogo100.jpg