A case for canned SQL
Should you use dynamic or static SQL in your SQL Server application? This is a hotly debated topic and Arthur Fuller brings his thoughts to this debate.
2006-02-06
3,278 reads
Additional Articles
Survival tips for PowerPoint
there are occasions in all of our working lives when sitting through a PowerPoint presentation is inevitable. Fortunately, there are techniques for feigning interest, many of which have developed over hundreds of years. All you need is a handful of like-minded colleagues with a sporting attitude
2006-02-03
2,581 reads
Implementing Row- and Cell-Level Security in Classified Databases Usin
This paper describes how SQL Server 2005 can be used to support row- and cell-level security (RLS/CLS). The examples provided in this white paper show how RLS and CLS can be used to meet classified database security requirements.
2006-02-02
2,813 reads
Implementing Smart Reports with the Microsoft Business Intelligence Pl
This article presents an excerpt from the book, Applied Microsoft Analysis Services, by Teo Lachev. Learn how to author “smart” reports using Reporting Services (SSRS), Analysis Services (SSAS), and SQL Server CLR stored procedures. Get the reports demonstrated in this article by downloading the sample code.
2006-02-01
3,483 reads
Implementing Row- and Cell-Level Security in Classified Databases Usin
This paper describes how SQL Server 2005 can be used to support row- and cell-level security (RLS/CLS). The examples provided in this white paper show how RLS and CLS can be used to meet classified database security requirements.
2006-01-31
1,926 reads
The SQL Site Map Provider You've Been Waiting For
In this installment of Wicked Code, Jeff Prosise updates his original ASP.NET 2.0 SqlSiteMapProvider to add support for automatic reloading of the site map following a change to the site map database.
2006-01-30
2,143 reads
Automatic Excuses for IT Pros
Now that the novelty of the Xbox 360, the Razr cell phone, and King Kong have likely run their course, Red Gate Software presents a truly functional gift for the harried IT professional: A handy excuse generator for those projects that just don't work out as planned.
2006-01-27
4,413 reads
SQL Profiler: Features, functions and setup in SQL Server 2005
Trying to find the proverbial needle in the haystack of your SQL Server transactions is no small task. SQL Server Profiler not only helps you find that needle, it gives you details on all the other needles in a single interface.
2006-01-26
2,525 reads
Counting Parents and Children with Count Distinct
The aggregate functions in SQL Server (min, max, sum, count, average, etc.) are great tools for reporting and business analysis. But sometimes, you need to tweak them just a little bit to get exactly the results you need. For example, if your manager came to you and asked for a report on how many sales have been made to your clients and how large they were, would you know how to get the data you need efficiently? Mark ran into something like this recently and here's the approach he took to solve the problem.
2006-01-25
3,507 reads
SQL Server 2005 DB Snapshot: Imperfect Yet Useful?
Database Snapshot (DB Snapshot for short) is a new tool offered by SQL Server 2005. Database snapshots can be used to protect against user errors, by creating a "snapshot" of your data that you can refer to later if you need to recover data or database objects that were accidentally (or even intentionally) updated or dropped. While the feature is quite useful, it doesn’t provide a 100% guarantee against user errors.
2006-01-24
2,078 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers