Uncategorized

DevConnections (and SQLConnections)… Day 2

Featured Article(s)
Troubleshooting SQL Server 2005 Merge Replication (Part 1)
In this article, Alexander Chigrik explains some problems that you can have when you work with SQL Server 2005 merge replication. He also tells how you can resolve these problems.

Don’t Throw Away Your Reporting Services Masterpieces…
Once you’re done creating the reports your users need, you know you’re almost there… but creating the reports is only half the battle. You have to get the reports to the right users, in the right formats, at the right time. Not a simple task as different people want them in different formats (print, Excel, PDF, etc.) and potentially at different times. This is where SQL-RD comes in, making this distribution and management process a snap. If you’re building reports, check out SQL-RD – it will complete your Reporting Services solutions and let you deliver exactly what your users need, when they need it, in the format they’ll best be able to use it. Get more information here (along with a free trial).

SQL Server Crystal Ball: Knowing What to Watch As Your SQL Server System Grows
We’ll look into pulling baseline information, things you can do to chart and forecast growth on your system and the basic options you have to grow you system out and up. Find out how to use Performance Monitor tools and learn about what different scaling techniques can bring to the table.

> Register Now
> Live date: 11/13/2007

Creating, Managing and Reviewing Jobs with SQL Server 2005
We’ll show how to create a job, work through the different options,including notifications, variable job steps, scheduling and more. The goal of this session is to have you up and running, understanding how the options work for setting up and managing jobs in your system.

> Register Now
> Live date: 11/14/2007

DevConnections… Day 2
There is a huge crowd here – this picture is from one of the several simultaneous keynotes this morning – from Scott Guthrie to Tom Rizzo and others, it’s a very broad assortment of technologies and information that’s being put out here at the show. I’ve heard from a lot of people that the keynotes are presenting the roadmap of technologies, then sessions are going to be filling in the details, the how-to information and such.

In case you missed it, with the announcement about general availability for Visual Studio also came the announcement of availability for the .NET 3.5 Framework. We did an on-camera interview today about this and I’ll have that for you as soon as we get it edited after we return. Suffice to say that there are some interesting pieces in there now. The thing that caught my eye in all of this is the support for Web 2.0. Now, don’t do what I did and YAWN. The reason I say this is because typically when someone tells me their product "supports" Web 2.0, you get a mish-mash of things, based on what they want "Web 2.0" to mean.

With this Framework release, it’s really up to you what it "means" – but the Framework goes beyond presentation layer (UI) stuff and just mashing up content and the like. It goes to supporting the exchange of information between sources (cool) and supporting the creation of applications that can do what you and I call "Web 2.0." The infrastructure for your applications to build out functionality that can be shared. From database stuff to functions to … well, just about whatever you want to build out and share or use.

LINQ is big as well – we’ll have more information about this and how it works very soon. LINQ, it seems, stands poised to make development with databases quite a bit more straightforward and less error-prone. The fact that you have well-defined interfaces to work with data will quickly become the norm, and it’ll be a good thing for projects. I can’t wait to hear about additional successes with people approaching their development this way in the mainstream.

Featured White Paper(s)
A Network Engineer’s Guide to Troubleshooting User Satisfaction Problems with SAP Applications
Is It the Application or the Network? If you’re a network engineer in an organization that runs SAP, you’re probably famil… (read more)

Selecting the Right Change Management Solution
Frequent application updates, data migrations, service level requirements, and new compliance mandates mean your company need… (read more)

Are AJAX Applications Vulnerable to Hack Attacks?
This paper reviews AJAX technologies with specific reference to JavaScript and briefly documents the kinds of vulnerability c… (read more)

Profiling SQL Server Performance by Kevin Kline
Database changes impact database performance. The challenge is that DBAs lack the necessary expertise and cannot afford the o… (read more)