Old South Exchange

Sql Server Magazines

SQL Server Security $49.99 Addresses SQL Server vulnerabilities and provides security solutions. Covers installation, administration, and programming–plus security issues such as authentication, encryption, intrusion detection, and more. Written for IT professionals administering or programming any SQL Server-based application–includes coverage of SQL Server 7, SQL Server 2000, and SQL Server (Yukon).

Mastering SQL Server Profiler $27.93 SQL Server Profiler is one of the most useful of SQL Server’s "built-in" tools, recording data about various SQL Server events. "Mastering SQL Server Profiler" will make it easier for you to learn how to use Profiler, analyze the data it provides, and to take full advantage of its potential for troubleshooting SQL Server problems. All the examples have been optimized to work with both SQL Server 2005 and 2008.

Learning SQL on SQL Server 2005 $35.99 Anyone who interacts with today’s modern databases needs to know SQL (Structured Query Language), the standard language for generating, manipulating, and retrieving database information. In recent years, the dramatic rise in the popularity of relational databases and multi-user databases has fueled a healthy demand for application developers and others who can write SQL code efficiently and correctly. If you’re new to databases, or need a SQL refresher, Learning SQL on SQL Server 2005 is an ideal step-by-step introduction to this database query tool, with everything you need for programming SQL using Microsoft’s SQL Server 2005-one of the most powerful and popular database engines used today. Plenty of books explain database theory. This guide lets you apply the theory as you learn SQL. You don’t need prior database knowledge, or even prior computer knowledge. Based on a popular university-level course designed by authors Sikha Saha Bagui and Richard Walsh Earp, Learning SQL on SQL Server 2005 starts with very simple SQL concepts, and slowly builds into more complex query development. Every topic, concept, and idea comes with examples of code and output, along with exercises to help you gain proficiency in SQL and SQL Server 2005. With this book, you’ll learn: Beginning SQL commands, such as how and where to type an SQL query, and how to create, populate, alter and delete tables How to customize SQL Server 2005′s settings and about SQL Server 2005′s functions About joins, a common database mechanism for combining tables Query development, the use of views and other derived structures, and simple set operations Subqueries, aggregate functions and correlated subqueries, as well as indexes and constraints that can be added to tables in SQL Server 2005 Whether you’re an undergraduate computer science or MIS student, a self-learner who has access to the new Microsoft database, or work for your company’s IT department, Learning SQL on SQL Server 2005 will get you up to speed on SQL in no time.

Essential SQL on SQL Server 2008 $38.74 This book, written for readers who have little or no previous experience with databases, SQL, or SQL Server, provides a very systematic approach to learning SQL using SQL Server. Each chapter is written in a step-by-step manner and has examples that can be run using SQL Server. Using the sample tables and data provided, the reader of this book will be able to do all the examples to experience hands-on SQL programming in SQL Server. The book also presents a series of exercises at the end of the chapters to help readers gain proficiency with SQL. With this book you will learn beginning SQL commands – how to retrieve and manipulate data using the simple SELECT statement; how to customize SQL Server 2008′s settings and about SQL Server 2008′s functions; how to create, alter, populate and delete tables; about joins, a common database mechanism for combining tables; query development, the use of views and other derived structures; simple set operations; about aggregate functions; how to write subqueries and correlated subqueries; how to create and use indexes and constraints; transaction processing.

Microsoft SQL Server 2005 $27.99 This is the eBook version of the printed book. If the print book includes a CD-ROM, this content is not included within the eBook version. Microsoft SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition) will prepare database administrators for upcoming changes in SQL Server 2005. Obtain the skills necessary to run SQL Server 2005 from the experts at Microsoft Gold Partner. Get a head-start to understanding the new concepts and features of SQL Server 2005 from the database administrator's perspective, including: SQL Server 2005 Architecture Tool Sets Scalability, Reliability and High Availability Chapter Performance Tuning Replication .NET CLR Integration DTS and Business Intelligence Minimize the surprises in SQL Server 2005 with the help of Microsoft SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition) .

