Search Results: 'SQL Server'
Accelerated SQL Server 2008
Before I describe the contents of this book and why I think you should just take it over to the
counter and buy it, I would like to give you an insider’s look at the SQL Server 2008 product... More > development
cycle. I believe this insight will provide you with a deeper understanding of how SQL Server
is continuing to evolve. The rest of this book will show you why SQL Server is enterprise-ready.
For the past 5 years, I was a program manager at Microsoft in the SQL Server product unit.
During this time, I owned various features within the product, including SQL Server Agent, SQL
Server Express, and most recently, database security.
When I joined SQL Server in 2002, the product team was in year 3 of planning and implementing
the Yukon (SQL Server 2005) release. One of my first responsibilities was to own the Create Database/
Database Properties dialog in SQL Server Management Studio. After working with the user interface< Less
SQL 2000 Server Administration
Learn many useful SQL SERVER 2000 ADMINISTRATION technical skills fast and easy. Learn SQL SERVER 2000 ADMINISTRATION from anywhere you are, just use your computer to run the program. This is self... More > paced training program for beginner, absolutely the perfect SQL SERVER 2000 ADMINISTRATION training starter at affordable price.
With this low cost, you can master SQL SERVER 2000 ADMINISTRATION technical skills in a short time. After you learn SQL SERVER 2000 ADMINISTRATION confidently, then invest money on the SQL SERVER 2000 ADMINISTRATION application software.< Less
Dissecting SQL Server Execution Plans
Every day, out in the various discussion boards devoted to Microsoft SQL Server, the same types of questions come up again and again: Why is this query running slow? Is my index getting used? Why... More > does this query run faster than this query? My response is the same n in each case: have you looked at the execution plan?
Execution plans provide a wealth of information on how your queries are being executed by SQL Server, and are a vitally important tool for anyone who writes TSQL to access data in a SQL Server database.
My goal with this book was to gather as much useful information on execution plans as possible into a single location, and to organize it in such as way that it provided a clear route through the subject. Written and tested for SQL Server 2005, I guide you right from the basics of capturing plans, through their interpretation, and then on to how to use them to understand how you might optimize your SQL queries, improve your indexing strategy, spot some common performance issues, and more.
SQL Server for Node.js
Microsoft SQL Server provides many features for data manipulation. Now you can access SQL Server from Node.js application. This book helps you how to get started with Node.js and SQL Server. It... More > covers how to prepare your development environment.
1. Preparing Development Environment
2. Hello World - Connecting to Database Server
2.1 Database Configuration
2.2 Development Tools
2.3 Connectivity Testing
3. Database Table Operations
3.1 What are Table Operations?
3.2 Database Connection String
3.3 Inserting Data
3.4 Reading Data
3.5 Updating Data
3.6 Deleting Data
3.7 Finding Data
4. Stored Procedures
4.1 Creating Stored Procedure
4.2 Executing a Stored Procedure
4.3 Stored Procedure with Parameters
5. Working with Image and Binary Data
5.1 Image and Binary Data
5.2 Inserting Data
5.3 Reading Data
5.4 Deleting Data
6.1 What is a Transaction?
6.2 Case 1 - Data Processing without Transaction
6.3 Case 2 - Data Processing with Transaction< Less
SQL Server 2000 Programming Course
Ships in 3-5 business days
A comprehensive programming course for Microsoft SQL Server 2000 from the original UK SQL Server 'Guru'.
Pro SQL Server 2008 Reporting Services
At its core, the process of designing reports hasn’t changed substantially in the past 15 years.
The report designer lays out report objects, which contain data from a known data source, in... More > a
design application such as Business Objects Reports or Microsoft Access. He or she then tests
report execution, verifies the accuracy of the results, and distributes the report to the target
Sure, there are enough differences between design applications to mean that the designer
must become familiar with each particular environment. However, there’s enough crossover
functionality to make this learning curve small. For example, the SUM function is the same in
Business Objects Reports as it is in Microsoft Access as it is in Structured Query Language (SQL).< Less