Latest SQL Server Show Live Now
This SQL Server show has a LOT of information. Interviews with some tools makers, information about protecting your holiday time, 60 second tip of the day, our SQL Server discussion list watch and a whole lot more.
Also available
Watch: SQLonCall Show – Interviews and more.
Featured Article(s)
New Features in ADO.NET 2.0 (Part I)
ADO.NET has introduced many cool features to improve the scalability and performance of data centric applications. With features like provider independent factory models, support for XQuery handling with xml data type and asynchronous processing techniques, the amount of LOC, code complexity and maintenance has been greatly reduced thus helping the developers to be more productive. In this series of articles, we will explore the new features added to ADO.NET.
Thanks To Our Sponsors
We’ve worked with some great companies this year! We really appreciate their support and help in bringing you SSWUG. Over the next few days I’ll be bringing you a list of the different sponsors, big and small. Take a moment and check it out – there are some outstanding products here!
MaximumASP – Smart Hosting – Smart Choice
Nob Hill Software -Tools for Database People
PowerGadgets – Desktop Reporting & Monitoring for IT/DB Professionals
Prometric – Comprehensive Testing & Assessment Services
Quest Software – Ensure Database Quality, Performance & Availability
Red Gate Software – Ingeniously Simple Tools for SQL Server Relational Solutions – The Data Warehouse Experts
Microsoft Seeking Your Feedback
Are you using SQL Server Express? MS is asking about Report Designer updates to the SQL Express environment and I wanted to pass along the pointer to provide your feedback. It sounds like they are wondering if Express is more of a data consumer tool when it comes to reporting. Essentially, they’re asking to see if you agree, and if you think a consumer (as in data consumer) tool or update would be helpful.
"Just Add Sync"
When I was at DevConnections, one of the interviews I did with Microsoft was about their Sync Framework. Basically, with the Sync Framework (SF), you could "just add sync" to your application and be able to readily share information from data to status to interim work files or just about any other object, really.
It was a bit of a mind stretch to "get" how to incorporate this, but it came down to letting you provide for synchronization for just about any application you have. Whatever information you’d need to share back and forth between nodes of the application, you could use SF to accomplish it. It’s not really a replication-type engine, but much more a system that lets you share and keep organized information in general in a connected and a disconnected environment.
I found this article about understanding more about SF, thought I’d pass it along. You can also check out the SF interview on the SSWUGtv archives and see more information about how Microsoft was talking about it at DevConnections.
Featured White Paper(s)
Troubleshooting and fixing a .NET application that accesses a database
Troubleshooting and fixing a .NET application that accesses a database is a generic problem. It’s also one that Red Gate Soft… (read more)
The Payment Card Industry Compliance – Securing both Merchant and Customer data
This white paper introduces the Payment Card Industry Compliance standard, and the security threats which brought about the n… (read more)
Essential Guide: Diagnosing and Resolving Performance Problems
Maximizing your application’s performance is not easy. If you believe your database is the problem, we have an outline for ef… (read more)