• Five things in SQL Server not in SQL Azure

    With the excitement over the cloud, it’s easy to forget that Microsoft’s cloud database, SQL Azure, is not for everyone. Learn the five major differences between SQL Azure and SQL Server.

  • Microsoft retools SQL Server stored procedures

    Microsoft is forever tinkering with SQL Server stored procedures to give queries more thrust. Find out what’s new in SQL Server 2008, 2008 R2 and the next-generation 2012 release.

  • Using SQL Server information schema views

    SQL Server information schema views let you access metadata about database objects such tables and columns. Learn how you can access the views to retrieve relevant information.

  • On the server level with dynamic management views

    The pantheon of dynamic management views (DMVs) extends beyond the database-related views covered in the first of two articles focusing on this SQL Server feature. Learn about DMVs that operate at ...

Microsoft SQL Server 2008

Email Alerts

Register now to receive SearchSQLServer.com-related news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

  • What's new for installation with SQL Server 2008?

    In this chapter excerpt from "Microsoft SQL Server 2008 Reporting Services Unleashed", learn about features that simplify installing or upgrading to SQL Server 2008.  Book Excerpt

  • Microsoft SQL Server 2008 Learning Guide

    This guide provides an in-depth look at SQL Server 2008, with information on upgrading, overviews of the most important new features, and details on future releases.  Learning Guide

  • An overview of SQL Server Report Builder 2.0

    In this chapter excerpt from "Learning SQL Server 2008 Reporting Services", learn about Report Builder 2.0, including its interface details, and how it can be used to create descriptive reports.  Book Excerpt

  • Microsoft SQL Server 2008 Resource Governor primer

    Resource Governor is a new feature in SQL Server 2008. In this chapter excerpt from "Microsoft SQL Server 2008 Management and Administration", learn more about Resource Governor and how it can improve SQL Server performance.  Book Excerpt

  • A short history of SQL Server Integration Services

    In this chapter excerpt from "SQL Server 2008 Integration Services Unleashed", learn more about how SQL Server Integration Services evolved from Data Transformation Services into a fully functional data warehousing tool.  Book Excerpt

  • Microsoft SQL Server Integration Services primer

    In this chapter excerpt from "SQL Server 2008 Integration Services Unleashed", learn what's included with SSIS and how developers and database administrators can use these utilities to improve performance and accessibility.  Book Excerpt

  • Basic objects of T-SQL in SQL Server 2008

    Discover the basic objects that drive T-SQL in SQL Server 2008 in this excerpt from "Microsoft SQL Server 2008: A Beginner's Guide." Author Dusan Petkovic discusses how literal values, delimiters, comments, identifiers and reserved keywords are util...  Book Excerpt

  • Additional T-SQL operations in SQL Server 2008

    Learn how scalar operators, global variables and NULL values can be used in Transact-SQL, with examples to gauge your understanding of SQL Server 2008 objects and operators, in this book excerpt from "Microsoft SQL Server 2008: A Beginner's Guide."  Book Excerpt

  • SQL Server 2008 function types in T-SQL

    Functions in Transact-SQL can be either aggregate functions or scalar functions. This excerpt from "Microsoft SQL Server 2008: A Beginner's Guide" describes both and details the many numeric functions that can be accessed in SQL Server 2008.  Book Excerpt

  • Using T-SQL data types in SQL Server 2008

    Learn the numerous data types used in SQL Server 2008's Transact-SQL language in this excerpt from "Microsoft SQL Server 2008: A Beginner's Guide."  Book Excerpt

Back to top