Tin Pan Alley BBS > Home ( DNN 3.3.5 )

Not a sound from the pavement. Have you ever come across a SQL query that used to run faster? Has that...

Join SQL Backup’s 35,000+ customers
to compress and strengthen your backups
"SQL Backup will be a REAL boost to any
DBA lucky enough to use it." Jonathan Allen.
Download a free trial now.

9/4/2010 2:56:11 PM

Writing an SSBS App When the Initiator and Target are on the Same Database

SQL Server Service Broker (SSBS), introduced with SQL Server 2005 and enhanced in SQL Server 2008, allows you to write queuing/message based applications within the database itself. This article discusses creating an application in which Initiator and Target both are in the same database.

9/4/2010 2:56:11 PM

SSRS In a Flash - The Basics

In this part of our series on Reporting Services (SSRS), Jessica Moss examines the basics of the Report Builder and BIDS.

9/4/2010 2:56:11 PM

The Semantics of NULL in SQL Server 2008

Learn the basics of NULL, what it is, and how to query for it in your databases from Adolfo Socorro. What NULL means, how to account for it, and how are expressions involving NULL evaluated

9/4/2010 2:56:11 PM

Security Auditing Matching Up Logins And Users

I have been tasked with auditing security on my SQL Server. However, this needs to be a somewhat automated process as I don't want to have to rely on taking screenshots every month to satisfy our auditors. What tables and/or views should I be using and what's the best way to extract the information out of them?

9/4/2010 2:56:11 PM

SQL Schema Comparison with Visual Studio 2010

we normally do development on the development box; then during the build preparation we compare the development database with the QA/UAT/Production database to identify differences and generate schema objects for synchronization or incremental deployment scripts. How we can compare schema objects between databases and generate synchronization or incremental deployment scripts?

9/4/2010 2:56:11 PM

SQL Source Control - Q & A

After a webinar for SQL Source Control, there were a large number of questions left unanswered. All have been listed here, along with answers from the Red Gate development team.

9/4/2010 2:56:11 PM

Defensive Db Programming Chapter 05

We are here again with after another week and ready for another episode in this series. Today we get to...

9/4/2010 2:56:11 PM

Why is data integrity important?

Why should I care and why should the database enforce it? This article from Jamin VanderBerg gives some reasons why the database is the place to enforce rules that ensure integrity.

9/4/2010 2:56:11 PM

DBA Morning Check List

This article helps the DBA find and fix issues quickly by creating a DBA Morning Checklist.

9/4/2010 2:56:11 PM