(Mladen Prajdiæ) Backing up a database is one of the most important things you need to do when having a database driven application. It ‘s only all of your data in there, right? But often developers and management don’t realize the importance of backups and overall proper backup strategy for the mos
Other News
Differences between Unique and Non-Unique Indexes (Part I)
(Richard Foote) I’ve had a number of comments regarding my earlier blog entry where I recommended avoiding Deferrable and Novalidate constraints unless you need them and consider using Unique Indexes rather than Non-Unique Indexes where possible.
Dealing with Foreign Currency : ‘Conversion’
(Sanjit Anand) This refers to foreign currency transactions that are immediately converted at the time of entry to the functional currency of the Set of Books in which the Transaction takes place.
SQL Server 2005 Data Modeling – Part 1
(Manjusree Akkineni) SQL Server 2005 in addition to its traditional relational database features, also offers extensive data modeling features in a completely different perspective. This article introduces the new data modeling features, how to design dimensions and facts.
Using Report Parameters in SQL Server Reporting Services
(Dinesh Asanka) When you are using reports, you need to have parameters that narrow down your report for better analysis. You will often see that you need to have more than one parameter, where the second parameter may depend on the first parameter, which many require you to refresh the second param
FILESTREAM Data in SQL Server 2008
We have been covering the new features in SQL Server 2008 in some of our blog posts. In some of those, we had also discussed the new data-types in that release. You can search for SQL Server 2008 on this blog site to get to all those posts. In today’s blog post, we will discuss what can be done f
Virtualization, Getting Help with SQL Server and More
Featured Article(s) New Features in ADO.NET (Part III) ADO.NET has introduced many cool features to improve the scalability and performance of data centric applications. With features like provider independent factory models, support for XQuery handling with xml data type and asynchronous processing techniques, the amount of LOC, code complexity and maintenance has been greatly reduced thus helping the developers to […]
SQL Server Virtualization Discussion, Happy New Year!
Happy New Year! 2008 should be interesting… again. With the release of SQL Server, Windows Server, VS and all of the assorted tools and technologies, there is a lot happening that will keep us all watching the releases, the updates, the testing and so-on. I think there will be some great things to come out of both the new products […]
DB2 9.5 and IBM Data Studio: Overview Diagrams, Continued
(Paul Zikopoulos) So far in this series about the IBM Data Studio integrated development environment (IDE) that’s new with DB2 9.5, I’ve shown you how to set up database connection objects and the actions that you can perform on them. In addition, I introduced you (in Part 2) to some of the features
ColdFusion 8 CFloop Array Iteration / XML Bug?
(Ben Nadel) I think I found a bug in the way that ColdFusion 8 handles CFLoop array iteration and XML nodes. I was working with some XML over the weekend (yeah baby, I DO know how to fully take advantage of the holiday weekend!) and was doing some simple XML node iteration like this: