15/12/2004 11:16:41 AM
Here is my summary of the Reporting Services 2005 webcast which talks about the upcoming Report Builder functionality.
8/01/2005 12:07:06 AM
This article describes how a dynamic "current month" time filter can be created in an Analysis Services cube.
18/02/2005 11:34:12 AM
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.
23/02/2005 11:12:47 AM
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.
25/02/2005 11:19:21 PM
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.
26/02/2005 12:44:38 PM
Greg Low's 3 security summit session powerpoints are available.
1/03/2005 7:27:35 AM
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.
1/03/2005 7:30:10 AM
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/03/2005 5:38:56 PM
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.
11/03/2005 12:03:10 PM
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.