SQL Server Articles


Categories : Performance | Audit | Business Intelligence | Clustering | Developer | Reporting | Windows Server | SQL Azure | Powershell | ASP.NET | Other .NET

Optimizing Microsoft SQL Server Analysis Services: Optimization Tools: Usage-Based Optimization Wizard

About the Series This is the third article of the series, Optimizing MSSQL Server Analysis Services. The primary focus of this series is the introduction of optimization tools and concepts for MSSQL Server Analysis Services (“MSAS”). The series is designed to provide hands-on application of the fundamentals of MSAS optimization from multiple perspectives. As we progress […]

Optimizing Microsoft SQL Server Analysis Services: Optimization Tools: The Storage Design Wizard

This is the first article of the series, Optimizing MSSQL Server Analysis Services. The primary focus of this series will be the introduction of optimization tools and concepts for MSSQL Server Analysis Services (“MSAS”). The series is designed to provide hands-on application of the fundamentals of MSAS optimization from multiple perspectives. As we progress through […]

Some Useful Undocumented SQL Server 2000 Trace Flags

In this article, I want to tell you what should you know about some undocumented SQL Server 2000 trace flags, and how you can use them for administration and monitoring of SQL Server 2000.Trace flags are used to temporarily set specific server characteristics, or to switch on or off a particular behavior. You can set […]

How to Perform a SQL Server Performance Audit

If you have been a DBA for long, then you will know that performance tuning SQL Server is not an exact science. And even if it were, it would still be difficult to find the “optimal” configuration for the “optimal” performance. This is because there are few absolutes when it comes to performance tuning. For […]

An Exclusive Interview with David Gugick, SQL Server Performance Expert and Software Developer

Tell us a little about yourself.I’m the president of Intrinsic Design, Inc., a software company dedicated to writing database analysis software for Microsoft SQL Server. After receiving my electrical engineering degree from the University of Michigan back in 1989, I took that knowledge and entered the world of software development. Initially, the database world was […]

Replicating Stored Procedure Execution

In OLTP environments, you often find batch jobs that move historical data to archive tables. In addition, there are often some batch jobs that purge historical data from the OLTP tables. These types of jobs can perform a lot of transactions and create additional overhead for the OLTP system, hurting overall performance, especially if you […]

Interview with Carl Speshock, Author of the Microsoft SQL Server 2000 Database Administrator’s Guidebook

Find Out More About This Book From Amazon.com Carl Speshock has been a DBA in the Houston area for over 6 years, and is moving back to Oregon, although he will continue to maintain some presence in Texas. Most recently, he has consulted to Shell Oil Products USA and Shell Services International. In addition to […]

Kerberos Protocol Transition and Constrained Delegation

That title’s quite a mouthful, huh! Let’s start by explaining what we’re actually trying to achieve here. Actually, before we start, let’s just say that this paper shows you how I implemented protocol transition and constrained delegation with SQL Server and IIS, and it is not intended to be an exhaustive study of the subject. […]

Sonasoft

Disaster recovery is an important topic to DBAs. In this interview with Dr. Vas Srinivasan, Vice President of Marketing of Sonasoft.com, makers of SonaSafe for SQL Server, you will learn about the importance of SQL Server backups and disaster recovery. Tell us a little about Sonasoft, and what its mission is. Sonasoft’s vision is to […]

An Interview with Simon Galbraith, Marketing Director of Red Gate Software, on Major Trends in the SQL Server Market

What do you see as the major trends affecting the SQL Server market? SQL Server is becoming one of Microsoft’s biggest businesses. As it becomes bigger and more important, I think we’ll see a number of changes that affect users, Microsoft, and the market in which Red Gate participates. The main market for SQL Server […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |