Vote NOW in the 2009 Community Choice Awards!
Windows IT Pro and SQL Server Magazine are proud to announce that the 2009 Community Choice Awards are now open for final voting. Click the link above to begin voting for your favorite IT products and services. Voters also have a chance to win a $250 gift card and other prizes!
Live Seminar: WS08R2 Improves TCO in Your Data Center
Nov. 12 - Join Mel Beckman to learn how Windows Server 2008 R2 helps with your SQL deployments on Hyper-V and find out about a “cash for clunkers” server promotion that runs through the end of 2009.
Save 25% on the SQL Server Magazine Master CD!
The SQL Server Magazine Master CD is where content meets convenience. Get the expertise from SQL Server Magazine loaded onto a CD for speed and portability. Also includes web access!
The Inevitable Virtualization of SQL Server
Improvements in performance and scalability in ESX Server and Hyper-V are making SQL Server a viable candidate for virtualization.
Calculating Concurrent Sessions, Part 1
Itzik discusses a set-based and a cursor-based solution to a T-SQL concurrent sessions querying problem, as well as the performance and scaling ramifications of both solutions.
Getting Started with BI
Despite the fact that SQL Server’s BI capabilities have been around for more than 10 years many SQL Pros don't use them. So what’s so hard about BI? I think you can sum it up with the three Ts: terminology, technology, and tools.
Date and Time Support in SQL Server 2008
Four new date- and time-related data types in SQL Server 2008 address the limitations of previous versions’ DATETIME and SMALLDATETIME data types.
7 Facts About SQL Azure
Get the basics on SQL Azure, formerly SQL Data Services, Microsoft’s SQL Server-based database cloud offering.
T-SQL Classic Date Functions
These 7 essential T-SQL functions work with SQL Server’s classic datetime data type and can help you in myriad ways.
SQL Server 2008 R2: 5 Cool New Features
Support for 256 logical processors, a new Master Data Services feature, and BI-oriented Project Gemini are some of the SQL Server 2008 R2 features in our top five list.
Minimally Logged Inserts
Learn which insert methods can benefit from minimal logging, to improve your statements' performance.
The Microsoft Release Tsunami
Mike Otey looks at the lengthy release line-up from Microsoft in 2009 and 2010 and considers the value of moving to SQL Server 2008 R2. Is a BI-focused release for you?
Using Nested Iterations and the OVER Clause for Running Aggregates
Until SQL Server supports the OVER clause, your best solutions for running aggregates are a set-based solution using subqueries or joins, for very small partition sizes, or a CLR data reader–based solution, for large partitions.
BlogsGo to the Blogs Index Page
Industry Bytes
SQL PASS Summit 2009: New SQL Server 2008 R2 Editions Announced
Announcements from keynote: Nov CTP. New editions: SQL Server 2008 R2 Datacenter and SQL Server 2008 R2 Parallel Data Warehouse
Comment on the blogRead this blogPuzzled by T-SQL
Virtual Auxiliary Table of Numbers
Itzik provides code to generate a virtual auxiliary table of numbers efficiently.
4 CommentsRead this blogSQL Server BI
Attunity Launches Suite of Real-Time Data Replication Technologies
Precursor to PASS Summit Announcement
Comment on the blogRead this blogIn a Nutshell
SubscribeLearn More Here
 
|
November 2009Securing Your SQL Server Environment• 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 implementing Windows 7 in your environment?
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
