Forum Replies Created
Viewing 15 posts - 4,711 through 4,725 (of 6,105 total)
-
RE: Password encryption: Best Practice ?
Probably your best bet is to encrypt in the application. If you don't use SSL or Multiprotocol (w/ Encryption), the password will go across the wire in plaintext. Even if...
-
RE: Calling all Perl junkies!
I'm following what you are doing. We've used properties for the ConnectionString, didn't consider it for the Error object, that's neat.
I'm let Void now there's... -
RE: Report Generation
Yes. Also check out their DynamiCube and ActiveCube if you do any OLAP.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
-
RE: Report Generation
We prefer Active Reports to Crystal, though there are some things (straight text reports, believe it or not) Crystal handles better.
Crystal's APIs can be cludgey. Also, there is a potential...
-
RE: SQL Error Logs with SQL Clustering
Which error log were you looking at, and on what server? SQL Server, SQL Server Agent, Windows Event Logs?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring...
-
RE: Calling all Perl junkies!
No. Because of the way the Errors object is built, it's not recognized as an Enum object. The error returned when you try to implement in this fashion (even if...
-
RE: Enumerate parameters
In SQL Server 2000, yes. In SQL Server 7, no. The Parameters Information Schema view is one of three new such IS views to SQL Server 2000.
http://www.sqlservercentral.com/columnists/bkelley/informationschemaviews.asp
K. Brian Kelley
http://www.truthsolutions.com/
Author:...
-
RE: Enumerate parameters
Yes. If you've called the stored procedure and passed it a parameter, you can reference it like any other variable from within the stored procedure. For instance:
-
RE: Only Data Warehousing jobs?
I've seen a similar trend as well. One thing you can do on your own time is get familiar with Analysis Services and some of the data mining capabilities that...
-
RE: SP3 Open forum
It would be nice, but Microsoft pretty much restricts discussion of beta products to approved forums (AKA under their control). That keeps an anticipating public from hearing news about a...
-
RE: SP3 Open forum
If you go to the beta site, there are instructions on how to get to the newsgroups, both through NNTP (through a client such as Outlook Express) and through the...
-
RE: Enumerate parameters
Along the same lines, but more from a report building side:
-- Variables to use for cycling through the stored procedures
-- Identified from sysobjects
DECLARE @procName sysName,
... -
RE: BLOB’s, when things will start to break
One other reason we went the direction we did was that the files are also within the Index Server catalogs. We have mixed content, include some pure HTML pages that...
-
RE: Bench Marking
Benchmarking a pretty involved process, hence the eBook. 🙂 I cover how to go about benchmarking, how to use Excel to generate usable graphs, what counters to monitor in Perfmon,...
-
RE: BLOB’s, when things will start to break
When building our intranet, there were a couple of requirements that drove the design:
1) Users should be able to create folders and subfolders by using a web form.
2) Users should...
I'm let Void now there's...Viewing 15 posts - 4,711 through 4,725 (of 6,105 total)