- Essential Knowledge
- News
- Tips
- Expert Advice
- Definitions
- Multimedia
- All
Email Alerts
-
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
-
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
-
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
-
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 utili... 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
-
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
- See More: Essential Knowledge on Microsoft SQL Server 2008
-
Microsoft gives tour of new release of SQL Server
Microsoft gave PASS Summit 2010 attendees a walk-through of its Denali SQL Server release, demoing its AlwaysOn, FileTable and expanded SQL Server Integration Services features. News | 11 Nov 2010
-
Latest SQL Server 2008 service pack beefs up R2 support
In addition to the usual updates and hotfixes, SQL Server 2008 SP2 will take better advantage of R2’s multi-server management and DAC capabilities. News | 16 Jul 2010
-
Q&A: SQL Server 2008 a better fit for consolidation
Consolidation still has its fair share of challenges, but improvements to SQL Server 2008 could actually make it easier than ever before. Article | 28 Oct 2009
-
End of life comes for SQL Server 2005 SP2, 2008
Mainstream support for at least two versions of Microsoft SQL Server is set to expire next year. Article | 08 Oct 2009
-
SQL Server Reporting Services 2008 offers faster speeds, new variations
Get the inside scoop on Reporting Services 2008 with Michael Lisin and Jim Joseph, co-authors of the new book, "Microsoft SQL Server 2008 Reporting Services Unleashed." Article | 27 Jul 2009
-
Microsoft renames SQL Server release, adds data services
Some say upping the logical processor support in SQL Server may be a reaction to Oracle's acquisition of Sun. Article | 11 May 2009
-
Microsoft kills standalone WinFS file system
Microsoft has pulled the plug on one of Bill Gates' pet projects just over a week after he turned the technical mantle of his company over to Ray Ozzie. Article | 26 Jun 2006
-
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. Tip
-
SQL Server stored procedures supercharged in recent, upcoming versions
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. Tip
-
Getting the most out of 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. Tip
-
On the server level with SQL Server 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 the server level and provide information about a SQL ... Tip
-
Gain insight with SQL Server dynamic management views
Dynamic management views, a feature in SQL Server 2005 and newer, let users say goodbye to complex queries for retrieving database information. In the first of this two-part series, have a look at a sampling of SQL Server DMVs and the database info t... Tip
-
Seizing stats and grouped data with T-SQL aggregate functions
The power of aggregate functions goes well beyond the basics. This tip demonstrates how to work with grouped data, verify checksums, and retrieve detailed statistics. Tip
-
The nuts and bolts of T-SQL aggregate functions in SQL Server 2008
Understanding how to work with aggregate functions can open new doors to the types of information retrieved from your database -- and it may not be as tricky as you think. Tip
-
Data collection the automated way in SQL Server 2008
SQL Server 2008's data collector feature automates the collection of critical performance data, which DBAs can then analyze using brand new SSMS reports. Tip
-
Programming report generation with SQL Server Reporting Services 2008
Learn the fundamentals of programmatic report rendering in SQL Server Reporting Services 2008 with examples of when you might use such functionality. Tip
-
Data Transformation Services vs. SSIS: The key differences
While SQL Server Integration Services 2008 is a major step up from the days of DTS, there are still some gotchas for developers to be aware of. Tip
- See More: Tips on Microsoft SQL Server 2008
-
Upgrading to SQL Server 2008 advantages and hardware requirements
Planning an upgrade to SQL Server 2008? Our expert weighs in on advantages and hardware requirements you should consider before upgrading to SQL Server 2008. Ask the Expert
-
application server
An application server is a server program in a computer in a distributed network that provides the business logic for an application program. Definition
-
Major SQL Server 2008 features outlined by Microsoft exec
At TechEd 2007, Microsoft product manager Francois Ajenstat discussed some of the major features in SQL Server 2008 designed to appeal to database administrators and IT administrators. In this first podcast of a two-part series, Ajenstat provides det... Podcast
-
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. Tip
-
SQL Server stored procedures supercharged in recent, upcoming versions
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. Tip
-
Getting the most out of 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. Tip
-
On the server level with SQL Server 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 the server level and provide information about a SQL ... Tip
-
Gain insight with SQL Server dynamic management views
Dynamic management views, a feature in SQL Server 2005 and newer, let users say goodbye to complex queries for retrieving database information. In the first of this two-part series, have a look at a sampling of SQL Server DMVs and the database info t... Tip
-
Microsoft gives tour of new release of SQL Server
Microsoft gave PASS Summit 2010 attendees a walk-throug