(Greg Robidoux) Some primary things that should be done on every SQL Server include daily backups and routine scheduled maintenance. Backups are common practice ensuring that if there is data loss you are able to restore it. Maintenance tasks, i.e. integrity checks ensure your database is running as
Author: SSWUG Research
A (very) simple XSLT test utility
(Riaan Hanekom) With the advent of XML, XSLT has received widespread recognition and use for presenting a human readable view of XML. I’m not going to go in depth into XSL(T) and XML – you can find a LOT of resources by googling.
Relational Database Principles (Sample Chapter)
In this chapter, we will examine what makes a database system, particularly a relational one like PostgreSQL, so useful for real-world data. We will start by looking at spreadsheets, which have much in common with relational databases but also have significant limitations. We will learn how a relat
Decorate Your Code with Astonishing Attributes
(Rod Stephens) When I first saw attributes in Visual Studio .NET, I thought they were some sort of oddity Microsoft had dragged in from Java, C++, or perhaps the Delta Quadrant. They clearly aren’t Visual Basic code. To someone who uses angle brackets only for comparing two numbers, this Property st
Stored procedure: Determine last database backup
(Michelle Gutzait) An experienced DBA understands the meaning of backups. (R)
Understanding Logical Standby Databases
(Sreeram Surapaneni) Oracle started shipping Standby Database features with the release of Oracle 8.0.4. Standby Database features were enhanced with the help of user feedback in subsequent releases of Oracle. Although there are several ways to set up highly available (HA) databases, including Oracl
Indexing and statistics strategies for DB2 UDB for iSeries
(Michael W. Cain) On any platform, good database performance depends on good design. And good design includes a solid understanding of indexes and column statistics: how many to build, their structure and complexity, and their maintenance requirements. (pdf)
What’s it to You?
(Roger E. Sanders) You’ve probably heard and read a lot recently about DB2 9’s unmatched ability to store XML documents in their native format (in other words, without converting them into large objects or shredding them into tables). This new “pure” method of storage enables quick information retri
Ready-to-use Mass Emailing Functionality with C#, .NET 2.0, and Microsoft SQL Server 2005 Service Broker
(Shahed.Khan) This paper demonstrates an extensible mass emailing framework (Smart Mass Email SME). The demo implementation uses cutting edge .NET technologies available today, such as C#, .NET 2.0, Microsoft SQL Server 2005 Service Broker, MS Provider Pattern, Enterprise Library January 2006 etc.
Making use of INSTEAD-OF triggers in SQL Server 2005
(Tim Chapman) A trigger is a database object similar to a stored procedure that executes in response to certain actions that occur in your database environment. SQL Server 2005 is packaged with three flavors of trigger objects: AFTER, data definition language (DDL), and INSTEAD-OF.