(Kevin Beaver) What does goal setting have to do with SQL Server security? Everything! Like most things security-related, protecting your database is not a one-time deal. Instead, it’s a mode of operation made up of doing the things that make databases secure on a consistent basis. (R)
Other News
Collecting database usage information for free space and trending
(Tim Ford) I have over 80 instances hosting 800+ databases that I support on my own. The only way I can keep track of all these databases is to centralize my monitoring so I have a single point of focus on my environment. I can not spend my entire day (and night) hopping from SQL instance to SQL ins
Justifying Best Practices
Great Whitepaper Available Working with SSIS? If so, check out the white paper we have in the library that talks about how you can use SSIS to do quite a bit more than just an import of your data. Tips, tricks and lot more — learn about why SSIS really does the ETL – Extract, Transport and Load for SQL […]
A SQL Server Bug Report… With Humor…
Featured Article(s) Best practices of synchronizing threads There might be situations in your applications where multiple threads are accessing the same data at the same point in time. Some may be updating the data, some reading them, etc. In such situations, you need to synchronize the access to this data, mostly because if multiple threads are accessing the same data […]
Making Friends with Your DITA-Unfriendly Documents
(Don Bridges and Mikhail Vaysbukh) DITA is a hot topic in the ‘Tech Docs’ arena, and for good reason. DITA is an open standard that addresses many of the needs of technical documentation producers – most notably content reuse needs. The big question for many companies, once they’ve determined that a
Digitally Signing an XML Document and Verifying the Signature
(Rick Strahl) Recently I’ve been involved in some work that deals with signed XML documents outside of a WCF Web service environment. Ironically the service that is being accessed accepts SOAP data but the service does not expose any WSDL even though it uses some WS-* specification features – namely
Faceted navigation for document discovery
(Alan Marwick) While there are several different ways for a user to specify metadata conditions, this article discusses one that has special advantages: faceted navigation. Follow the faceted navigation system described in this article, a technology demonstrator based on IBM Omnifind Discovery Editi
Create an Ajax mindreader application with E4X and Prototype, Part 2: Make the mindreader smarter
(Nicholas Chase) In this two-part article series, you learn to use both ECMAScript for XML (E4X) and the Prototype JavaScript library to create a simple Ajax mindreader application that plays Twenty Questions and learns about new objects as it goes along. In Part 1, you learned to create a system th
High memory usage with usercontrols in IE (using Debug Diag)
(Tess Fernandez) I was helping a colleague with an interesting case yesterday concerning a memory leak in IE when using winforms usercontrols.
Creating Agile Project Reports with TFS and Reporting Services – Part 1
(Eric Landes) In managing projects, I have come to utilize Agile Project Management methods to effectively manage software projects. When I say manage software projects, my definition of managing is to lead. No command and control management style enterprise drone. No, I prefer leading by example, a