Developers working with SQL Server often treat indexing as a DBA's domain--something happening "under the hood" that doesn't require much attention unless performance takes a hit. But ignoring the ...

Described as an advanced course designed for advanced SQL Server professionals, the course will feature detailed demonstrations of SQL Server internals, as well as tuning techniques, utilizing SQL ...

I made the long trek across the country this week to attend my favorite conference, the SQL PASS Community Summit, this year in Seattle, and so far it’s been well worth it. I usually arrive early to ...

CHARLOTTE, N.C.--(BUSINESS WIRE)--SentryOne today announces new editions of SQL Sentry, the company’s top-rated database performance monitoring product, to help companies select the monitoring ...

SQL Server 2005 also promises better performance. I didn’t run performance benchmarks for this review, but in addition to allowing DBAs to partition the database to balance load, Microsoft has done a ...

The daily routine of an IT professional remains largely reactive. A lot of time and budget is spent responding to tickets, limiting the time that we spend creating systems that drive growth and ...

Recently, I was speaking at a SQL Saturday event (www.sqlsaturday.com), when I encountered a question that I've been getting more and more often. It went something like this: "I know that I can look ...

Despite its steep licensing costs, SQL Server continues to prove its worth over open-source alternatives in some key areas. SQL Server is an expensive part of your IT stack -- SQL Server Enterprise ...

Using Access to build a front end for SQL Server Your email has been sent What are the advantages of using Access as the front end to a SQL Server database? For starters, it's likely that your ...