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.
Focus on Popular Objects to Speed up an Access 2007 Database7/18 Garry Robinson outlines how usage data can make the quest to speed up an Access database more focused. The article also delves into an Access 2007 ACCDB only feature called TempVars.
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).
