(Bru Medishetty) I am a SQL Server Database Administrator responsible for multiple SQL Servers. To perform administrative tasks on these SQL Servers, I login to those servers, using Remote Desktop. In doing so, my desktop is overlapped with the remote Server’s desktop. This causes an inconvenience

(Jason Thomas) A quick tip for the beginners. Most of you would be familiar with substring searches in SQL. Today, we will see how to replicate the same scenario in MDX.

(Jim Duffy) Sometimes an application needs to have every last drop of performance it can get, others not so much. We’re in the process of converting some legacy Visual FoxPro data into SQL Server 2008 for an application and ran into a situation that required some performance tweaking.

(Gregory A. Larsen) This is the final installment in my Index Guidelines series. If you have been following this series, I have covered many different aspects of indexing, like having an index development lifecycle, to the order in which columns should be placed in your indexes. In this article, I w

(Joe Sack) I’ve used DDL Triggers before to prevent database DROP DATABASE operations. For example:

(Mohammed Moinudheen) In most companies, roles and responsibilities are clearly defined for the various teams, whether it is the database team, application team or the development team. In some cases, the application team might own a number of jobs but they may not have direct access or the high lev

(Alejandro Xalabarder) When working with relational databases, it is almost impossible not to talk about SQL. With this language a huge variety of operations and queries can be performed on a database and, depending on its implementation and use, in a very efficient way. Nevertheless, although it is

(Siddharth Mehta) Error handling is one of the aspects of SSIS that is given quite low attention in terms of recording error data at different stages of the transformation. One of the reasons for this is that at different stages of the transformation, the metadata stream keeps on changing it’s shape

(Suprotim Agarwal) To get an accurate value of all the rows in a SQL Server table, use DBCC UPDATEUSAGE. DBCC UPDATEUSAGE corrects the rows, used pages, reserved pages, leaf pages and data page counts for each partition in a table or index.

(Buck Woody) When you think about it, there are really just three functions in enterprise computing: processing, storage and reporting. That may sound a bit oversimplified, but in fact your users have various methods for creating and manipulating data (processing), the data they create is retained i