SQL 2008

Suresh Sreedharan ISV Architect Evangelist sits down with Bob Abernethy, SVP & GM at Strategy Companion to talk about their BI offering.

Do you have another, yet another, reporting assignment? Is an output requirement PDF format, or Excel, or Word? Do you need built-in printer functions like print preview? See the answers and much more in the Tool Shed Tooltip clip. What is it? Microsoft SQL Server 2008 Reporting Services (SSRS)…

Did you ever wonder how to maintain the truth of your data while updating schema definitions on a production database? How about wondering what will be impact by a rename of something in your database? How do I easily generate Test Data? DB Pros have had many headaches over answering…

Learn about Live Services and see how to hook up Virtual Earth to the new SQL 2008 Geospatial support. What is it? Windows Live Web Services enable developers, designers, and enthusiasts to quickly create compelling web and desktop applications. Download Site:…

Jim O’Neil, Developer Evangelist, closes out his five part series covering topics on SQL Server for developers with an overview of execution plan generation.  Using SQL Server Management Studio it’s easy (and fun) to watch how queries are optimized and thereby get a better insight into…

SQL Server Profiler is a tool every developer should have in their repertoire. With the use of frameworks and abstractions, we often lose sight of what is actually hitting the database, and there’s no better way to get that information than SQL Server Profiler. It has a few knobs and dials that…

Jim O’Neil, Developer Evangelist, continues his five-part series on what developers should know about SQL Server. In this third segment, he takes a look at the components of a SQL Server error as well as some of their nuances and suggests techniques for handling errors on both the server-side in…

In this second of a series on what developers should know about SQL Server, Jim takes a brief look at SQL Injection attacks, how they occur and what types of things you can do (as well as things you shouldn’t do!) to eliminate your susceptibility to them. Also mentioned are a number of third-party…

It’s rare that a developer doesn’t need some familiarity with the database his or her applications are targeting, so this session (divided in to five parts) provides a bit of insight into features of SQL Server 2008 (and 2005) that they should be aware of when building .NET applications. The…

In this interview, Luke Chung, founder and president of FMS, shares his view on Microsoft Access database solutions -- where they fit well, what challenges users and developers often face in creating and maintaining them, and how they have evolved from standalone desktop solutions to having the…