Joey on SQL Server 5 SQL Server Components You Should Be Using Microsoft's rapid-fire release cycle for SQL Server means it's easy for database admins to miss useful new features.

Part 2 of 5 Greetings, last week I initiated this blog series which focuses on best practices and installation strategies when deploying SQL Server 2008.

And if you install SQL Server 2008 CTP, you should know that you can't read SSCE 3.1 files using the 2008 Management Studio. The point to remember is this: VS/SQL2008 = Compact 3.5, and VS/SQL 2005 = ...

Joey on SQL Server Deep Dive into SQL Server 2022's Query Performance Features, Part 2: PSP Optimization Reduce workload times with this handy feature that can benefit every database pro.

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.

A half-baked alternative to Transact-SQL will not make SQL Server or the development process any better and, very likely, will make things worse. As an administrator, I'm putting a lot of eggs into ...

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