(Arshad Ali) SQL Server 2008 R2 allows its databases to be registered as Data-tier Applications without creating and deploying a DAC package. This article shows you how to register and delete a Data-tier Application using the wizards available in SQL Server 2008 R2 Management Studio (SSMS).
Other News
Implement SQL passthrough with solidDB and DB2 for Linux, UNIX, and Windows
(Amit Bhattacharya) SQL passthrough is a feature in IBM solidDB Universal Cache that allows the application to access data from both the front-end and back-end databases using a single connection. You can configure this feature as the default, or enable it at runtime for a single transaction or for
Uninstalling a SQL Server Clustered Instance
(John Sterrett) I have installed and uninstalled several instances of SQL Server in the past. Today, I need to uninstall a SQL Server 2008 R2 clustered instance. I have never uninstalled a clustered instance of SQL Server before. Can you provide a how-to guide to uninstall a clustered instance of SQ
Leverage Your SQL Server Skills with Third Party Tools
Leverage Your SQL Server Skills with Third Party Tools I decided to take a look in Google to see what tools have the ability to utilize SQL Server database engine for persistence. Most likely, each of these tools benefit from the skills of a savvy DBA for performance, maintenance, and security. I restricted myself to 10 minutes to see what […]
Creating A CFThread-Based Process In ColdFusion In Order To Learn About Concurrency
(Ben Nadel) As I have been going through my Seven Langauges in Seven Weeks book by Bruce Tate, one of the things that keeps tripping me up is the concept of concurrency with processes. Scala day 3 was my first real taste of processes and it completely baffled me.
DB2 Catalog Changes
(Troy Coleman) In the early years dynamic SQL was never used in a production environment. There were several reasons for this, but the biggest was catalog contention. The locks held in any user’s dynamic ad hoc SQL statement could bring down a new version of a program being moved into production.
Oracle11g IGNORE_ROW_ON_DUPKEY_INDEX Hint (Micro Cuts)
(Richard Foote) An interesting new hint was introduced in Oracle11g which provides an alternative approach when inserting data where duplicate values might be an issue.
Introduction to: Linked Data
(Juan Sequeda) I don’t know if you have realized, but the web is evolving from a global information space of interlinked documents into a global information space of interlinked data. But what does that even mean?
What’s new in mk-query-digest: EXPLAIN sparklines
(Baron Schwartz) This month’s Maatkit release has some nice new features and improvements to mk-query-digest. There is one that deserves its own blog post: EXPLAIN sparklines.
Creating Database in SQL2005 and DataStorage
(Sivaraman Dhamodaran) This article shows how do you create a SQL Server 2005 database. Also it explains how the storage is allocated for the db created and explains shortly the files involved in creating the database.