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 ...

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database.

Each version of Microsoft ’s SQL Server comes with five years of full support, followed by five years of security-only updates. Here are five questions to ask as your version hits the five-year mark: ...

In part 1 of my SQL Server 2022 features series, you learned about the improvements to the cardinality estimator component of query optimization. In this installment, you will learn about another ...

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 ...

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 ...