Grouping with SQL Server 20081/05 Don Schlichting examines several SQL Server 2008 grouping functions including GROUP BY, GROUPING SETS, CUBE, and ROLLUP. In addition, he demonstrates how to use SUM and COUNT in a WHERE clause after rows have been grouped.
Conducting Service Broker Conversation Using Full Dialog Security in SQL Server 2005 Express Service12/31 In the previous installment of our series covering the most relevant features of SQL Server 2005 Express Edition, we started an overview of Service Broker full dialog-level security. In this article, we will conclude this subject by describing the remaining prerequisites and a method to invoke a secure dialog.
Simple Bar Chart for Analysis Services Data12/30 Join MSAS Architect Bill Pearson as
he leads the hands-on creation of a simple bar chart based upon an Analysis
Service data source.
Oracle Database 11g: Flashback Transaction Backout12/29 Oracle Database 10g offered two new Flashback features that allowed an authorized user to see all versions of any changes made to one or more rows in a table. Database 11gR1 provides the ability to back out one or more independent or dependent transactions with Flashback Transaction Backout.
ADO.Net Entity Framework By Dan Rigsby
Published December 11, 2008
Utilize the "ADO.NET Entity Framework" to quickly and easilywork with your database, accessing your data in an objectoriented fashion.
WF SQL Tracking Service By Jeffrey Juday
Published November 14, 2008
Learn how to incorporate the SQL Tracking Service into your WF development.
Intro to VSTS-DB Edition By Jeffrey Juday
Published June 26, 2008
See how Microsoft Visual Studio 2008 Team System - Database Edition makes creating and using database functionality easy for .NET developers!
Intro to Databases By Bill Hatfield
Published July 2, 2008
New to databases? Start by learning the basic terminology.
Keeping Active1/06 Use Oracle Active Data Guard to set up a physical standby database for reporting and recovery.
SQL Server Integration Services an Introduction1/06 This article is part 1 of a 4 part series that introduces how SQL Server Integration Services (SSIS) can be used as a platform for building high performance data integration and workflow solutions.
SQL Server Consolidation Initiative Under Way at Microsoft1/05 Microsoft's IT function is currently consolidating its SQL Server environment of around 100,000 databases on 5,000 SQL Server instances to reduce operating and capital expenses as well as to reduce its environmental footprint.
FileMaker (FileMaker, Inc) Database tools for both Mac and Windows platforms targeted to actual end-user (individual and workgroup) creation and implementations. Now with a new UI, Script Triggers, more.
Xeround Intelligent Data Grid (IDG) (Xeround, Inc) Distributed, grid-based database leverages separate query router and data blades joined via a network protocol. Now with support for multiple distribution architectures, including read or write optimized and local/global environments.
Track Table Fragmentation A diagnostic table and stored procedure to track the fragmentation of large tables within databases. The user passes the database name and the table name as parameters to the SP. The SP can be set up to run as a scheduled job every few hours to produce a historical trend of fragmentation.
Script to Transfer Tables to New Filegroups This program will dynamically build and issue drop and alter statements in order to move all the tables in a database to new filegroups.
BIND VARIABLES Handling nulls through the use of bind variables in pl/sql scripts is a tricky task. Here are some examples to handle nulls.
Services running on local MSSQL server The procedure will list code, name and current state of each service that is installed on the machine where SQLSERVER2000 is running.
