The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
Simply deploying SQL Server 2005 without using its security features puts you at risk. Follow these defense-in-depth steps to secure the database server before, during, and after installation.
By Kevin Kline
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 Development Studio (BIDS). Here are several that you should add to your toolkit.
By Blake Eno
By
By Erin Welker
Virtually any object in Analysis Services 2005 can be scripted in XMLA. Here's a checklist for scripting objects and a sample script.
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 Michael Otey
BI is definitely not just Microsoft hype. The value in BI technologies is how they help businesses obtain more information from their data.
By John Green
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.
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 concepts to help you decide whether to migrate or rebuild your cubes.
By Tyler Chessman
Microsoft Excel 2007 PivotTables give you more ways than ever to analyze and present data from SQL Server Analysis Services 2005 OLAP cubes.
By Kalen Delaney
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.
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 downloading.
By Itzik Ben-Gan
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 a given event date.
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 John Howie
Apply protection at the perimeter, network, host, application, data, and physical environment layers of your database installation.
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 Yoel Martinez
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
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 Bill McEvoy
Using sp_ShowErrors to view SQL Server errorlog files is time-saving alternative to manually reviewing them in Enterprise Manager.
By Umachandar Jayachandran
advertisement