Featured Article(s)
SQL Server 2005 Cluster Troubleshooting
In this article, Alexander Chigrik explains some problems that you can have when you work with SQL Server 2005 cluster. He also tells how you can resolve these problems.
SQL Server Video Show Available
SelectViews #110: Partitioning Large Databases, USB Devices, Performance and Clustered Indexes, Upcoming Events. Also, the Accidental DBA Tip, the 60-Second SQL Server Tip of the Day and a Lot More.
[Watch The Show]
SQL Server Security (Part II)
There’s a great article in Information Week about the different layers that you need to be considering for your networks. It talks specifically about the different segments that need attention, and the different technologies that are needed to address them.
I really thought their diagram was excellent- you can see the "decision points" – where the network and tools decide on access rights and such.
There should be decision points in your organization as well – points of authority where people can decide on access, functionality, etc. There should also be checks and balances built in. If a specific authority level is being considered for assignment to a given individual or application, there should be some check that says that that entry point should indeed be granted.
Absent from this is specific information addressing database security (it’s embedded, really, in the "Application" item of the graphic, but still…) – but you get the idea. It’s good to have the layers and good to have the decision points.
Featured White Paper(s)
ESG Lab Validation Report of the HP PolyServe Database Utility for SQL Server
ESG Lab, the testing facility of industry analyst firm Enterprise Strategy Group, reports its comprehensive testing of HP’s s… (read more)
Making Databases Explorable
This paper looks at common difficulties encountered when maintaining a large number of databases and how the products in the … (read more)