In one of our previous blog post, we had covered how to rename objects in SQL Server. Today we will cover how we can rename the database in SQL Server. In order to rename the database, we need to first put it in a single user mode. We will start with creating a test database first. Connect to Query
Other News
Execute SQL statements in Integration Services
(Tim Chapman) Executing SQL statements is one of the easiest and most common tasks that occur in SQL Server 2005 Integration Services (SSIS). This tutorial walks you through the process of adding SQL statements to your SSIS packages and bundling them into logical units of work if necessary.
The SQL Server Commodity – Feedback…
Featured Article(s) Troubleshooting SQL Server 2005 Merge Replication (Part 2) In this article, Alexander Chigrik explains some problems that you can have when you work with SQL Server 2005 merge replication. He also tells how you can resolve these problems. Virtual Server Protection and Recovery Building out your infrastructure with virtual servers brings with it the requirement that you be […]
Is SQL Server A Commodity Service Now?
Featured Article(s) Understanding Software Testing (Part III) This is the last and concluding part in this series of three part articles on Software Testing. In this part we will discuss few other types of testing methodologies. Webcast Today Performance Monitoring, Scaling and Watching Over Your SQL Server. We’ll look into pulling baseline information, things you can do to chart and […]
XML in DB2 LUW
In one of our previous blog post, we had covered, how in Oracle can we convert relational data to XML in vice-versa. Today we will get basic familiarity with XML functions in DB2 LUW. IBM has also provided very strong XML support in DB2 LUW. DB2 LUW contains certain built-in SQL/XML functions which
Athens, DB2, and Application Development
(Robert Catterall) I am writing this post in Athens, Greece, where I am participating in the 2007 International DB2 Users Group (IDUG) European Conference. I have been to a number of IDUG conferences over the years, in various parts of the world, but the 2007 Athens event has been, for me, one of th
XSLT and XSS attacks
(Oleg Tkachenko) I noticed Robert Robbins was writing about XSS attacks using XSLT: It is possible to extend the power of XSLT using JavaScript embedded into the XSL file. Therefore any web application that allows the user to upload their own XSL file will be vulnerable to Cross Site Scripting at
How MySQL replication got out of sync
(Xaprb) I created MySQL Table Checksum because I was certain replication slaves were slowly drifting out of sync with their masters, and there was no way to prove it. Once I could prove it, I was able to show that replication gets out of sync for lots of people, lots of times. (If you really want to
How to Recover Deleted Oracle Datafiles with No Downtime
(Christo Kutrovsky) So you have accidentally removed a datafile from your production database? First thing, DON’T PANIC! There’s an easy way to recover deleted datafiles, for as long as your database remains up. The procedure below works on linux, however this method conceivably can work for other p
IBM Data Studio: Get started with Data Web Services
(Michael L. Pauser) The IBM Data Studio solution includes many new features, among these is the Data Web Services support. Data Web Services is the next generation Web service provider for IBM database servers. Data Web Services provides a full Web service interface, that supports both REST-style (H