SqlCredit – Part 17: Exploring SQL 2005’s OUTPUT Clause7/25 SQL Server 2005 introduces the OUTPUT clause, a bit of magic that allows us to get the identity value, plus a number of other values, from an INSERT, UPDATE, or DELETE, which all have different interaction with OUTPUT. This article concentrates on INSERT.
SQL Server 2008 MERGE Statement7/24 With a single MERGE statement, you can easily implement insert, update, and delete logic to handle criteria for maintaining a table. Read on to learn how to use the MERGE statement.
Oracle Reports for DBAs7/23 As an Oracle DBA you might think that Oracle Reports have nothing to do with you, and you might be missing out on a simple means of generating reports to identify a source file, create an external table, write an SQL script and more.
Intrinsic Member Properties: The MEMBER_NAME Property7/21 MSAS
Architect Bill Pearson introduces the intrinsic MEMBER_NAME property. In
hands-on exercises, we gain exposure to the use of the property in generating
simple lists, as well as datasets to support report parameter picklists.
BakBone Gets Into Recovery7/24 BakBone Software has unveiled a new data protection solution that promises recovery in as little as 30 seconds for Exchange, SQL Server and Windows file system data.
Web 2.0 fuels open-source database boom7/23 The market for open-source databases is booming due to new workloads such as RFID projects, rich web applications and small portals, despite the unwillingness of enterprises to replace their Oracle, DB2 or SQL Server systems with open source, according to new figures from Forrester Research.
DTS Package for Reporting Low Disk Space This VBscript code will check for low disk space on the local SQL Server. The script will check all disks except the C: drive and will trigger an alert to be sent via e-mail when the available disk space on any drive falls below 20%.
Database Lock Information Look for Object Name and for how long the Lock has been there (Locked Time in Sec).
