In This Issue:
SQL Server Compact Edition, which Microsoft released to manufacturing a few weeks ago, is the company’s play to capture the occasionally connected database market. Although SQL Server Compact Edition shares a name with its cousins higher up in the SQL Server family, it’s a fundamentally different product in many important ways.
New Instant Poll: Implementing SQL Server Compact Edition
"Will you use SQL Server Compact Edition?" Go to the SQL Server Magazine home page and submit your vote for:
- We already use it.
- We have plans to use it in the next year.
- We might use it someday.
- We have no plans to use it.
- What is SQL Server Compact Edition?
To ensure that future email messages you receive from SQL Server Magazine UPDATE aren't mistakenly blocked by antispam software, be sure to add SQLServerMag_UPDATE@lists.sqlmag.com to your list of allowed senders and contacts.
Our Sponsors, Who Help Support the Free Delivery Of This Newsletter:
January 25, 2007
1. Perspectives
- An Edition by Any Other Name
2. SQL Server Watch
- Newsletter Highlights Windows Vista
- IT Pro of the Month—December 2006 Winner
- Product Watch: RippleTech and Red Gate Software
3. Hot Articles
- Tip: Avoid Using Trace Flag 2861 to Cache Zero-Cost Query Plans
- T-SQL Black Belt: PIVOT on Steroids
- Puzzled by T-SQL: Palindromes Puzzle
- Hot Threads: PTO and Database Design
4. Events and Resources
- Consolidating SQL Server Deployments
- Put Consolidation on Your Short List
- Enhance Reporting Services
5. Featured White Paper
- The Power of DataWindow in .NET
6. Reader Challenge
- January Reader Challenge Solution: Converting a Hexadecimal String to a Varbinary Value
- February Reader Challenge: Check for an Empty Table
7. Announcements
- Make Your Mark on the IT Community!
- SQL Server Performance-Tuning Articles and Tips
8. Web Community
Sponsor: Dell Computers
SQL Server 2005 in a Virtualized Environment
The Dell scalable enterprise architecture uses industry-standard components to help simplify operations, improve resource utilization, and scale cost-effectively. Virtualization technology is advancing IT infrastructure standards by abstracting software from hardware, which can facilitate deployment and management of software in the scalable enterprise. To demonstrate this, the Dell Scalable Enterprise Technology Center deployed Microsoft SQL Server 2005 software in a virtualized environment.
1. Perspectives
An Edition by Any Other Name
by Brian Moran, brian@solidqualitylearning.com
A few weeks ago, Microsoft announced the SQL Server Compact Edition release to manufacturing (RTM), formally launching the technology that the company is pitching to the mobile and “occasionally connected” workforce. Although SQL Server Compact Edition shares a name with its cousins higher up in the SQL Server edition family, the new edition isn’t the same code base as SQL Server Enterprise, Developer, Standard, Workgroup, or Express editions. The new edition is designed to work with the same programming interfaces—such as ADO.NET—that work with higher-end versions of SQL Server, but SQL Server Compact Edition is a fundamentally different product in many important ways.
Read the full article at: http://www.sqlmag.com/Article/ArticleID/94989/sql_server_94989.html.
Sponsor: FaxBack
Boardless Fax Servers in VoIP Environments
The world is moving toward the future of ubiquitous multimedia communications in which voice, data, video, and fax are deeply integrated. In this free white paper, you'll learn how to integrate fax with leading IP telephony technologies, how hardware-independent fax fits into VoIP environments and more! Download your free copy today at:
http://www.windowsitpro.com/go/whitepapers/Faxback/voip?code=SQLMid0125.
2. SQL Server Watch
Newsletter Highlights Windows Vista
Penton Media, home of Windows IT Pro and SQL Server Magazines, is launching a new email newsletter called Vista UPDATE. Starting February 1, this twice-monthly resource will bring you vital information about Windows Vista, from deployment to security to virtual PC and beyond. Even if your company isn't moving to Windows Vista yet, you'll stay current with what's happening with the help of Karen Forster, author of the ever-popular Hey Microsoft! column in Windows IT Pro magazine. You'll also find desktop and client-side tips and insights from David Chernicoff, and information from Kathy Ivens about what your users need to know—plus Ivens's ever-popular Reader Challenge. If you’re already a Client UPDATE subscriber, you don't have to do a thing to get the new Vista UPDATE. All others, sign up now at http://www.windowsitpro.com/Email/index.cfm?action=Main.
Be sure to whitelist Vista_Update@list.windowsitpro.com to ensure that your new Vista UPDATE isn't mistakenly blocked by antispam software!
IT Pro of the Month—December 2006 Winner
Congratulations to Steven Fellwock, who was voted the December 2006 IT Pro of the Month. Steven successfully improved a logon process by creating a SQL Server database that maintains Active Directory (AD) information. His new logon script never needs modification and is portable—it can run in any AD environment that includes a SQL Server database. To learn more about Steven's solution and to find out how you can become the next IT Pro of the Month, please visit: http://www.windowsitpro.com/go/itpromonth.
Product Watch
by Blake Eno, products@sqlmag.com
Real-Time Database Monitoring
RippleTech announced Informant 2.0, a database- and application-monitoring solution that provides real-time alerts to let you know about unauthorized data access attempts and gives you an audit trail for all database activity. Informant now includes a Web-based administration console that you can access from any location. Other upgrades include role-based access to reports, secure management of audit logs, and centralized reporting across all tier-one database servers. For more information, contact RippleTech at 866-739-8587 or visit http://www.rippletech.com.
T-SQL Auto-Completion
Red Gate Software announced SQL Prompt 3.0, an add-in for SQL Server 2005 Management Studio (SSMS) and Query Analyzer that anticipates the code candidates you need while writing T-SQL queries. New features include support for variables—including table-valued variables—and Data Manipulation Language (DML) statement auto-completion for SELECT, INSERT, UPDATE, and DELETE statements. SQL Prompt also includes built-in functions, support for large database schemas and SQL scripts, and auto-expansion of wildcard columns and column picker. You can download a free trial of SQL Prompt at Red Gate Software's Web site, and pricing starts at $195. For more information, contact Red Gate Software at 866-733-4283 or visit http://www.red-gate.com.
Prev. page
[1]
2
next page 
