SQL Server DMVs in Action: Better Queries with Dynamic Management Views

: 31 12, 15:13
: 2621

Every action in SQL Server - queries, updates, whatever - leaves a set of tiny footprints; SQL Server records all that valuable data and makes it visible through Dynamic Management Views, or DMVs. A DBA or developer can use this incredibly detailed information to significantly improve the performance of queries and better understand what's really going on inside a SQL Server system SQL Server DMVs in Action is a practical guide that shows how to obtain, interpret, and act on the information captured by DMVs to keep SQL Server in top shape. The 100+ samples provided in this book will help readers master DMVs and also give them a tested, working, and instantly reusable SQL code library....

Beginning Spatial with SQL Server 2008

: 31 12, 15:13
: 1196

Microsoft SQL Server 2008 introduces new geography and geometry spatial datatypes that enable the storage of structured data describing the shape and position of objects in space. This is an interesting and exciting new feature, with many potentially useful applications. Beginning Spatial with SQL Server 2008 covers everything you need to know to begin using these new spatial datatypes, and explains how to apply them in practical situations involving the spatial relationships of people, places, and things on the earth. All of the spatial concepts introduced are explained from the ground up, so you need not have any previous knowledge of working with spatial data. Every section is illustrated with code examples that you can use directly in SQL Server. All of the topics covered in this book apply to all versions of SQL Server 2008, including the freely available SQL Server 2008 Express. What youll learn Understand the fundamental concepts involved in working with......

MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008 Implementation and Maintenance (PRO-Certification)

: 31 12, 15:13
: 1187

Long Description Announcing an all-new SELF-PACED TRAINING KIT designed to help maximize your performance on 70-432, the required exam for the new Microsoft Certified Technology Specialist (MCTS) certification for SQL Server 2008 Implementation and Maintenance. This 2-in-1 kit includes the official Microsoft study guide, plus practice tests on CD to help you assess your skills. It comes packed with the tools and features exam candidates want most including in-depth, self-paced training based on final exam content; rigorous, objective-by-objective review; exam tips from expert, exam-certified authors; and customizable testing options. It also provides real-world scenarios, case study examples, and troubleshooting labs for the skills and expertise you can apply to the job. Focusing on implementing and maintaining a SQL Server 2008 database, this official study guide covers installing and configuring SQL Server 2008; managing SQL Server Agent jobs, alerts, and operators; implementing......

Mastering SQL Server 2008

: 31 12, 15:13
: 1080

As Microsofts bestselling database manager, SQL Server is highly flexible and customizable, and has excellent supportthe 2008 version offers several significant new capabilities. This book offers accurate and expert coverage on the updates to SQL Server 2008 such as its enhanced security; the ability to encrypt an entire database, data files, and log files without the need for application changes; a scalable infrastructure that can manage reports and analysis of any size and complexity; and its extensive performance data collection....

SQL Server Fundamentals for the Accidental DBA (Video Training) (LiveLessons)

: 31 12, 15:13
: 1016

SQL Server Fundamentals for the Accidental DBA Eric Johnson For power users, developers, IT pros, and anyone who manages SQL Server without formal DBA training. Eric Johnson shows you how to perform every essential DBA task with SQL Server 2005 and SQL Server 2008, even if youve never had any DBA training. Learn at your own pace through realistic hands-on examples that walk you through every step! SQL Server MVP and expert Eric Johnson is a database analyst who has spent many years working with Microsoft SQL Server. He is author of A Developers Guide to Data Modeling for SQL Server (Addison-Wesley, 2008) and the forthcoming Windows Essential Business Server 2008 Unleashed (Sams). Eric is currently the President of the Colorado Springs SQL Server Users Group. Are you an accidental DBAout of the blue expected to run Microsoft SQL Server efficiently, reliably, and securelywhen nobody ever taught you how? From installation to backup/restore, indexing to......

The Rational Guide To SQL Server 2005 Security

: 31 12, 15:13
: 831

SQL Server 2005 takes a generational leap forward in security technology. When configured properly, a SQL Server instance is secure by design, secure by default, and secure in deployment. In The Rational Guide to SQL Server 2005 Security, Michael Hotek clearly explains the new features of SQL Server 2005. Beginning at installation and progressing through each successive layer of the engine, he discusses the best practices for each aspect of security configuration. Topics include installation and surface area configuration, endpoints and connectivity, principals, securables, permissions, and encryption. Advanced topics include code security and auditing....

SQL Server 100 Most Asked Questions: Best Practices guide to managing, mining, building and developing SQL Server databases

: 31 12, 15:13
: 955

The Smart Guide to building World-Class Applications. This book is your source for the latest SQL server news, updates, tips, tricks and more. You get real answers that make a difference, it is the only All SQL Server, All the time starter technical resource for developers, DBA's and business intelligence architects. By delivering a unique blend of tactical, hands-on information, this book facilitates the context and content necessary to help SQL Server professionals get their jobs done. Finding information and answers quickly is critical to the success of today's IT organizations. This book covers the 100 most asked SQL Server questions, at the right time, with the right message...

Pro SQL Server 2008 Relational Database Design and Implementation (Pro)

: 31 12, 15:13
: 949

Learn effective and scalable database design techniques in a SQL Server environment. Pro SQL Server 2008 Relational Database Design and Implementation covers everything from design logic that business users will understand all the way to the physical implementation of the design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, authors Louis Davidson, Kevin Kline, Scott Klein, and Kurt Windisch show how to get it right in SQL Server database design and lay a solid groundwork for the future use of valuable business data. Solid foundation in best practices and relational theory Maximize SQL Server features to enhance security, performance, scalability Thorough treatment from conceptual design to an effective, physical implementation What youll learn Develop conceptual models of client data using interviews and client documentation. Normalize data models to enhance scalability and the long term use of valuable data.......

Pro SQL Server 2008 Reporting Services (Pro)

: 31 12, 15:13
: 1190

Take full advantage of everything SQL Server 2008 Reporting Services has to offer and deliver customizable, webenabled reports across your business at a reasonable cost. Learn bestpractices from professionals who use SQL Server Reporting Services daily to deliver solutions to paying clients and gain the competitive edge on using Microsofts enterpriselevel reporting platform. Provides bestpractices for using Reporting Services Written by practicing professionals with paying clients Your key to delivering business intelligence across the enterprise What youll learn Write efficient queries on which to base a report. Build and lay out a report using Report Designer. Enable end users to create ad hoc reports on demand. Combine Reporting Services with Analysis Services, SharePoint Portal Server, and other technologies to deliver business intelligence across the enterprise. Secure and audit your reports as part of your regulatory compliance efforts. Customize your......

Pro SQL Server 2008 XML

: 31 12, 15:13
: 1045

Knowledge and ability to apply XML are de rigueur in todays world, and SQL Server developers and administrators are no exception to that rule. Pro SQL Server 2008 XML is your key to unlocking the powerful XML feature set first introduced in SQL Server 205 and since refined in SQL Server 2008. Author Michael Coles shows how to store XML using SQL Servers builtin XML data type. Learn to query and manipulate XML data using standard technologies such as XQuery and XSLT. No SQL Server database professional an afford to be without knowledge of the XML feature set. Pro SQL Server 2008 XML delivers on the knowledge that you need to remain competitive in your career. * Shows how to store, query, and manipulate XML documents in SQL Server * Proides stepbystep examples showing best practices and advanced features * Accurately discusses how SQL Servers XML feature set stacks up against the ISO XML standards...