Storage - A meeting of minds
Even if you are not an infrastructure guy a good grasp of storage basics will stand you in good stead
2012-07-16
5,295 reads
SAN
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
NetApp Dynamic Backup Script
TSQL Script to backup selected databases. Use this to override the script generated by snapmanager for sql in a sql job which doesn't cater for new or deleted databases
2011-08-09 (first published: 2011-07-27)
778 reads
EVA Partition Alignment
Partition alignment is a well documented best practice, but does it have any benefit on an HP EVA?
2009-09-09
2,968 reads
2009-01-08
9,375 reads
SQL Server local disk storage to SANs
Storage area networks (SANs) improve SQL Server performance. Set up SANs on SQL Server with these best practices on migrating to, and configuring SANs.
2008-07-07
4,584 reads
RE: Statistics?
The only reliable way to retrieve a random sample of records wit SQL Server is to use the Newid() function. Do a search of this forum's archives for 'random' and you should get some good advice on the actual SQL to use to get a random sample.If your organisation has a statistician on staff, you […]
2004-09-02
Restoring 6.5 databases
Can anyone tell me, or point me to a link, on how to restore a 6.5 database. Not just a user database, but the whole kit and kaboodle. Starting with installing the SQL Server 6.5 binaries. It has been a long time since I have done this and am trying to help create a DR strategy. Thanks,Jeff
2004-03-24
145 reads
RE: Query Analyzer - Licensing
Unlike SQL Server 7, SQL 2000 does not offer per-server licensing. SQL Server (2000) has 3 licensing modes. - Per Processor: Any number of clients/devices can connect WITHOUT the need for each client to have a CAL. Each CPU on the server would need to be licensed. - Server plus device CAL - Requires a […]
2003-12-13
1 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
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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