Articles

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

Discuss

The CEO’s Guide to The Top 5 Issues that Misguide Business Intelligenc

by Additional Articles

Other

Design and Theory

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

Discuss

Brooke Philpott of sqlSentry

by Andy Warren

SQLServerCentral.com

Interviews

The guys that build software rarely get exposure of credit. Maybe that's why so many of them turn to open source where they get more well known. After a meeting at TechEd 2005, Andy Warren had the chance to get some interesting interview questions answered by Brooke Philpott, one of the 2 core developers of sqlSentry. And not a marketing guy.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2006-01-19

5,781 reads

Discuss

Improving Performance with SQL Server 2005 Indexed Views

by Additional Articles

TechNet Blogs

Administration

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

Discuss

PromptSQL Review

by Brian Kelley

SQLServerCentral.com

Product and Book Reviews

Do you want intellisense for Query Analyzer? Many people would love this amazing enhancement that has long been available for Visual Studio users. It is now available as an add-in from PromptSQL and Brian Kelley reviews this amazing product.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2006-01-18

10,224 reads

Discuss

Row_Number() function in SQL Server 2005

by Additional Articles

Database Journal

T-SQL

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

Discuss

SQL Server and MOM 2005

by Additional Articles

Database Journal

Monitoring

In this series of articles, you will learn the basics of installing Microsoft Operations Manager 2005 as well as how to use MOM to monitor SQL Server. This article takes advantage of virtualization. We will use VMware Workstation 5 to create the lab to introduce you to the basics of installing MOM to monitor SQL Server.

2006-01-17

3,401 reads

Discuss

Working With System Tables

by Alex Grinberg

SQLServerCentral.com

SQL Puzzles

It's not recommended, but sometimes writing scripts against the system tables and getting information is a great way to work with SQL Server. Alex Grinberg brings us a look at some of the things you can get from system tables along with some sample scripts.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2006-01-16

14,534 reads

Discuss

Downloading a file over HTTP using SSIS

by Additional Articles

sqljunkies.com

Integration Services (SSIS)

A question came up on an internal alias about how can one download a file over HTTP. Here's a script that does that, should be trivial to wrap it inside a task if you forsee doing this over and over again.

2006-01-13

2,470 reads