(Abey George) To be frank, I have not used it in any of my projects, though i was keen on knowing it.
Author: SSWUG Research
Encryption enhancements in SQL Server 2005
(Kevin Beaver) Before the days of SQL Server 2005, you could encrypt passwords, data in transit and, well, just about everything except the one thing that’s most important: data at rest. These older encryption features also tended to be cumbersome, which prohibited developers and DBAs from taking ad
Building the Address control: Part I
(Michael Livshitz) Each developer has some “idle” period when one of her/his projects is already finished (may be that needed to be made it is one-two “clicks”), and the next one should be begun in a month. Well! Now you do have some time to share your idea with someone for whom it can be interes
.NET Overview, Advantages And Features
(TeachMeIT) The article also provides an insight into the benefits of the .Net technology for the learner, be they, individual users or developers.
HOWTO: Pick an open source license (part 1)
(Ed Burnette) You’ve made the decision to release your code as “open source”. Ok, what does that mean, what is an open source license, and how do you pick the right one? This question comes up all the time so I thought I’d write up a simple decision tree to try to explain the choices. This isn’t leg
Analysis: Microsoft’s Business Intelligence Power Grab
(Stephen Swoyer) Unless you’ve been off siesta-ing in a data warehouse appliance, you probably know that Microsoft Corp. last week dropped a bombshell on the business intelligence (BI) industry. Redmond outlined an Office-focused BI and performance management (PM) strategy that—for the first time—ca
Using Synonyms in SQL Server 2005
(Mike Gunderloy) If you’ve been developing with SQL Server for any length of time, you’re undoubtedly used to referring to objects with four-part identifiers: [[[server.][database].][schema_name].]object_name
Generation of efficient parsers through direct compilation of XML Schema grammars
(E. Perkins, M. Matsa, M. G. Kostoulas, A. Heifets and N. Mendelsohn) With the widespread adoption of SOAP and Web services, XML-based processing, and parsing of XML documents in particular, is becoming a performance-critical aspect of business computing. In such scenarios, XML is often constrained
Easing the Cost of Compliance
(James Pickel) The Sarbanes-Oxley Act and other regulations require corporate executives to provide and ensure increased levels of financial and operational discipline. To help comply with this law, most enterprises are now implementing measures that cross financial reporting and processes that impa
How to Detect Table Fragmentation in SQL Server 2000 and 2005
(Satya Jayanty) How do you know when a table is fragmented? –Poor query performance over time. –More disk activity. –Poor cache utilization. –Verify the I/O of a query. –Verify scan density in SQL 2000 using DBCC SHOWCONTIG and in SQL 2005 using the dynamic management view sys.dm_db_