Tuesday, December 11, 2018
Task Pane 
Remember Me
Our Sponsors
Current Poll
SQL Server 2008
Are you ready for the upcoming SQL Server 2008 release?

[show results]
Article Categories
SQL Server Programming Programming techniques and tips etc
SQL Server Administration SQL Server Administration
SQL Server Analysis Services Analysis Services design & admin tips etc
SQL Server TSQL Code Samples SQL Server TSQL Code Samples

 All Articles

12/15/2004 11:16:41 AM Author: Rowan
Report Builder in SQL Server 2005
Here is my summary of the Reporting Services 2005 webcast which talks about the upcoming Report Builder functionality.
1/8/2005 12:07:06 AM Author: alex_v
Dynamic time filtering in Analysis Services
This article describes how a dynamic "current month" time filter can be created in an Analysis Services cube.
2/18/2005 11:34:12 AM Author: philcart
Changing SQL Server Passwords
SQL Server 2000 does not have the best or most secure password mechanism. In fact it does a pretty poor job of managing passwords and forcing changes. From the very knowledgable web team over at Orcsweb, a short article on how you change passwords in code.
2/23/2005 11:12:47 AM Author: philcart
Access to SQL Server: The Upsizing Wizard
SQL Server 2000 is the basis for the new Access database storage. However there are still many cases where applications developed on Access are outgrown and need to be moved to SQL Server to support the load. Author Kathi Kellenberger brings us a look at the Upsizing Wizard and how you can move your databases to SQL Server.
2/25/2005 11:19:21 PM Author: philcart
Database Standards and Conventions
Having a good set of naming conventions for your SQL Server objects is one of the most vital things to a company. In the long duration of a business, it saves money and time as programmers are transferred internally and don't need to relearn object names. As learning curves lower, cost lowers. This article covers some of the conventions that Brian Knight uses and why he uses them.
2/26/2005 12:44:38 PM Author: greglow
Security Summit 2005 SQL Server 2005 Presentations
Greg Low's 3 security summit session powerpoints are available.
3/1/2005 7:27:35 AM Author: philcart
The Perils of Fiber Mode
Ken Henderson explains the effects that SQL Server fiber mode coupled with the User Mode Scheduler component can have on your system, and what to consider carefully before enabling fiber mode.
3/1/2005 7:30:10 AM Author: philcart
Comparison of SQL Server 2005 Editions
On February 24th, 2005, Microsoft announced the new editions and pricing of SQL Server 2005. There have been quite a few changes and MVP Brian Knight has put down a comparison as well as details about which features are included with each. Read about the 4 new additions and see which one might be right for your next project.
3/3/2005 5:38:56 PM Author: philcart
Recursive Queries in SQL Server 2005
Part 2 of new T-SQL enhancements from Srinivas Sampath. SQL Server 2005 contains a number of enhancements designed to allow you to write more powerful queries while keeping the code structured in a way that makes development and understanding it easier. Building on his first look at Common Table Expressions, Srinivas now looks at recursive queries with CTEs.
3/11/2005 12:03:10 PM Author: philcart
Hits and Misses
Squeezing every last bit of performance from SQL Server is an art and one that can be critical to your success as a DBA. New author Mike Metcalf has brought us a little nugget he learned at Devcon recently about procedure cache hits and misses.