By Kevin Kline, 03/22/2007
The SQL Server 2005 Analysis Services samples perform functions that aren’t otherwise available in SQL Server Management Studio (SSMS) or the SQL Server Business Intelligence ...
By John Howie, 03/22/2007
Apply protection at the perimeter, network, host, application, data, and physical environment layers of your database installation.
By Itzik Ben-Gan, 03/22/2007
This third part of a series about datetime challenges and calculations focuses on techniques for calculating the date of the last/next occurrences of a weekday that correspond to ...
By Erin Welker, 03/22/2007
The new terminology in SQL Server 2005 Analysis Services (SSAS) can seem intimidating, but you can simplify it by using this vocabulary equivalency chart.
By Yoel Martinez, 03/22/2007
With SQL Server 2005's three new LOB data types and CLR functionality, you can easily compress and decompress large amounts of data.
By Eli Leiba, 03/22/2007
Here's a stored procedure that displays all the T-SQL statements currently being executed along with the IDs of the processes running those statements.
By Itzik Ben-Gan, 03/22/2007
Get the solution to March's puzzle "Free Tuna," and prepare your mind for April's puzzle, which involves a king naming his heir.
By Umachandar Jayachandran, 03/22/2007
By Michael Otey, 03/22/2007
Before you buy Visual Studio Team Edition for Database Professionals, get more information about it with these 5 resources, including blogs, a forum, and a trial version for ...
By Erin Welker, 03/22/2007
Deciding to upgrade from Analysis Services 2000 to 2005 might be a no-brainer, but figuring out how to move your cubes can be a more complicated process. Here are some key ...
By Readers, 03/22/2007
If you often need to provide multiple values in a variable but find the 8,000-character limit too restrictive, give dbo.fn_AddToBuffer a try.
By John Green, 03/22/2007
Both Idera's SQL diagnostic manager and Quest Software's Spolight on SQL Server Enterprise can help you quickly detect and diagnose problems with your SQL servers.
By Tyler Chessman, 03/22/2007
Microsoft Excel 2007 PivotTables give you more ways than ever to analyze and present data from SQL Server Analysis Services 2005 OLAP cubes.
By Erin Welker, 03/22/2007
Virtually any object in Analysis Services 2005 can be scripted in XMLA. Here's a checklist for scripting objects and a sample script.
By Kalen Delaney, 03/22/2007
Identify and implement missing-index groups to tune your queries, and use SQL Server 2005's XML Showplan output feature to examine detailed missing-index information.
By Bill McEvoy, 03/22/2007
Using sp_ShowErrors to view SQL Server errorlog files is time-saving alternative to manually reviewing them in Enterprise Manager.
By Michael Otey, 03/22/2007
BI is definitely not just Microsoft hype. The value in BI technologies is how they help businesses obtain more information from their data.