Welcome to the new T-SQL Solutions newsletter, brought to you by SQL Server Magazine. T-SQL Solutions is your monthly source for ideas, explanations, resources, tips, tricks, and code samples to help you write the most effective T-SQL code for your database application project. I'm excited to be part of this new venture, and I promise you that if you need or want to know more about T-SQL, you won't be disappointed.
Each month, we'll bring you regular columns and feature articles covering a wide range of T-SQL topics. Because systems administrators and DBAs often want to know how to do more than just point and click in Enterprise Manager, I'll cover in my T-SQL Admin column how administrators can use T-SQL to do their jobs better, faster, and easier and better understand their databases. Itzik Ben-Gan's T-SQL Q&A column will include comprehensive answers to real questions posed on the public newsgroups and in readers' letters. And Kimberly L. Tripp-Simonnet's T-SQL Tutor column will provide a firm foundation for solid programming practice.
Our planned feature articles look so good that I wish we could print them all at once. If you're patient, you'll read about using T-SQL for statistical operations and as a programming language. We'll compare T-SQL with ANSI SQL, explore advanced join operations and subqueries, show you how to tune T-SQL for performance, and give you lots of great ideas for writing your own user-defined functions (UDFs) and special kinds of constraints. But that's only the beginning.
We also welcome your input. In future issues, this page will contain Reader to Reader, a column of practical suggestions straight from the trenches. Share your SQL Server 2000 and 7.0 T-SQL programming tips (in 400 words or fewer); send them to [email protected] (please specify Reader to Reader in the Subject line), and include your phone number in the email message. We'll edit submissions for style, grammar, and length. If we print your contribution, you'll get $50!
We also encourage you to send your questions and comments about the newsletter to [email protected] Your feedback helps shape the direction of the newsletter. Tell us which areas of T-SQL programming are most useful to you and what your greatest T-SQL stumbling blocks are. We might even take your feedback, research it, and turn it into an article.
We hope you enjoy reading this newsletter as much as we enjoy putting it together for you.