databasejournal.com databasejournal.com

Top 10 Features of SQL 2008 R2

Introduction Microsoft SQL Server 2008 R2 is the latest release of SQL Server. This article will introduce the top 10 features and benefits of SQL Server 2008 R2. The “R2” tag indicates this is an intermediate release of SQL Server and not a major revision. However, there are a number of interesting new features for both DBAs and developers alike. At the time of this article, R2 is available as a CTP (Community...

databasejournal.com databasejournal.com

SQL Azure TSQL

Introduction Microsoft now offers a “cloud” version of SQL Server called SQL Azure. Cloud in this context means SQL Server lives out on the internet, on equipment managed by Microsoft. We access SQL Azure as a service over the internet either programmatically with Dot Net, or through the command line using SQLCMD. SQL Azure is very similar to traditional SQL Server and now supports many standard TSQL commands. This...

databasejournal.com databasejournal.com

Cloud Database with Microsoft SQL Azure

Introduction SQL Azure is a cloud database system offered by Microsoft. Originally, the product was called SQL Data Services or SDS. It has now been rebranded and its features have been expanded. One of the new features, and the focus of this article, is the ability to manage, create, and manipulate the cloud database using TSQL. TSQL (Transact Structured Query Language) is SQL Servers native language for database management. ...

databasejournal.com databasejournal.com

DML Triggers in SQL Server 2008

Introduction Triggers are stored TSQL code that is used to automatically perform a task when some type of SQL Server action occurs. As their name implies, a Trigger is triggered or set off by some monitored action. These monitored actions can be one of three categories: DML, DDL, or a Logon Event. A DML (Data Manipulation Language) trigger fires when an Insert, Update, or Delete statement is performed. DDL Triggers (Data...

databasejournal.com databasejournal.com

Flat File Imports with SQL Server Integration Services 2008

Introduction SQL Server 2008 includes a powerful data integration and transformation application called SQL Server Integration Service (SSIS). One of the main functions of SSIS is to move data into and out of SQL Server. The external data source can exist in almost any format, another database, Excel sheet, XML file, or a plain text file to name just a few. Not only can data be moved from source to destination, but it can be...

databasejournal.com databasejournal.com

Cloud Computing with Google DataStore

Introduction DataStore is a database web service offered by Google.com as part of their App Engine development stack. The App Engine can be used to build and host web applications. DataStore is a non-relational cloud database that can be used along with the App Engine to store any data needed by the application. This article will examine how the DataStore is accessed, populated, and queried. What is Cloud Computing? Wikipedia...

databasejournal.com databasejournal.com

Working with Amazon Simple DB

Introduction This article explores the concepts and methods necessary to create, manipulate, and work with Amazon Simple DB. Simple DB is an internet (cloud) based web service provided by Amazon. Working with Simple DB requires an understanding of some concepts not usually present when dealing with traditional databases. For starters, there is no management console, or graphical interface for interacting with Simple DB. ...

databasejournal.com databasejournal.com

SQL 2008 Backup and Restore Part 1

Introduction In this article, we’ll examine backing up and restoring SQL Server databases. In addition to covering standard backup options such as Full Backups and Differential Backups, new SQL Server 2008 features such as Backup Compression will be introduced. Backing up from the SQL Server Management Studio as well as from the command line will be demonstrated. We’ll also cover backing up the System databases in addition...

databasejournal.com databasejournal.com

SQL Server Management Studio Reports and Dashboard

Introduction SQL Server 2005 and SQL Server 2008 provide graphical reports for monitoring system health and performance. While there have always been various queries, stored procedures, and of late, Dynamic Management Views, to gather system statistics, none were graphical. These new reports provide a quick easy way to print off a professional looking report for presentations or discussions. This article will examine the built in...

databasejournal.com databasejournal.com

Storing Images and BLOB files in SQL Server

Introduction This article explores the data types and methods used for storing BLOBs (Binary Large Objects), such as images and sounds, inside SQL Server. Legacy data types used in SQL Server versions 2000 and SQL 2005 will be examined as well as the new SQL 2008 FILESTREAM binary type. What are BLOBs To start, we’ll compare two types of files, ASCII and Binary. Most of the values stored in SQL Server consist of ASCII (American...