Best of Tech Ed 2009 Winners Announced!
Editors from Windows IT Pro and SQL Server Magazine announced the winners of the Best of Tech Ed 2009 Awards at Tech Ed 2009 in Los Angeles earlier this week. Click the link above to see the list of winners and a finalist video compilation. Congratulations to all the winners and finalists!
SQL Server Unleashed, free virtual event
Unleash SQL Server's Full Potential to Maximize ROI. Join us on September 15, 2009. Sessions will be led by SQL Server expert, consultant, and author Michael K. Campbell.
Register for SQL Connections and receive SQL Server 2008 Standard Edition with 1 CAL
Join us November 9-12, 2009, as SQL Server Connections returns to the Mandalay Bay Casino and Resort in Las Vegas, NV. Early bird rate until August 15th - save $100!
8 SQL Server 2008 Downloads
From SQL Server 2008 SP1 to SQL Server Express to SQL Server 2008 Upgrade Advisor, our 8 favorite downloads should find a place in your SQL Server toolbox.
The New Oracle Threat
Oracle recently announced a surprising acquisition of Sun Microsystems. Unlike the aborted IBM-Sun merger, this one makes a lot of sense. Oracle is a technology leader, and Sun will strengthen Oracle in a number of fundamental ways.
Best of TechEd 2009 Award Winners
The Best of TechEd Awards recognize the most innovative products and services offered by Microsoft partners that exhibited at TechEd 2009, held in June 2009 at the Los Angeles Convention center. Here are our winners!
CLR-Based Solution for Running Aggregates
If performance is your main goal, you should use the set-based solution only with very small partition sizes; otherwise, you should use the CLR-based solution.
Set-Based vs. Cursor-Based Solutions for Running Aggregates
Although set-based solutions to running aggregations have many advantages over cursor-based solutions, cursor-based solutions can provide better performance in certain cases, such as when dealing with very large partitions.
Using SQL Server 2008's FILESTREAM Data Type
The FILESTREAM data type in SQL Server 2008 is a valuable way to access data--here's a quick primer.
Get Ready for SQL Server 2008 SP1
In the Community Technology Preview (CTP) for SQL Server 2008 SP1 you’ll find a couple of important changes in the way that service packs are applied and used as well as some important new functionality for SQL Server 2008.
SQL Server Management Studio Keyboard Shortcuts
Put these SSMS keyboard shortcuts by your computer and quickly connect to, navigate through, and manage in SSMS.
Data Access Options in VS 2008 and the .NET Framework 3.5
New data-access options in VS 2008 and the .Net Framework 3.5 SP1 include LINQ to DataSet, ADO.Net Data Services, and SQL Server Data Services.
BlogsGo to the Blogs Index Page
Industry Bytes
NovaView 6.0 Can Connect to Any Data Source
Panorama Software's NovaView 6.0 includes a new Flash Analytics client, Relational Data Connector, and NovaView SharedViews.
Comment on the blogRead this blogIndustry Bytes
Backup Solution Aims to Help DBAs Turned Accidental SharePoint Admins
A SharePoint backup and recovery solution that might leave you more time for your other duties, like being a DBA.
Comment on the blogRead this blogPuzzled by T-SQL
Solutions to Logic Puzzle - Dice Substitute
Itzik covers solutions to last week’s logic puzzle – Dice Substitute.
1 CommentRead this blogIn a Nutshell
SubscribeLearn More Here
![]() |
July 2009Running SQL Server on Hyper-V Subscribe Renew Current Issue Archive Monthly Online Pass & Digital issue Master CD |
WhitepapersGo to the Whitepapers Index Page
Download Microsoft SQL Server whitepapers from top vendors and research firms. .
SQL Job Openings
Instant Poll
Are you ready to move SQL Server to the cloud?
DownloadsGo to the Downloads Index Page
13 Things You Need to Know About SQL Server 2005
Learn what's in SQL Server 2005 and what's out.The Argent Guardian easily beats out MOM in all our tests
OS: Microsoft Windows 200x and UNIX Company: Argent ®
More Downloads Here




