An application that is based on Visual Studio for developing solutions for SSIS, SSAS, or SSRS is called Business Intelligence Development Studio, or BIDS. With SQL Server 2005, it was introduced. It ...

SQL, or the structured query language, is a specialized programming language designed for working with databases. There are a few different variations of SQL from different organizations and projects, ...

The best things in life are free. Sign up for our email to enjoy your city without spending a thing (as well as some options when you’re feeling flush). Our newsletter hand-delivers the best bits to ...

This article is excerpted from the book DevOps Troubleshooting: Linux Server Best Practices and is reprinted by permission of publisher Pearson/Addison-Wesley Professional. Many different problems can ...

Despite the plentiful information in Books Online and on the official “SQL Server 2000 Security” document Microsoft offers online, setting up a truly secure SQL Server remains a difficult task. In ...

Joel Snyder, Ph.D., is a senior IT consultant with 30 years of practice. An internationally recognized expert in the areas of security, messaging and networks, Dr. Snyder is a popular speaker and ...

This step-by-step guide will help you find out who restarted your Windows Server. You can find the user or application that shut down or restarted your Windows Server. This information can be found ...

SQL Server databases often contain precious data such as customer information, financial records, and account passwords—assets that are often both essential to the business and subject to compliance ...

Everyone wants faster database queries, and both SQL developers and DBAs can turn to many time-tested methods to achieve that goal. Unfortunately, no single method is foolproof or ironclad. But even ...

I'm very sad to say that after 5 ½ years I am leaving Quest and, as a result, this will be my last column for Database Trends and Applications. I have greatly enjoyed writing these articles and I hope ...