Featured Script replace_substring This stored procedure can be used to search and replace substring in the char, nchar, varchar and nvarchar columns in all ta… (read more) Disk Fragmentation Disk fragmentation is one of the primary causes for database performance degradation. When tuning a database for performance there is always tension for reducing fragmentation on many levels. Tables can be […]
Author: Ben Taylor
Are Stored Procedures the Only Way to Code SQL?
Webcast: Do It Right: Best Practices for Analysis Services 2005 and 2008 – Today at 12:00 Pacific Are you seeking practical, in-depth technical advice for building a BI solution using SSAS? Analysis Services changed tremendously with the advent of SQL Server 2005. It introduced a new way of building dimensions and cubes that required a new way of modeling the […]
Are Stored Procedures the Only Way to Code SQL?
Webcast: Do It Right: Best Practices for Analysis Services 2005 and 2008 – Today at 12:00 Pacific Are you seeking practical, in-depth technical advice for building a BI solution using SSAS? Analysis Services changed tremendously with the advent of SQL Server 2005. It introduced a new way of building dimensions and cubes that required a new way of modeling the […]
How to Write a Stored Procedure
Webcast: Do It Right: Best Practices for Analysis Services 2005 and 2008 – Tomorrow Are you seeking practical, in-depth technical advice for building a BI solution using SSAS? Analysis Services changed tremendously with the advent of SQL Server 2005. It introduced a new way of building dimensions and cubes that required a new way of modeling the solution. This session […]
How to Write a Stored Procedure
Webcast: Do It Right: Best Practices for Analysis Services 2005 and 2008 – Tomorrow Are you seeking practical, in-depth technical advice for building a BI solution using SSAS? Analysis Services changed tremendously with the advent of SQL Server 2005. It introduced a new way of building dimensions and cubes that required a new way of modeling the solution. This session […]
Testing CLR Code in SQL Server
Webcast: Do It Right: Best Practices for Analysis Services 2005 and 2008 Are you seeking practical, in-depth technical advice for building a BI solution using SSAS? Analysis Services changed tremendously with the advent of SQL Server 2005. It introduced a new way of building dimensions and cubes that required a new way of modeling the solution. This session examines the […]
Testing CLR Code in SQL Server
Webcast: Do It Right: Best Practices for Analysis Services 2005 and 2008 Are you seeking practical, in-depth technical advice for building a BI solution using SSAS? Analysis Services changed tremendously with the advent of SQL Server 2005. It introduced a new way of building dimensions and cubes that required a new way of modeling the solution. This session examines the […]
Connecting Your Applications to SQL Server
Webcast: Do It Right: Best Practices for Analysis Services 2005 and 2008 Are you seeking practical, in-depth technical advice for building a BI solution using SSAS? Analysis Services changed tremendously with the advent of SQL Server 2005. It introduced a new way of building dimensions and cubes that required a new way of modeling the solution. This session examines the […]
Connecting Your Applications to SQL Server
Webcast: Do It Right: Best Practices for Analysis Services 2005 and 2008 Are you seeking practical, in-depth technical advice for building a BI solution using SSAS? Analysis Services changed tremendously with the advent of SQL Server 2005. It introduced a new way of building dimensions and cubes that required a new way of modeling the solution. This session examines the […]
Open Source Database Change Management Framework
Webcast: Do It Right: Best Practices for Analysis Services 2005 and 2008 Are you seeking practical, in-depth technical advice for building a BI solution using SSAS? Analysis Services changed tremendously with the advent of SQL Server 2005. It introduced a new way of building dimensions and cubes that required a new way of modeling the solution. This session examines the […]