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
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
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
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
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
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
Do you have a Web site or other system that deals in secrets of any sort? It seems like every time I give a security talk, people ask how to deal with the sticky problem of storing secrets. Connection strings with passwords are an obvious problem. You're better off simply using integrated security to get rid of those secrets, at least with SQL Server™, or an Oracle database. But what about credit card numbers and other financial or personal information? Can encryption help?
2006-01-23
2,476 reads
When considering business intelligence (BI) software, it is essential to be aware of underlying issues that can seriously impact on your bottom line. In a country where most businesses have information stored in several different databases, it’s no secret that the BI strategy you choose will effect your profit and loss target. From data collection and integration to data analysis, the holy grail of Business Intelligence software combines your disparate databases to provide a decision support system that will enable you to make key conclusions using all of the available information.
2006-01-20
2,455 reads
This document describes the improved indexed views capability of SQL Server 2005 Enterprise Edition. Indexed views are explained and specific scenarios in which they may provide performance improvements are discussed.
2006-01-19
2,506 reads
As we all know, SQL Server 2005 has new features when compared to SQL Server 2000. One of the features that we are going to discuss in this article is the Row_Number() function. SQL Server Database administrators and developers have been longing for this function for a long time--now the wait is over.
2006-01-18
4,705 reads
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
By DataOnWheels
I can’t believe it’s finally here! A way to have Excel live in OneDrive...
By Steve Jones
This image is from 2010, and it goes along with my last post of...
All week we've had issues with the site being up and down. There's been...
I created a post (or tried) in the 2022 Admin forum. https://www.sqlservercentral.com/?post_type=topic&p=4694880 But it's...
In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?
See possible answers