The riders in the Tour de France are probably the most monitored athletes in the world. In preparation for the race, every ounce of food a rider consumes is specially formulated to give him maximum ...

OK, I’ll admit it. I’m not a DBA, but that doesn’t mean I haven’t overseen databases and their performance. I was (and probably still am) the guy who installed a Microsoft SQL database by hitting Next ...

The annual PASS Summit, the industry’s largest gathering of SQL Server professionals, hosted more than 4,000 attendees in Seattle recently recently. PASS (www.pass.org) has grown to more than 300 ...

Microsoft on Thursday released Service Pack 3 (SP3) for SQL Server 2008. The new service pack arrives about one year after the release of Service Pack 2. SP3 contains a lot of fixes to the earlier ...

As any database admin knows, mastering the subtler nuances of SQL can be likened to the black arts. For me, tuning the efficiency of SQL queries on large, heavily used databases is a perfect example.

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

In SQL Server 2005, Microsoft introduced the Upgrade Advisor. This was a great idea to be able to analyze your current SQL Server in a safe environment and start the planning process of an important ...

SQL Server 2022: Here’s what you need to know Your email has been sent TIOBE Index: Top 10 Most Popular Programming Languages WWDC: Apple Unveils Unified Design Language and Built-In AI Tools for ...