Additional Articles

State Transition Constraints

by Additional Articles

SimpleTalk

theory

Data Validation in a database is a lot more complex than seeing if a string parameter really is an integer. A commercial world is full of complex rules for sequences of procedures, of fixed or variable lifespans, Warranties, commercial offers and bids. All this requires considerable subtlety to prevent bad data getting in, and if it does, locating and fixing the problem. Joe Celko shows how useful a State transition graph can be, and how essential it can become with the time aspect added.

2010-10-27

1,942 reads

Top 10 Mistakes When Building and Maintaining a Database

by Additional Articles

Database Journal

Administration

Building and maintain a SQL Server database environment takes a lot of work. There are many things to consider when you are designing, supporting and troubleshooting your environment. This article identifies a top ten list of mistakes, or things that sometimes are overlooked when supporting a database environment.

2010-10-26

7,946 reads

Introducing ADO.NET Entity Framework

by Additional Articles

CODE Magazine

Entity Framework

The challenge of bringing data from efficient storage engines such as SQL Server into object-oriented programming models is hardly a new one. Most developers address this challenge by writing complex data access code to move data between their applications and the database. This requires an understanding of the database so that you can access data either from the raw tables, from views, or from stored procedures.

2010-10-25

3,289 reads

Investigating Transactions Using Dynamic Management Objects

by Additional Articles

SimpleTalk

transactions

There can be a great difference in the performance of a particular routine in a test database, and in a fully loaded production system. When you hit performance problems in a database under load, and there is excessive locking and blocking, how can you determine exactly where the problems lie, in order to fix them?

2010-10-22

3,228 reads

Notifications for SQL Server Agent Restarts

by Additional Articles

SQL Server Performance

SQL Server Agent

This article demostrates how to set up email notifications for SQL Server Agent Restarts.

2010-10-21

1,926 reads

Add Some Spark to Your OData: Creating and Consuming Data Services with Visual Studio and Excel 2010

by Additional Articles

CODE Magazine

oData

The Open Data Protocol (OData) is an open REST-ful protocol for exposing and consuming data on the web. Also known as Astoria, ADO.NET Data Services, now officially called WCF Data Services in the .NET Framework. There are also SDKs available for other platforms like JavaScript and PHP.

2010-10-20

1,918 reads

Robyn Page's SQL Server String Manipulation Workbench

by Additional Articles

SimpleTalk

String Manipulation

String searching and manipulation in SQL Server can be error-prone and tedious...unless you're armed with the techniques described in Robyn's string manipulation workbench, here newly revised with extra material from collaborator Phil Factor

2010-10-19

4,427 reads

Create a Performance Baseline Repository

by Additional Articles

SQL Server Performance

Performance Tuning

This article demostrates how to create a Baseline repository that holds summarized data of all SQL Executions executed on an instance of SQL Server.

2010-10-18

2,532 reads

Manage Database Projects With Visual Studio 2010

by Additional Articles

SQL Server Performance

Database projects

This article demonstrates how to manage database projects with Visual Studio 2010.

2010-10-15

4,254 reads

Policy-based Management and Central Management Servers

by Additional Articles

SimpleTalk

Policy Based Management (PBM)

Whilst it may be more exciting as a DBA to rush around fixing broken databases, it is far better to forestall problems by making sure that your servers conform with best-practices. It is even better if you can also manage your servers centrally, and monitor that they are all adhering to company policies.

2010-10-14

2,380 reads

All authors

Additional Articles

State Transition Constraints

Top 10 Mistakes When Building and Maintaining a Database

Introducing ADO.NET Entity Framework

Investigating Transactions Using Dynamic Management Objects

Notifications for SQL Server Agent Restarts

Add Some Spark to Your OData: Creating and Consuming Data Services with Visual Studio and Excel 2010

Robyn Page's SQL Server String Manipulation Workbench

Create a Performance Baseline Repository

Manage Database Projects With Visual Studio 2010

Policy-based Management and Central Management Servers

Blogs

Are you getting value from your reporting?

The Book of Redgate: SQL Server Central

Git forked

Forums

Microsoft Security Changes and SQL Server

Expanding into Print

Downtime Caused by the Postgres Transaction ID Wraparound Problem

Question of the Day

The String Distance I