(Andrejus Baranovskis) If you are building mobile application with web service call integration, you must take into account data caching strategy. Without data caching, mobile application will try to establish too many connections with the server – this will use a lot of bandwidth and slow down mobi
Other News
DB2 Tips n Tricks Part 42 – How to Identify DB2 Client Release Version from Server
(Harishkumar Baburao Pathangay) How to Identify or Monitor DB2 Client Release Version from DB2 Server Solution:
Using indexed views on ANY core SQL server edition
(Arthur Olcot) I was having a discussion the other day and was quite surprised to hear that there still appears to be a slight misconception regarding being able to use indexed views on web or standard editions of SQL server.
Automate Database Restore
(David Dye) On several occasions I have been required to restore a database from production to development or test. The requirements are that I must restore
Automated Source Control: A Librarian For Your Database Objects, Part 2
(Tracy McKibben) I assume that by now you’ve tried the script from Part 1, and have seen how easy it is to script out your database objects using Powershell. The resulting scripts are the standard DDL scripts that you can generate from Management Studio, and for most of us, are just fine right out
Usage of DBCC OPTIMIZER_WHATIF for SQL Server Query Tuning
(Daniel Farina) You need to tune a query on a non-production server. To do this, you have exported database statistics and loaded them onto a development environment.
Putting Virtual Columns to good use
(Anders Karlsson) We all know that in general it’s a bad idea to have columns values contain too much “hidden” information, and in particular for primary keys, this is a big no-no, although I know that not everybody agrees here.
Modern Persistence
Here’s an old topic with a new twist. Back in the old days we used to worry about using Engine Specific sql code on order to be able to port an application to another database engine than the one on which it was developed. The way you did this was to use (as much as possible) only ANSI syntax in […]
11: Deployment Models
Pro-Center Video Programming for IT Professionals
10: Data Quality Services and Master Data Services
Pro-Center Video Programming for IT Professionals