PowerShell For SQL Server Yesterday I was looking in Google for syntax on a PowerShell commandlet and I came across a rant from a DBA complaining that they now had to learn PowerShell on top of everything else a DBA does. I had to take a look, and I found a nice gold nugget I had missed. With the release […]
Editorials
Disk Fragmentation
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 […]
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 […]
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 […]
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 […]
Multiple Indexes on a Single Table
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 […]
Surviving the Holidays
Virtual Eduction in SSIS and SSRS A while back Steve provided some great insight on how to grow your skills as an SQL Professional. Take one new topic at a time, and expand on what you already know. The reality we face every day is that SQL Server consists of a number of technologies that are quite extensive; it is […]
How was your Holiday?
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 […]