SAN and NAS protocols and how they impact SQL Server
Discusses the various SAN and NAS protocols (FC, iSCSI, NFS) and how choosing one over the other can impact your SQL Server Performance.
2015-07-24 (first published: 2012-04-24)
17,644 reads
iscsi
Implementing Microsoft iSCSI Initiator Policies & Multi Pathing
Impementing iSCSI multi-pathing and redundancy policies
2012-03-09
3,002 reads
RE: Search in DTS packages
AER, have a look at the script I've posted here, It does a find and replace within ActiveXScripts. Probably be able to modify it a bit to search other properties or collections in the package. Hope this helps Phill Carter -------------------- Colt 45 - the original point and click interface
2003-11-26
RE: Read-only Linked Server?
If you can create stored procedures in the Progress database, I think you can configure the linked server to be read-only. There are two parameters in the sp_serveroption procedure that might accomplish this: data access Enables and disables a linked server for distributed query access. rpc out Enables RPC to the given server. If you […]
2003-09-04
1 reads
RE: SQL Database organization
USE pubs IF EXISTS (SELECT name FROM sysobjects WHERE name = 'reminder' AND type = 'TR') DROP TRIGGER reminder GO CREATE TRIGGER reminder ON titles FOR INSERT, UPDATE, DELETE AS EXEC master..xp_sendmail 'MaryM', 'Don''t forget to print a report for the distributors.' GO Above is the example from BOL. It creates trigger on table 'titles' […]
2003-08-22
1 reads
Blogs
T-SQL Tuesday #176 One piece of advice that you wish Past you had
This month’s T-SQL Tuesday is hosted by a dear friend, long time SQL Server...
T-SQL Tuesday #176: One piece of advice for Past Steve
By Steve Jones
I almost missed this month, so this is also a good #SQLNewBlogger post. I...
Deleting Old Local Git Branches–#SQLNewBlogger
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers