LiteSpeed for SQL Server version 6.0 was released in June 2010 and includes these key features:
Fast Compression Backups – Fast Compression is Quest’s patent-pending backup technology which significantly reduces backup times, improves database recoverable, and automatically reduces a database’s backup footprint by up to 85 percent over and above the backup compression algorithms already in the product.
Network Resiliency – Backups will still succeed after network interruptions. User can also customize the number of retries and wait period for a finer level of control.
Easier Restores with Point in Time selection – Restore wizard’s time slider lets user choose exact point in time to recover data.
OLR (object-level recovery) and Log Reader support more funky SQL Server 2008 data types – DATETIMEOFFSET, DATETIME2, DATE, TIME, HIERARCHYID, GEOMETRY, and GEOGRAPHY are now supported.
SmartCleanup – Intelligently remove backups according to a user-supplied retention policy without affecting backup set integrity.
Maintenance Plans reinforced – Import/Export Plans, Copy/Paste Tasks and Sub-Plans, Wildcards and Regular Expressions supported for easier database selections.
New Maintenance Plan Cleanup History Task – Options to delete backup history, log shipping history, job and maintenance plan history, and more…
Updated documentation – New Install and Log Shipping Guides and references to online video content.
Fightin’ For Fast Compression Feedback!
LiteSpeed for SQL Server’s patent-pending Fast Compression (formerly SmartDiff) technology reduces backup size substantially for huge storage savings. It also decreases backup times significantly—from hours to minutes. Are you familiar with this technology? Are you taking full advantage of it?
We’d like your feedback. Tell how much disk space you’re saving and how much faster your backups are when using Fast Compression. Please share your comments with us in the LiteSpeed Forum at our SQL Server community.
We’d like to offer you the latest information to help you get the most out of your investment in LiteSpeed® for SQL Server. Most of these resources are also available through SupportLink, our customer support portal.
LiteSpeed Video Tutorials
Learn LiteSpeed for SQL Server tips and tricks by viewing our free recorded videos online. You’ll see the solution in action and discover how to:
Determine the most appropriate backup options for you
Query backup files without a full restore
Recover just one table or repair a dropped procedure
And just an FYI, but you’ll need to register on the Support website to reach most of those resources.
SQL Server Community Sites
Please join our SQL Server communities today to get the latest product information and find helpful resources. You can also participate in discussions with other community members as well as the Quest product team.
Please do not respond directly to this e-mail notification. You can elect to stop receiving product notifications by changing the ”Product Notification” setting under Edit User Profile on SupportLink.
Just wanted to let you know that a TechNet Radio episode and interview I did about cloud computing is now live on TechNet Edge. It was the featured spot on Thursday, June 3rd and is also featured on the TechNet homepage.
I’ve been trying to wear more of an analyst’s hat these days, so this webcast has a lot of my “deep thinking” on issues related to cloud computing – hopefully at a higher level of quality that Jack Handy.
A salient point that I think many analysts are overlooking is the changing nature of data as it exists in the cloud. For decades, data has primarily been about people (and their activities) for consumption by other people. The cloud is enabling a major shift in data generation and consumption where data is produced by machines for consumption by other machines. We’ll soon be looking at situations, now rather rare, in which sensors are extremely commonplace. These sensors, whether they be in traffic signals or high-end medical devices, will create enormous amounts of data far more frequently than ever before, loading that data directly into cloud databases. The cloud databases will consume and process the data and, when automated analysis (made all the easier through features like StreamInsight in SQL Server 2008 R2) will flag important findings for review by a real-live human being. Check out the interview for several real-world examples being played out even as we speak.
Perhaps I can persuade you to blog, tweet, or place a link to it in your Facebook or team newsletter? Maybe with a few deep thoughts? Please? Pretty please?
And I welcome your deep thoughts and responses here.
Toad for SQL Server Wins Best of TechEd 2010 in the Database Development Category
Toad and I go way back. I first started with Toad as a user on the Oracle DBMS back in the early 1990′s. When I started at Quest Software back on January 2nd of 2002, one of the first products I tackled as a SQL Server product architect was Toad. How do we make this very popular Oracle product one that users in the SQL Server world will love too? And this challenge was made that much harder by the fact that Microsoft SQL Server ships with fantastic tools right there in the box. I haven’t worked directly on Toad for many years now, but the tool marches on with new features and capabilities that push the envelop with each new release.
L to R: Jason Hall, Qsft head of SC's; David Gugick, director of Architecture; and me
Want to try Toad for SQL Server for free?
The 5.0 version of Toad for SQL Server that we showed at TechEd is the latest beta, available at ToadWorld.com (build 387 at the time of this writing). It can coexist with Toad for SQL Server version 4.6, if you’re already using it. The beta is quite stable and has a bevy of new features, including:
SQL Azure support for most modules including data compare and schema compare, including comparing regular SQL Servers to SQL Azure and back, also with Firewall management (under Server Security properties panel).
Much improved code completion that’s faster and allows for column selection, multi-table selection, with tooltips for parameters. Don’t forget, all of these features work on SQL Server 2000, 2005, 2008, and 2008 R2.
Updated Schema Compare with better exposed snapshots.
Group Execute enhancements that include database-level selection so you can execute across databases, an option to only show selected servers/databases, option to merge results (or not), improved merging, etc.
New Idle Connection Timeout – to close connections after a period of inactivity.
Result Set Pinning.
Improved Trace support with features like Import Trace File to Table and Open in Profiler capabilities.
New Debug Trace – traces all activity occurring inside of Toad, including storing all variable info in a replayable file.
Twitter Integration (under the View – Collaboration panel) with Yammer integration coming in a future beta release.
You can also see a lot more details about the tool here. And my long-standing offer still stands. If you want to try Toad for SQL Server or its brethren (such as Toad for Data Analysts, Toad Data Modeler, or Benchmark Factory), drop me an email and I’ll get a long-term license key straight over to you.
But wait, there’s more!
There are so many great resources for you to tap into. And best of all, they’re all free! Check these out:
In this white paper, renowned Oracle PL/SQL expert and fellow O’Reilly author Steven Feuerstein provides dev managers with guidance on how to help developers write the best software possible.
Live Product Demo:Toad® Data Modeler
Date: Wednesday, June 16, 2010
Time: 11:00 a.m. PT / 2:00 p.m. ET
New Orleans Morial Convention Center
900 Convention Center Boulevard
New Orleans, LA USA
I'll be there with bells on! Look for me at the Ask-the-Experts lounge or the Quest Software exhibit.
CONFERENCE AGENDA
Wondering if you should go? It’s all about the education. So check for the most current and detailed conference agenda at https://northamerica.msteched.com.
Can’t make it in person? There’s still good things in store for you! Tech·Ed Online offers on-demand technical sessions recorded at our Worldwide Tech·Ed events that explore all aspects of current and soon-to-release Microsoft technologies, tools, platforms and services. View TechTalks, Panel Discussions, and Breakout sessions delivered by industry experts and leaders, engage with community influencers on Tech·Ed Blogs, and share your onsite Tech·Ed experience on the photo page.
Everybody enjoys a little free training now and then. I’ve got mountains of free training in the works. Some of it is in-person and local while some are in webcast format. Please join me as you’re able!
There are a short list of mistakes that, if you know of them in advance and prepare for them, will make your life much easier. This presentation shows you these mistakes, the “low hanging fruit” of database administration. Once you apply the lessons learned from this session, you’ll find yourself performing at a higher level of efficiency and effectiveness than before. Quest is sponsoring this and raffling off a copy of my book, SQL in a Nutshell, and O-M-G a KINDLE!!! (Free, but registration required.) And if you haven’t already done it, join PASS!
SQL Injection attacks is the most common hacker trick used on the Web and yet, one of the easiest to prevent. Learn what they are and why you need to be concerned about them. In this webcast, I and SQL Server MVP K. Brian Kelley (twitter) will demonstrate different types of SQL injection attacks. You’ll learn how to find and block them to keep your databases safe, preventing disruptions to your organization. Quest is sponsoring this as well and raffling off more goodies. (Free, but registration required.)
Stereotypes abound for different types of people in the IT world. Developers think DBAs are control freaks. DBAs think developers are unruly cowboys. How do we overcome these differences? If you’re a developer, your best strategy is to manage your DBAs’ anxieties and demonstrate your competence and credibility. Attend this session to learn about 10 techniques that developers can apply to their code which will calm your DBAs’ fears and earn their admiration. Techniques include how to analyze a query plan and how to make sure your query is taking advantage of the best available indexes. Attendance is free although registration is encouraged so we can get a good count for the food, plus there’s free pizza and a raffle at the end. Drinks afterwards at Chilis.
Join SQL Server MVPs, Kevin Kline and Brent Ozar (blog | twitter), along with Quest Product Manager Ari Weil —all from Quest Software—as they interactively present tips and tricks to help you monitor your SQL Server environment with ease. You’ll learn how to use Dynamic Management Views (DMVs) to simplify troubleshooting and significantly enhance SQL Server performance. The day consists of eight sessions with live Q&A – a great way to get answers to your questions straight from the source. Chat live with Quest experts. Plus, you can visit the Quest booth to download helpful resources like white papers, watch demos and more. This virtual training day is free and you can attend the sessions that fit your needs – perfect for tight budgets and busy schedules.
The SQL Server Community will experience an event like no other in the Southeast region. Renowned speakers from around the world will gather in Charlotte, NC to share their knowledge on Microsoft SQL Server. This is your opportunity to meet, network with and learn from the SQL Community leading experts such as Andrew Kelly, Rick Heiges, John Welch, Brian Knight, Geoff Hiten, Andy Warren, Jessica M. Moss, Rafael Salas, Sergey Pustovit and Tim Ford. Also scheduled to present are current SQL PASS President Rushabh Mehta and former SQL PASS Presidents Wayne Snyder and Kevin Kline.
Traditionally, the time between Christmas and New Years is a bit slow. Many people take time off from work and, for those of us still working, it’s a good time to catch up on all of those low priority projects that have been on the back burner for the last several months.
If you find yourself with a few extra hours, why not engage in some first-hand learning with the new features of SQL Server 2008 R2? Here are two great resources to get you started.
First, take a look at betaforsqlserver.com, a partnership between MaximumASP, Dell, PASS, and Microsoft. When you register, you get your own sandbox SQL Server 2008 R2 including support for .NET and PHP, along with Reporting Services, Analysis Services, and Integration Services. It almost makes me believe that there is such a thing as a free lunch!
Second, why not try your hand at one of the most exciting new features in SQL Server 2008 R2, PowerPivot for Excel? You can play with it to your heart’s content at the new Microsoft Virtual Labs, another great service for learning in real albiet sandbox VM Hyper-V labs.
I know in my own case, it’s often tough to find a free server somewhere where I can set up and install the sandbox environment. On top of that, even during a slow week, I rarely enjoy spending my time configuring an entire environment. Why not solve both problems at once with this fast and easy method of learning the news features?
