(Greg Robidoux) Like any IT project, having a good plan is always the best approach. Here is a guide for the things to consider when putting together a SQL Server backup process for your company. It is broken into planning, development and testing, and implementation. Consider the items as an overal

(Vijay Kumar) A Microsoft SQL Server database is a collection of objects that hold and manipulate data. A typical SQL Server installation has only a handful of databases, but it’s not unusual for a single installation to contain several dozen databases. Theoretically, one SQL Server installation can

(Arthur Fuller) Do you worry that someone with devious plans could break into your SQL Server database? If not, you should because this may be a very real and dangerous possibility. First, I’ll cite an example from a previous job to demonstrate how easy it is to access a database.

(Kimberly L. Tripp) Although partitioning tables and indexes has always been a design tactic chosen to improve performance and manageability in larger databases, Microsoft SQL Server 2005 has new features that simplify the design. This whitepaper describes the logical progression from manually p

(Marcin Policht) One of the concepts introduced in the previous article of our series discussing SQL Server 2005 Integration Services were events. While we initially looked at them in the context of Windows Instrumentation Management (which, in turn, serve as the basis of operations for SSIS WMI Eve

(Brian Walker) This tip continues the system stored procedure series with a routine to execute T-SQL code from a file. (R)

(Mike Ruthruff) There are many considerations that need to be evaluated when determining how to approach the consolidation of many SQL Server databases on a single server. One important consideration is whether to use a 64-bit platform or a 32-bit platform to get the best consolidation results.

(Alexander Kuznetsov) Creating a non-clustered index that contains all the columns used in a SQL query, a technique called index covering, is a quick and easy solution to many query performance problems. Sometimes just adding a column or two to an index can really boost the query’s performance. Chec

(Jeremy Kadlec) In preparation for the SQL Server 2005 launch this November, I recently conducted a survey of Edgewood Solutions’ customers, asking them what they consider to be the most valuable features in Microsoft’s new database release. One common response across all positions, industries, comp

(Larry Chesnut) Well, it certainly has been awhile since my last blog. In that time we have seen several conferences come and go: PDC, PASS, and the HP Tech Forum (which I just got back from). At these conferences, Microsoft has laid out before us a lot of great knowledge –and even some breaking ne