Carolyn talks in detail about the new reporting features of SQL Server 2008 as well as Report Builder 2.0, and describes how easy it is now for users to access data and create rich reports with data visualizations.
In SQL Server 2008, you can perform insert, update, or delete operations in a single statement using the MERGE statement.
The MERGE statement allows you to join a data source with a target table or view, and then perform multiple actions against the target object based on the results of that…
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…
Have you ever eyeballed your data to find an abnormality? Talk about an instant headache! See Guest speaker MVP
Jessica Moss show developer tools are now integrated in Visual Studio as part of the SQL Server Client tools install...among them SQL Server Integration Services (SSIS) Data…
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…
Daniel Bien is a Group Program Manager who focused on the reconstruction of SQL Server 2008 and worked in the setup and deployment area. He discusses the challenges he faced which included expediting the process of smaller tasks and setup in SQL Server
Lindsey Allen is a CAT (Customer Advisory Team) team member and worked on developing best practices. Her team’s mission is to push the boundaries of product deployment in real-world customer scenarios. She also discusses the challenges of dealing with
the complex customer workload and test runs.