Stored Procedure
80 Stories
Finding dependencies in SQL Server 2005
Techguide Get tips on writing a procedure that will look up all the objects dependent upon other objects, and accidentally deleting objects that have dependencies will become a thing of the past.
Tags: Databases
Generate dynamic SQL statements in SQL Server
Techguide Learn to generate on the fly SQL statements, which can be used to solve tricky database problems.
Tags: Database management, Databases, Servers
Diagnose performance issues via sp_lock
Techguide A common misconception among IT pros is that "locks are bad", and you must do everything possible to ensure database locking doesn't prevent processes from running.
Tags: Microsoft Server 2003
Setting up CDC in SQL Server 2008
Techguide Change Data Capture is a new native feature in SQL Server 2008 Enterprise Edition. Here's how to use it to easily set up data auditing on your SQL Server system.
Tags: Databases, Microsoft Windows, Server platforms, Microsoft SQL Server, Table, Database, Raleigh, stored procedure, auditing, Chapman Co.
Defining SQL Server 2008 policies
Techguide Learn how you can use SQL Server Management Studio to define your own policies.
Tags: Microsoft Windows, Data Management, Microsoft SQL Server, Database, Policy, Microsoft SQL Server Management Studio, stored procedure, database engine, Condition, Facet
Run code automatically when SQL Server starts
Techguide Here is an overview of the ways to execute SQL stored procedures or SQL Agent jobs on startup.
Tags: Server platforms, Database management, Databases, Microsoft SQL Server, Database, Tool, SQL, Sarbanes-Oxley compliance, stored procedure, auditing
Use Object Dependencies to your advantage in SQL Server
Techguide SQL Server 2008 tracks objects by the name of the object, rather than relying upon the ID. Here’s how it works.
Tags: Databases, App servers, Server platforms, Object, Microsoft SQL Server, Dependency, Database, SQL, stored procedure, SalesHistory
Two undocumented SQL Server procedures you should know
Techguide Here's a look at how you can use two built-in system stored procedures to iterate through SQL Server tables and databases.
Tags: Servers, Software, Microsoft Corp., Microsoft SQL Server, Backup, Database, Microsoft SQL Server 2000, question mark, stored procedure, Chapman Co.
Using IntelliSense in SQL Server 2008
Techguide Microsoft has finally released a SQL Server product that includes IntelliSense for writing TSQL statements. In this article, Tim Chapman shows the ins and outs of using IntelliSense in SQL Server 2008.
Tags: Database management, Servers, Microsoft SQL Server, Database, Microsoft SQL Server Management Studio, SQL, stored procedure, Microsoft SQL Server Transact-SQL, development environment, text editor
Policy-Based Management in SQL Server 2008
Techguide New to SQL Server 2008 is Policy-Based Management, which gives administrators more control over their database procedures.
Tags: Servers, Databases, Microsoft SQL Server, Database, Policy, Database Table, stored procedure, DDL, Condition, Facet
Drizzle project to trim down MySQL
News The database project is aimed at trimming superfluous functionality from MySQL, creating a smaller, faster version.
Tags: Web sites, Innobase InnoDB, Database, Sun Microsystems Inc., stored procedure, co-founder, business logic, Oracle Corp., Linux, GNU
Web 2.0 fuels open source database boom
News Forrester has found that databases such as MySQL and PostgreSQL are gaining momentum through new markets, despite lack of movement away from existing proprietary installations.
Tags: Web 2.0, Open source, Databases, Forrester Research Inc., Microsoft SQL Server, Open-source Database, Database, stored procedure, Environment, Web 2.0
Perils of adding fields to database tables
Techguide Adding a field to a database table can cause all sorts of problems, if you’re not careful. Read about two such scenarios, and how you can plan for their occurrence.
Tags: Databases, Database management, Storage, Field, Table, Database, Database Table, Sales, Database Table Sale, ProductCode
Configuring SQL Mail in SQL Server 2000
Techguide Steven Warren provides a step-by-step guide on how you can configure SQL Mail in SQL Server 2000.
Tags: Servers, Server platforms, E-mail servers, Microsoft Corp., Microsoft SQL Server, Backup, Database, SQL Mail, Microsoft SQL Server 2000, SQL
Consuming database events in Web applications
Techguide This article demonstrates how you can create and execute DTS packages on Microsoft SQL Server 2000.
Tags: Database management, Web services, Databases
