Posts Tagged ‘SQL Server’

Wrox on the Road – Wrox authors coming to a conference near you

As usual, when there’s a big list of conference announcements, there’s a big list of Wrox authors speaking at them. We’re lucky to get to work with such busy and active authors, here are a few of the highlights on the speaking schedule in 2010: SharePoint Saturday NYC: July 31, NYC: Paul Galvin, Chris Geier, […]

Tags:

Filtering User-Specific Report Data in SQL Server Reporting Services

Filtering User-Specific Report Data in SQL Server Reporting Services Due to security requirements, a lot of organizations have a need to display data specific to the user accessing the report. With increasing emphasis on standards compliance, many organizations are taking the protection of private information more seriously. There are a couple of different techniques for […]

Tags:

Creating Mailing Labels in SQL Server Reporting Services

Creating Mailing Labels in SQL Server Reporting Services Most word processing applications (Word, WordPerfect, and so on) provide the capability to create a “mail merge” from which to generate mailing labels in different formats and layouts. Mailing labels are an automated way to generate the address labels for a large number of envelopes or parcels […]

Tags:

Setting Up Your Sharepoint 2010 Development Environment

Setting Up Your Sharepoint 2010 Development Environment Before you can start SharePoint 2010 development, you need to set up your development environment. There are some new twists with SharePoint 2010 when it comes to the development environments that it supports. One of these twists is that SharePoint can run, for development purposes, on a desktop […]

Tags:

LINQ to SQL

Chapter 56: LINQ to SQL What’s In This Chapter? Working with LINQ to SQL using Visual Studio 2010 Mapping LINQ to SQL objects to database entities Building LINQ to SQL operations without the O/R Designer Using the O/R Designer with custom objects Querying the SQL Server database using LINQ Stored procedures and LINQ to SQL […]

Tags:

Creating a Report Server Usage Report with SQL Server Reporting Services

Creating a Report Server Usage Report with SQL Server Reporting Services For IT to consolidate and optimize many reports in a business reporting platform, it must know what users are using reports and how often. It’s critical to know how long different reports take to run and when the peak and lull times occur throughout […]

Tags:

Creating a Personal Report Card with SQL Server Reporting Services

Creating a Personal Report Card This recipe creates a personal report card report that displays an individual’s performance compared with the best performer for the same performance metrics over a specific period of time. In this case, you are going to compare sales employees who are at the same hierarchical level to see how well […]

Tags:

Free Wrox SQL Server Community Training

I thought it only fitting to have my first post be about an event that Brian Knight, the crew at Pragmatic Works and I have been working on for several weeks. We’ve teamed up for an incredible set of Webinars focused on SQL Server and Business Intelligence taught by best selling authors, many of which are authors […]

Tags:

SQL Server Reporting Services: Chart Reports

Excerpt from Professional SQL Server 2005 Reporting Services The charting capabilities in SQL Server Reporting Services are quite impressive and as easy to use as those in Excel or Access, and, in many ways, they are more powerful. The charting components are based on Dundas Charts, developed by Dundas Software. Dundas provides a suite of […]

Tags: