Microsoft Sql Server 2008
22 Stories
The technology behind an F1 race
News While Formula One cars are feats of engineering in themselves, the technology involved in the race and preparation leading up to it is equally impressive.
Tags: Processors, Servers, Data mining & analysis, Data, Microsoft SQL Server 2008, software, marketing, monitor, strategy, Vodafone Group Plc.
Genting gets social with Web 2.0
News The Malaysian enterprise is rolling out this week a customized collaborative network for board and senior management to work and share ideas more productively.
Tags: Web 2.0, Business applications, Web logs, Digital media, Software engineering/development, Software integration, phone, Microsoft SQL Server 2008, podcast, chairman
New Date Datatypes in SQL Server 2008
Techguide SQL Server 2008 provides new data-types for storing wider ranges of dates with more precision. Here's how you can use these new data types to your advantage.
Tags: Server platforms, Microsoft Windows, Data Type, Microsoft SQL Server, Data, Database, Storage, DATE, DATETIME2, Server
Microsoft probing SQL Server vulnerability
News The vulnerability opens system to remote code execution but only affects certain versions of the database software.
Tags: Network security, Server platforms, Microsoft Windows, Microsoft Corp., Microsoft SQL Server, Security, Vulnerability, Microsoft SQL Server 2000, Microsoft SQL Server 2005, Microsoft Data Engine
Microsoft releases preview for next SQL Server
News Preview of the next version of Microsoft's database product, SQL Server 2008 R2, has been delivered to developers and will soon be made generally available.
Tags: Business applications, Microsoft SQL Server, Database, Community Technology Preview, Environment, Server, Microsoft SQL Server 2008, business intelligence, blog
Three tips for avoiding project estimating mistakes
Techguide Project cost oversights are incredibly common, but IT project managers can avoid estimating mistakes by being well prepared upfront. An expert offers some advice.
Tags: Project management, IT project management, Microsoft Corp., Microsoft SQL Server, Client, Project, project manager, Server, Microsoft SQL Server 2008, Hardware
The 10 best IT certifications
Techguide Debatable or not, here are some of the accreditation that a technology consultant believes hold value for IT pros.
Tags: Certification, Personal development, Infrastructure/architecture management, IT project management, Microsoft Corp., Microsoft SQL Server, Certification, Security, Skill, Expertise
Setting up CDC in SQL Server 2008
Techguide Change Data Capture is a new native feature in SQL Server 2008 Enterprise Edition. Here's how to use it to easily set up data auditing on your SQL Server system.
Tags: Databases, Microsoft Windows, Server platforms, Microsoft SQL Server, Table, Database, Raleigh, stored procedure, auditing, Chapman Co.
Introduction to Change Data Capture in SQL Server 2008
Techguide SQL Server database consultant Tim Chapman takes a look at the new auditing features available in SQL Server 2008.
Tags: Databases, Server platforms, Data Management, Microsoft SQL Server, Data, Database, Data Auditing, data capture, auditing, DDL
Use Object Dependencies to your advantage in SQL Server
Techguide SQL Server 2008 tracks objects by the name of the object, rather than relying upon the ID. Here’s how it works.
Tags: Databases, App servers, Server platforms, Object, Microsoft SQL Server, Dependency, Database, SQL, stored procedure, SalesHistory
Defining SQL Server 2008 policies
Techguide Learn how you can use SQL Server Management Studio to define your own policies.
Tags: Microsoft Windows, Data Management, Microsoft SQL Server, Database, Policy, Microsoft SQL Server Management Studio, stored procedure, database engine, Condition, Facet
Policy-Based Management in SQL Server 2008
Techguide New to SQL Server 2008 is Policy-Based Management, which gives administrators more control over their database procedures.
Tags: Servers, Databases, Microsoft SQL Server, Database, Policy, Database Table, stored procedure, DDL, Condition, Facet
Using Grouping Sets in SQL Server 2008
Techguide A neat new feature in SQL Server 2008 is the GROUPING SETS clause, which allows you to easily specify combinations of field groupings in your queries to see different levels of aggregated data.
Tags: Databases, Server platforms, Microsoft SQL Server, GROUPING SETS, Clause, Product, Database, SQL, AVG, SalesHistory
Using IntelliSense in SQL Server 2008
Techguide Microsoft has finally released a SQL Server product that includes IntelliSense for writing TSQL statements. In this article, Tim Chapman shows the ins and outs of using IntelliSense in SQL Server 2008.
Tags: Database management, Servers, Microsoft SQL Server, Database, Microsoft SQL Server Management Studio, SQL, stored procedure, Microsoft SQL Server Transact-SQL, development environment, text editor
Backup compression in SQL Server 2008
Techguide New to SQL Server 2008 is the native ability to compress database backups, which can come in very handy during disaster recovery.
Tags: Microsoft Server 2003, Server platforms, Data centers, Databases, Microsoft SQL Server, C, Backup, Database, database backup, SalesHistory
Jump to
1 2
