|
Questionnaire I by Dinesh Priyankara (Published: May 12, 2008)
Prepared to cover-up for a couple cancelled sessions at the SQL Server Sri Lanka User Group meeting, the Q&A session was very successful; inspiring this article of T-SQL Q&A.
[ READ FULL ARTICLE ] [ RATE and COMMENT ON ARTICLE ]
KPIs in Analysis Services by Gogula G. Aryalingam (Published: May 12, 2008)
SQL Server 2005 Analysis Services, allows for the creation of KPIs on its cubes. KPIs were not available with SQL Server 2000. This introduction of KPIs to SSAS gives solutionists more power in delivering their solutions, since they need not go for separate software like Business Scorecard Manager or PerformancePoint Server just to build KPIs. This article takes a look at how to build and implement KPIs using SQL Server 2005 Analysis Services.
[ READ FULL ARTICLE ] [ RATE and COMMENT ON ARTICLE ]
Measuring Performance of Stored Procedures by Preethiviraj Kulasingham (Published: April 29, 2008)
Database developers need to write stored procedures which are not only fully functional, but also which perform acceptably. As database servers use permanent storage media heavily, which are known for slow performance, optimizing the stored procedures for performance is very important. This article concentrates on some of the counters used to measure performance and analysis methods of capturing these counters.
[ READ FULL ARTICLE ] [ RATE and COMMENT ON ARTICLE ]
T-SQL Enhancements in SQL Server 2008 - Part 2 by Dinesh Asanka (Published: April 21, 2008)
Following up on Part 1 of the same title, this article looks at the rest of the new T-SQL enhancements in SQL Server 2008.
[ READ FULL ARTICLE ] [ RATE and COMMENT ON ARTICLE ]
Constructing XML using 'FOR XML' by Harshana Weerasinghe (Published: April 09, 2008)
Over the past few years, software developers have used various kinds of technologies to retrieve data from relational databases. SQL Server 2000 is the first Microsoft DBMS to fully support XML. In this article I concentrate on writing about the FOR XML clause in both SQL Server versions, 2000 and 2005.
[ READ FULL ARTICLE ] [ RATE and COMMENT ON ARTICLE ]
T-SQL Enhancements in SQL Server 2008 - Part 1 by Dinesh Asanka (Published: March 31, 2008)
As the release of SQL Server 2008 is just around the corner, we are all looking for the new features of this new SQL Server version. Among the many new features and functionalities available with SQL Server 2008, this article series looks into T-SQL enhancements done for the new version.
[ READ FULL ARTICLE ] [ RATE and COMMENT ON ARTICLE ]
SQL Server 2008 - The hierarchyid data type by Gogula G. Aryalingam (Published: March 24, 2008)
Hierarchical data in SQL Server was stored using the parent/child approach and sometimes the XML data type. SQL Server 2008 introduces hierarchyid, a CLR data type for storing hierarchical data. This write-up focuses on how this data type can be used to create tables with hierarchical data, how to retrieve the data and index data.
[ READ FULL ARTICLE ] [ RATE and COMMENT ON ARTICLE ]
Nuggets from my SSIS Experience by Dinesh Priyankara (Published: March 17, 2008)
This article speaks about some of the issues faced by the Author, during his Data Integration Project using SSIS. Shared with you in this article are the issues he was faced with and the solutions applied. You may find this article helpful in your SSIS development.
[ READ FULL ARTICLE ] [ RATE and COMMENT ON ARTICLE ]
Switching from Non-IDENTITY to IDENTITY and vise versa by Jude Pieries (Published: January 3, 2008)
There may arise situations where it is necessary to switch a field from IDENTITY to non-IDENTITY, and sometimes the other way round. This article discusses these situations on how you were able to do it using SQL Server 2000, and how it can be done now in SQL Server 2005.
[ READ FULL ARTICLE ] [ RATE and COMMENT ON ARTICLE ]
Test Data Generation with Data Dude by Dinesh Priyankara (Published: December 26, 2007)
The Visual Studio 2005 Team Edition for Database Professional (a.k.a Data Dude) was released somewhere around December 2006 helping many Database Administrators and Database Developers. The release was huge for us, because it addresses many issues faced by us. One of the features comes with Data Dude is Test Data Generator. This note speaks about the Test Data Generator and how usage of it.
[ READ FULL ARTICLE ] [ RATE and COMMENT ON ARTICLE ]
Log Shipping in SQL Server 2005 by Dinesh Priyankara (Published: November 14, 2007)
Log Shipping is not a new technology that has been added to SQL Server 2005, but has been enhanced a lot more mainly providing disaster recovery and non-obligatory high availability. This note speaks about implementation of Log Shipping with SQL Server 2005.
[ READ FULL ARTICLE ] [ RATE and COMMENT ON ARTICLE ]
Declarative Management Framework - Performing Policy Management by Gogula G. Aryalingam (Published: October 17, 2007)
The Declarative Management Framework is a new policy based management framework included with the upcoming SQL Server 2008. Using this feature administrators can define policies to govern their SQL Server environments much like in the Windows environment. This article, written based on the SQL Server "Katmai" July CTP introduces you to the DMF and shows you how you can perform policy management.
[ READ FULL ARTICLE ] [ RATE and COMMENT ON ARTICLE ]
Populating Dimension Tables with the SCD Task by Gogula G. Aryalingam (Published: October 05, 2007)
ETLing dimensions through SQL Server 2000 DTS, has more or less been quite a a hassle, what with the lengthy ActiveX scripts and lookups that have to be performed. Enter SQL Server 2005 Integration Services: The Slowly Changing Dimension task has made it much simpler. As simple as a few clicks and minutes. This article talks about how a slowly changing dimension table can be populated using the Slowly Changing Dimension transformation task, which comes with Integration Services.
[ READ FULL ARTICLE ] [ RATE and COMMENT ON ARTICLE ]
Reporting Services Data Regions: Table Data Region by Dinesh Priyankara (Published: October 02, 2007)
Organizing data with a combination of different data visualizations is a rather complicated yet important task in report authoring. SQL Server Reporting Services 2005 includes more than three data regions that allow us to organize data easily. This article talks about one of the data regions; Table Data Region.
[ READ FULL ARTICLE ] [ RATE and COMMENT ON ARTICLE ]
SQLCLR - Part 1 by Joy Rathnayake (Published: June 13, 2007)
SQLCLR is the marriage of SQL Server and the .NET execution environment. In simple terms; it allows us to write code modules such as stored procedures, user-defined functions in the C# language. It however, does not mean that C# is going to replace T-SQL. T-SQL is still the best way to access data. Hosting the .NET Framework (CLR) within SQL Server opens up a new world for developers; giving them freedom to program SQL Server.
[ READ FULL ARTICLE ] [ RATE and COMMENT ON ARTICLE ]
Check Database Integrity Task by Dinesh Priyankara (Published: May 25, 2007)
Database maintenance is one of the most important roles of a DBA. Among the maintenance tasks that a DBA performs, maintaining the integrity of a database is crucial. This short-article demonstrates how to run DBCC CHECKDB by using one of the given tasks in SSIS under Maintenance Plan Tasks. We will be using Check Database Integrity Task to run the DBCC CHECKDB and Send Email Task to notify the result to someone responsible.
[ READ FULL ARTICLE ] [ RATE and COMMENT ON ARTICLE ] |