Visual Studio 2010 Premium with MSDN Renewal $1,349.00 Microsoft Visual Studio Premium w/MSDN Retail 2010 English Programs Not to Latam Renewal*****Build-to-Order sku from Microsoft. Non-cancellable and Non-returnable.****** Box only includes a card to allow end-user to submit activation of their subscription. It does NOT include a DVD….

Visual Studio 2010 Ultimate with MSDN Renewal $2,799.00 Microsoft Visual Studio Ultimate wMSDN Retail 2010 Renewal*****Build-to-Order sku from Microsoft. Non-cancellable and Non-returnable.******…

SQL Server Magazine’s Ash Grey T-Shirt Sql Light T-Shirt by CafePress This light t-shirt will be fashionable even after the zombie Apocalypse. In fact, this shirt might be the very reason you’ll survive said Apocalypse. The light color shows you aren’t worried about getting stains – and even if you were, those stains show t…

SQL Server Magazine’s Sql Hooded Sweatshirt by CafePress The hoodie: the perfect utilitarian piece of clothing. Leave your hat and scarf at home Stay warm and comfy in your Pullover Hooded Sweatshirt. This hoodie is constructed with a cotton/polyester blend – both durable and comfortable.Heavyweight 90…

Five SQL Server Monitoring Counters

SQL Server counters are tools used in SQL Server monitoring. They enable you to measure many aspects of SQL Server performance. If you collect historical data you can use it now and in the future to properly optimize your SQL server. You can utilize counters for your preferred metrics. Using these counters will make it fast and simple to find and fix SQL server performance issues.

Discover more SQL Server monitoring tactics.

Here are 5 common SQL server counters you could use while optimizing your SQL server.

1. Buffer Manager: Page Life Expectancy
A counter of page life expectancy will measure the amount of time a page stays in the buffer cache. Their unit of measure is in seconds. If a page remains in memory it does not require SQL server queries to read from a disk. The performance of the system will increase with increased page life expectancy.

2. Batch Requests/Second
Batch requests/second measure the number of batches SQL Server receives per second. This will indicate the amount of activity a SQL server is experiencing. As the numbers grow, so do the number of query executions. SQL Server optimization requires periodic measurements to determine SQL Server performance over time.

3. SQL Compilations/Second
The measurement of SQL compilations/second refers to the amount of execution plan a SQL server can compile in a second. This resource intensive process can negatively impact your SQL performance. This measurement should be compared to batch requests/second to determine whether or not compilations are hurting performance.

4. Buffer Cache Hit Ratio
This ratio will show how many times SQL servers find data pages in their buffer cache when requested through a query. A number closer to 100 indicates superior performance. It means the SQL server could gather the data from memory rather than from a disk.

Learn about the benefits of SQL Server optimization.

5. Lock Waits/Second
From time to time the SQL server will need to lock system resources to ensure it can deal with many users utilizing the system at the same time. The lock waits/seconds counter measures the number of times that SQL Server was unable to retain a lock. SQL server performance can be degraded by the inability to retain a lock. In a perfect world this number would be 0. As numbers stretch further from 0 performance will decrease.

Celebrating Irving Fisher $44.95 F. Scott Barker has worked as a developer in the database field for over 16 years, and with Visual Basic, SQL Server, and Microsoft Access for the last 14 years. Scott is a Microsoft MVP and holds a Bachelor of Science in Computer Science. Scott worked at Microsoft for two years as a member of the Microsoft Access and FoxPro teams. After leaving Microsoft, he started his own company, Applications Plus, and continued to consult for them by developing in-house tools. Scott has trained for Application Developers Training Company and throughout the United States, and is a frequent speaker at Microsoft Conferences in the United States, Canada, South Asia, and Europe. Through his classes and conferences, Scott has trained thousands of developers. Scott is a writer for a number of Microsoft Technical magazines, as well as a columnist for DotNetJunkies, and is the author of a number of books including topics such as ADO. NET, Visual Basic .NET, and InfoPath 2003.