SQLServerCentral.com ArticlesArticles posted on SQLServerCentral.comEmail reports directly to the hands of your Executives- June 25, 2008 Generate formatted reports specifically for executives using PDA devices.http://www.sqlservercentral.com/articles/Reporting/62980/ Taming Trees: B-Trees- June 25, 2008 Learn how to build a B-tree similar to those used by databases to implement indexes.http://www.sqlservercentral.com/redirect/articles/63448/ Create a computed column in SQL Server using XML data- June 25, 2008 Create a computed column in SQL Server using XML data and optimize SQL queries. Learn how to create a function for XQuery and use it within the computed column formula.http://www.sqlservercentral.com/redirect/articles/63445/ Parameterizing Number of Look Back Periods with the MDX LastPeriods() Function, Part I- June 24, 2008 Parameterization of MDX functions is one of those things that cannot be delivered solely via graphical MDX Editor but then, you really didnt think that you could avoid actually touching MDX at all, did you BI Architect Bill Pearson demonstrates a way to parameterize the highly useful LastPeriods() function.http://www.sqlservercentral.com/redirect/articles/63443/ SQL Server Disasters with Preventive Measures- June 24, 2008 Have you seen disasters in your environment I would bet you have at some point. Let's see if our top 13 disasters matches your experiences.http://www.sqlservercentral.com/redirect/articles/63453/ Exporting and Versioning Lookup Data: A Real-World Use of the CLR- June 24, 2008 The CLR has not been well-received and most people use it for Regular Expressions and string functions. Here is an example that goes beyond trivial uses.http://www.sqlservercentral.com/articles/SQL+Server+2005/63300/ T-SQL Data Processing- June 23, 2008 This article from new author Peter Kierstead shows us how to implement your own "fuzzy" dedupmerge logic without resorting to RBAR in T-SQL.http://www.sqlservercentral.com/articles/T-SQL/63233/ Forum Etiquette: How to post datacode on a forum to get the best help- June 23, 2008 Get correct answers to your SQL forum questions faster by making it easier to load your sample data and read your code.http://www.sqlservercentral.com/articles/Best+Practices/61537/ Transparent Data Encryption in SQL Server 2008- June 23, 2008 This article describes how the Transparent Data Encryption feature in SQL Server 2008 can be used to secure your databaseshttp://www.sqlservercentral.com/redirect/articles/63449/ Execute SQL statements in Integration Services- June 23, 2008 This tutorial walks you through the process of adding SQL statements to your SSIS packages and bundling them into logical units of work if necessary.http://www.sqlservercentral.com/redirect/articles/63393/ |