The fourth article in the advanced SQL series ‘Introduction to MS SQL Server 2000 Analysis Services’ examines another special type of dimension, the Parent-Child dimension, and explores the attributes that make it different from a regular dimension. The article also discusses the considerations that

Answered by Michael Hotek – I neet to get a DB2 Database replicated to SQL Server 2000. I have an OLE Connection and Data Bindings. But even though I have set up a pull subscription through SQLDMO, I can’t seem to get it working.

By Alena Willis – This function can be used to filter sets of data with lists (strings) from any kind of application/Web. I personally use the table that is created to make joins with it on one or more datasets for the purpose of filtering. This function is also useful when modified slightly when yo

Many SQL Server DBAs and developers who have come up through the ranks started out as Microsoft Access developers. In fact, I was one of them. I starting developing in Access with version 1.0, which now seems like eons ago.If you are a current Access developer who wants to learn how to get t

Four vulnerabilities, the most serious of which could enable an attacker to gain control over an affected server.

Alexander Chigrik presents a few UDFs he has developed for getting meta data about your database objects.

By Jo Ticehurst – Users should hold off deploying Microsoft’s next version of SQL Server until the first service pack because of major security concerns, analysts have warned.Yukon, the company’s next SQL release, is due next year, but analyst Gartner has said that it expects it to contain a

How can I update three columns in table A from three columns in table B in one UPDATE statement? Check out the answer!

What do you do when you’re tasked with determining the source of unauthorized modifications to your database? Use SQL Server triggers and let these useful procedures do the work for you.

Alexander Chigrik’s new replication troubleshooting checklist is the first resource you should consult when attempting to diagnose and solve replication-related issues.