DatabaseJournal.com Staff

by Shailesh Khanal We all like the Generate Script feature of Enterprise Manager and like to use it programmatically. One of the most important uses would be backing up scripts periodically using SQL Server Scheduler. Enterprise Manager calls SQL Server DMO (Distributed Management Objects) to generate scripts for the objects you select from the GUI. […]

by MAK [Muthusamy Anantha Kumar] With SQL Server 6.5, Microsoft gave us an opportunity to do a backup (DUMP Table) of the tables. However, after 6.5, with both 7.0 and 2000, that feature has been removed for some reason. Here is a stored procedure that I wrote which gives similar functionality for backing up table […]

>>Script Language and Platform: SQL Server 2000 ,SQL Server 7.0 Given any date,this function/procedure will accurately return the date of the previous Friday. This can be used in DTS ,Job or other query purpose.It can be used to get data of last Friday for statistic analysis or data comparison. Author: Claire Hsu /* * Script […]

by Sreeram Surapaneni Extract Recent studies show that nearly 50% of system outages are due to human errors. The ability to recover from these user errors using a simple, easy to use interface is challenging. Most database products today do not offer any solutions, thus administrators have no option but to recover the database using […]

[From SQL Server Magazine] Have you scaled out a system with SQL Server 2000’s federated database support or implemented OLAP or data mining to give decision makers the power to analyze data? Have you used SQL Server’s XML functionality to develop Web services and platform-independent applications. SQL Server DBAs and developers often create innovative technical […]

[From Informatica] REDWOOD CITY, Calif., May 5, 2003 – Informatica Corporation (NASDAQ: INFA), a leading provider of business analytics software, today announced that the latest release of the Informatica PowerCenter data integration platform delivers breakthrough load performance for IBM DB2 Universal Database Enterprise Server Edition software. At a time of skyrocketing data volumes, unique data […]

>>Script Language and Platform: MS SQL 2000 Datetime coversion is always a headache for SQL technical users. Through this function, you can get the most legible way of representing the date. It can be applied on any single day, any table with datetime field columns. Author: Claire Hsu create function dbo.date(@date datetime) returns varchar(20) As […]

[From Oracle Technology Network] A potential security vulnerability has been discovered in Oracle Net Services for the Oracle Database server. A knowledgeable and malicious user can cause a buffer overflow in an Oracle database link that may result in a Denial of Service (DoS) attack and/or the execution of arbitrary code against the Oracle Database […]

[From CRN] Oracle Monday plans to demonstrate new enterprise management features of its next-generation database. At the IOUG Live 2003 conference here, the company will show how the upcoming database will make it “even easier to manage databases and make our Enterprise Manager tool more powerful to manage across whole collections of databases,” said Andy […]

>>Script Language and Platform: SQL Server This function returns the position of a character in a given string. Author: STLSegwayAdmin Download Script: udf_CharIndex.sql Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in these pages, however, is at your sole risk. All information on […]

by MAK [Muthusamy Anantha Kumar] It is imperative to change the server name when infrastructure policy changes, naming convention standard changes or making a standby server the production server (when production server fails). When a server name is changed, SQL server should go through a process to acknowledge and assimilate the change in server name. […]

[From EMS HiTech] MySQL Manager for Windows 2.3 released. New Transfer Database Wizard, extracting metadata from Database Designer, and other improvements… The newest version of MySQL Manager for Windows 2.3 is immediately available on the Download Page. Version 2.0 features: Visual Database Designer – designing your database takes seconds! MDI Interface – Microsoft Office Style […]