Microsoft's rapid-fire release cycle for SQL Server means it's easy for database admins to miss useful new features. Here are some recent additions that might otherwise fly under the radar. Modern ...

Sometimes, life really is like a box of chocolates. The same can also be said for software upgrades. Take, for instance, Visual Studio 2008. After all its various CTPs and RTMs, I feel like I've been ...

Database admins strive to ensure that large chunks of data are both accessible and stored with integrity. By using these programming languages, they can keep systems optimized. As data volumes ...

The Microsoft OLE DB Provider is an SQL tool that enables developers to write code that provides an application with ADO access to an SQL database. The OLE DB Provider is not installed by default when ...

SQL Servers allow the import or export of database diagrams to another database. All the information related to a database is stored in the dtproperties table. Therefore, to import or export a ...