Q&A: The skinny on Reporting Services 2008
Get the inside scoop on SSRS 2008 with Michael Lisin and Jim Joseph, co-authors of the new book, "Microsoft SQL Server 2008 Reporting Services Unleashed."
2009-08-12
4,114 reads
Additional Articles
Where is my app.config for SSIS?
Sometimes when working with SSIS you need to add or change settings in the .NET application configuration file, which can be a bit confusing when you are building a SSIS package not an application. First of all lets review a couple of examples where you may need to do this.
2009-08-12
3,085 reads
Data Compression: Strategy, Capacity Planning and Best Practices
The data compression feature in SQL Server 2008 helps compress the data inside a database, and it can help reduce the size of the database. Apart from the space savings, data compression provides another benefit: Because compressed data is stored in fewer pages, queries need to read fewer pages from the disk, thereby improving the performance of I/O intensive workloads. However, extra CPU resources are required on the database server to compress and decompress the data, while data is exchanged with the application. Therefore, it is important to understand the workload characteristics when deciding which tables to compress.
2009-08-11
2,717 reads
Using INSTEAD OF triggers in SQL Server for DML operations
In SQL Server 2000 and onwards there are INSTEAD OF triggers that can be used to carry out such tasks. Although these types of triggers can be used in a number of scenarios their primary function is to perform DML operations through such views. This tip shows how to use INSTEAD OF triggers to handle these DML operations on views.
2009-08-11
3,382 reads
Push vs. pull: Configuring SQL Server replication
Learn the difference between push and pull subscriptions and how to determine the best placement for SQL Server replication's Distribution Agent
2009-08-10
3,198 reads
T-SQL Best Practices – Part 2
Continuing our discussion covering T-SQL best practices, this article focuses on how to optimize writing a jack-of- all-trades stored procedure (SP).
2009-08-10
9,037 reads
Richard Stallman: Geek of the Week
Many famous geeks work away at their programs without considering the wider implications of what they, and others, are doing. Richard Stallman isn't like that. Richard (rms) is one of the great brains behind Linux distros, as he wrote the GNU compilers and GNU debugger. He is driven by strong opinions about the nature of free software, and the restrictive nature of software copyright. We sent our intrepid reporter, Richard Morris, to find out if Richard Stallman really required journalists to read parts of the GNU philosophy before an interview, for "efficiency's sake".
2009-08-07
2,874 reads
Simple Doughnut Chart for Analysis Services Data
Architect Bill Pearson leads the hands-on creation of a simple doughnut chart based upon an Analysis Services data source.
2009-08-07
3,212 reads
An Introduction to SQL Server FileStream
Filestream allows us to store and manage unstructured data in SQL Server more easily. Initially, the accounts of FILESTREAM assumed prodigious powers of concentration and cognition, and we mortals all recoiled numbly. However, it became clear that we were missing out on some extraordinarily useful functionality, so we asked Jacob Sebastian to come up with a simple and clear-cut account of the FILESTREAM feature in SQL Server 2008. You'll agree he has managed the feat superbly.
2009-08-06
3,929 reads
Different ways to determine free space for SQL Server databases and database files
In this tip we take a look at a few ways to find the current free space within a database, so you can better manage your database files.
2009-08-06
4,986 reads
Blogs
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
4 CPE Opportunity (Virtual) for Charity
By Brian Kelley
Every year, the South Carolina State Internal Auditors Association and the South Carolina Midlands...
Data Céilí 2026 Call for Speakers!
Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...
Forums
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
UNISTR Basics
Comments posted to this topic are about the item UNISTR Basics
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers