sql server 2008

TechRepublic Resources

• sort by:
• Relevance
• Date
• Popularity

Microsoft releases the SQL Server 2008 November CTP

Earlier this month, Microsoft released the third and what appears to be the final Community Technology Preview CTP version of SQL Server 2008 before it ships to stores. This CTP includes many of the technology improvements that were slated for SQL Server 2008. In a previous article,...

Tags: Database, Microsoft SQL Server, Backup, Microsoft Corp., SQL Server 2008, November Community Technology Preview, Tim, Databases, Enterprise Software, Software, Data Management, Tim Chapman

Blog posts 2007-11-27

Read about Microsoft's development offerings for 2008

I spend much of my time knee deep in Microsoft technologies, and I often find it difficult to keep up with the new products and versions. Fortunately, I usually have some time to get up to speed because most organizations are slow to adopt new technologies and upgrade to new...

Tags: Developer, Microsoft Visual Studio, IDE, Microsoft .NET Framework, Microsoft SQL Server, Microsoft Visual Studio 2008, Microsoft Windows Presentation Foundation, Microsoft Corp., Feature, Tool, .NET Framework 3.5, LINQ, SQL Server 2008, Microsoft Development Tools, .Net, Databases, Development Tools, Software Development, Software/Web Development, Enterprise Software, Software, Data Management, Tony Patton

Blog posts 2007-11-27

What's new in SQL Server 2008

SQL Server 2008 will be released in 2nd quarter of 2008. SQL Server 2008 will also be part of a joint launch with Windows Server 2008 and Visual Studio 2008 on February 27, 2008 in Los Angeles, CA. If you are interested in SQL Server 2008, you can download the...

Tags: Database, Audit, Performance, Microsoft SQL Server, Backup, Mirroring, Server, Encryption, SQL Server 2008, Extended Events Infrastructure, Data Compression Improved Data Compression, Performance Management, Databases, Enterprise Software, Human Resources, Workforce Management, Software, Data Management, Steven Warren

Blog posts 2007-10-30

Using SQL Server 2008's MERGE statement

SQL Server 2008's new MERGE statement allows you to insert, update, or delete data based on certain join conditions in the same statement. In previous versions of SQL Server, you have to create separate statements if you need to insert, update, or delete data in one table based on certain conditions...

Tags: Microsoft SQL Server, Data, Statement, Table, SQL Server 2008, MERGE, MERGE Statement, Tim, Sales Strategy, Sales Force Management, Databases, Enterprise Software, Sales, Software, Data Management, Tim Chapman

Blog posts 2007-09-24

Passing table valued parameters in SQL Server 2008

I have always wanted to be able to pass table variables to stored procedures. If a variable is able to be declared, it should have the functionality to be passed as necessary.I was thrilled to learn that SQL Server 2008 offers this functionality. Here are instructions on how to pass...

Tags: Database, Procedure, Microsoft SQL Server, Data, Variable, Table, Tim Chapman

Blog posts 2007-08-27

Four cool new features slated for SQL Server 2008

SQL Server 2008 code named Katmai is scheduled to launch in February of next year, and the code isn't slated to be released to manufacturing until Q2 2008. But database gurus don't have to wait to get a sense of what's to come because Microsoft recently released SQL Server 2008...

Tags: sql server

Blog posts 2007-07-30

Additional Resources

Microsoft SQL Server 2008 Product Overview

SQL Server 2008 provides the technology and capabilities that organizations count on. With significant advancements in the key areas of mission-critical platform, dynamic development, beyond relational data, and pervasive insight, the benefits of SQL Server 2008 are substantial. This paper provides an overview of the new benefits and functionality available...

Tags: Microsoft SQL Server 2008, Microsoft SQL Server, Microsoft Corp., Databases, Enterprise Software, Software, Data Management

White papers 2007-06-01

SQL Server 2008 Performance and Scale

Microsoft SQL Server 2008 incorporates the tools and technologies that are necessary to implement relational databases, reporting systems, and data warehouses of enterprise scale, and provides optimal performance and responsiveness. With SQL Server 2008, one can take advantage of the latest hardware technologies while scaling up the servers to support...

Tags: Microsoft SQL Server 2008, Performance, Microsoft SQL Server, Databases, Enterprise Software, Software, Data Management

White papers 2007-08-01

No change in SQL Server 2008 pricing, says Microsoft

Microsoft SQL Server 2008 is coming next year, and the good news is that the database's price will not change. Ted Kummert, corporate vice president for the data and storage platform, announced this news to the 2,000 delegates at the Professional Association for SQL Server PASS Summit,...

Tags: Microsoft SQL Server 2008, Microsoft SQL Server, Microsoft Corp., Pricing Strategy, Databases, Enterprise Software, Software, Data Management, Paul Mah

Blog posts 2007-09-29

Cool Features for SQL Server 2008

Are you ready to change the way you administer and develop SQL Server? Scheduled for release this year, SQL Server's first significant upgrade in three years features a number of envelope-pushing enhancements and improvements. Which ones are best for you and your business? Which will have the greatest impact...

Tags: Microsoft SQL Server 2008, Microsoft SQL Server, Quest Software Inc., Databases, Enterprise Software, Software, Data Management

White papers 2008-01-01

SQL Server 2008: What to Expect

Microsoft SQL Server 2008 has many great new features that will allow you to develop higher performing, more scalable next-generation applications using more than just relational data. Although this release will be a little early for many customers, the fact that the features are largely incremental in nature should reassure...

Tags: Microsoft SQL Server 2008, Global Knowledge Network Inc., Microsoft SQL Server, Databases, Enterprise Software, Software, Data Management

White papers 2008-02-14

MSDN Webcast: Programming SQL Server 2008 (Level 300)

Microsoft SQL Server 2008, code name "Katmai," introduces a significant amount of new or improved functionality, including new data types, in addition to performance and security enhancements. This webcast discusses how user can easily take advantage of the new functionality available in SQL Server 2008 within application development.

Tags: Microsoft Developer Network, Microsoft SQL Server 2008, Webcast, Microsoft SQL Server, Microsoft Corp., Programming, Databases, Enterprise Software, Software, Data Management

Webcasts

MSDN Webcast: geekSpeak: T-SQL Tips and Tricks in SQL Server 2008 With Andrew Karcher (Level 200)

This webcast is for Transact-SQL (T-SQL) lover. The presenter introduces to several new features of SQL Server 2008, including the hierarchy ID data type, the FileStream object, table-valued parameters, and large user-defined types.

Tags: Microsoft SQL Server Transact-SQL, Microsoft Developer Network, Microsoft SQL Server 2008, Webcast, Microsoft SQL Server, Databases, Enterprise Software, Software, Data Management

Webcasts 2008-06-04

Momentum Webcast: SQL Server 2008 (Part 2 of 3) - Expanding Business Intelligence Capabilities (Level 100)

The attendee of this webcast will learn about new features of Microsoft SQL Server 2008. SQL Server 2008 makes great strides in data warehousing, providing a comprehensive and scalable platform that lets organizations integrate data into the data warehouse faster and to scale and manage that data while delivering insight...

Tags: Microsoft SQL Server 2008, Data Warehouse, Webcast, Microsoft SQL Server, Business Intelligence, Databases, Enterprise Software, Software, Data Management

Webcasts 2007-12-06

Server Consolidation With SQL Server 2008

Microsoft SQL Server 2008 supports multiple options for server consolidation, which provides organizations with the flexibility to choose the consolidation approach that best meets their requirements to centralize data services management and reduce hardware and maintenance costs. By providing centralized management, auditing, and monitoring capabilities, SQL Server 2008 makes it...

Tags: Data Service, Microsoft SQL Server 2008, Microsoft SQL Server, Server Consolidation, Databases, Enterprise Software, Servers, Hardware, Software, Data Management

White papers 2008-01-01

SQL Examiner 2008 Professional Edition (msi)

SQL Examiner 2008 Professional Edition is a database software utility that enables you to compare and synchronize SQL Server database schemas. Now, merging two databases is quick and easy, requiring only a few clicks of your mouse. SQL Examiner 2008 Professional Edition delivers precise results by analyzing the dependencies between...

Tags: SQL, SQL Examiner 2008 Professional Edition, Databases, Programming Languages, Storage, Enterprise Software, Software, Data Management, Software Development, Software/Web Development, Hardware

Software downloads 2007-12-19

Online Transaction Processing in SQL Server 2008

Microsoft SQL Server 2008 provides a database platform that is optimized for today's applications, and that can scale for any size of business. It drives cost-efficiencies by dramatically reducing downtime and enabling dynamic and proactive management that significantly reduces administrative overhead. Finally, SQL Server 2008 provides a highly secure platform...

Tags: Microsoft SQL Server 2008, Microsoft SQL Server, OLTP, Microsoft Corp., Databases, Enterprise Software, Software, Data Management

White papers 2008-01-01

MSDN Webcast: 24 Hours of SQL Server 2008: Reach Your Data With SQL Server 2008 (Level 100)

This webcast looks at Microsoft SQL Server 2008 as a productive data platform. This webcast uses Contoso Container Overseas Shipping Operation LTD as our scenario customer while we explore the features that make SQL Server 2008 this platform. Contoso is a shipping company; they arrange the shipping of all kinds...

Tags: Microsoft Developer Network, Microsoft SQL Server 2008, Webcast, Microsoft SQL Server, Contoso, Databases, Enterprise Software, Software, Data Management

Webcasts 2008-03-05

TechNet Webcast: Security Enhancements in SQL Server 2008 (Level 300)

Microsoft SQL Server 2005 introduced many security enhancements, from data encryption to advanced context impersonation. Microsoft SQL Server 2008 further helps administrators protect their database with the introduction of new features such as Transparent Database Encryption, Extensible Key Management, and Auditing. This webcast describes the new security enhancements in SQL...

Tags: Security, Microsoft SQL Server 2008, Webcast, Microsoft SQL Server, Microsoft Corp., Microsoft TechNet, Databases, Enterprise Software, Software, Data Management

Webcasts 2008-02-05

Worth the Wait: Why SQL Server 2008 is Great

SQL Server 2008, releases in the first half of 2008, is intended to provide a comprehensive data platform for both structured and unstructured data that is more secure, reliable, manageable, and scalable than previous releases. But how will it affect you as a working DBA and developer? ...

Tags: Database Administrator, Microsoft SQL Server 2008, Microsoft SQL Server, Quest Software Inc., Databases, Enterprise Software, Software, Data Management

White papers 2008-02-01