Articles

The call for speakers is open through midnight on April 10, 2009, so get busy submitting those abstracts! Work hard on the title and description, make it something that seems interesting and compelling for attendees. Expect the competition to be fierce...The call for speakers is open through midnight on April 10, 2009, so get busy submitting those abstracts! Work hard on the title and description, make it something that seems interesting and compelling for attendees. Expect the competition to be fierce...

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2009-03-24

950 reads

Super Quick Table Meta Data

by Jacques Bosch

SQLServerCentral.com

Metadata

Learn how to get column names, data types, indexes, foreign keys, triggers and more in one snappy overview from new author Jacques Bosch

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(48)

You rated this post out of 5. Change rating

2009-03-23

8,698 reads

Discuss

Almost Like a Service Pack

by Steve Jones

SQLServerCentral.com

Editorial - WMV

Microsoft recently laid off a number of people and made a mistake that they handled poorly. Steve Jones comments about what could have been done better.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2009-03-23

642 reads

Finding the Causes of Poor Performance in SQL Server, Part 1

by Additional Articles

SimpleTalk

Performance Tuning

To tackle performance problems with applications, first use SQL Profiler to find the queries that constitute a typical workload: From the trace, spot the queries or stored procedures that are having the most impact. Then it's down to examining the execution plans and query statistics. You then see what effects you've had and maybe repeat the process. Gail explains all, in a two-part article.

2009-03-23

5,352 reads

Introduction to Windows PowerShell for the SQL Server DBA Part 2

by Additional Articles

MSSQLTips.com

PowerShell

To continue this series on Introduction to Windows PowerShell for the SQL Server DBA, this tip will look at the pipeline and output processing.

2009-03-23

3,574 reads

A Better English Query

by Steve Jones

SQLServerCentral.com

Editorial - WMV

Someone is trying to build a better query engine for the web, something beyond a search engine. Steve Jones comments on the possible implications for databases if this works.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2009-03-22

785 reads

A Better English Query

by Steve Jones

SQLServerCentral.com

Editorial - iPod

Someone is trying to build a better query engine for the web, something beyond a search engine. Steve Jones comments on the possible implications for databases if this works.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2009-03-22

753 reads

A Better English Query

by Steve Jones

SQLServerCentral.com

Editorial - MP3

Someone is trying to build a better query engine for the web, something beyond a search engine. Steve Jones comments on the possible implications for databases if this works.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2009-03-22

719 reads

Ordering Tables To Preserve Referential Integrity

by R Glen Cooper

SQLServerCentral.com

Database Design

When moving data in related tables between databases, the order sometimes matters. New author Glen Cooper brings us an article that discusses the issues in maintaining referential integrity.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(24)

You rated this post out of 5. Change rating

2009-03-20

6,308 reads

Discuss

Introducing New Features In The VSTS Database Edition GDR

by Additional Articles

Microsoft MSDN

Data Dude

In this article, we focus specifically on highlighting new features in the GDR, including its support for offline schema development, tools that support new processes that you can use when you develop a database schema, and features that support database administration.

2009-03-20

2,208 reads

Discuss

Articles

PASS 2009 Summit - Call for Speakers is Open

Super Quick Table Meta Data

Almost Like a Service Pack

Finding the Causes of Poor Performance in SQL Server, Part 1

Introduction to Windows PowerShell for the SQL Server DBA Part 2

A Better English Query

A Better English Query

A Better English Query

Ordering Tables To Preserve Referential Integrity

Introducing New Features In The VSTS Database Edition GDR

Blogs

Reflections on the Life of a DBA

Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables

A Spread of Vacation

Forums

Alamat kantor BCA KCU YOGYAKARTA Telp:082144477715

Alamat kantor BCA KCU KELAPA GADING Telp:082144477715

Inquiry – Enforcing ApplicationIntent=ReadOnly via GPO

Question of the Day

TempDB Facts I