SQL Server
Posts relating to SQL Server 2000 and 2005
While this topic is in Books Online for SQL Server 2005, I found it really handy as a quick reference for writing elementary and advanced Reporting Services expressions. http://technet.microsoft.com/en-us/library/ms157328.aspx
Read More...
I'm writing an SSIS package to iterate over the MOSS logs directory to import the logs into a SQL Server table (eventually a data mart) where I can write queries to pull out the information I need. What I plan to do is loop over the logs directory structure
Read More...
For my future reference (and yours as well), here is how to configure your SQL Server 2005 maintenance plans so that they operate correctly with MOSS. A great post by Jingmei Li. http://blogs.msdn.com/jingmeili/archive/2007/02/26/sql-server-2005-maintenance-plans-and-moss-2007-databases.asp
Read More...
Another nifty note about indexing. One of the more popular interview questions for technical folks is the various effects a change to a clustered index can have on nonclustered indexes. This post clears some of that up: Does rebuilding a clustered index
Read More...
Here is a great link on how to create a time dimension for a relational data warehouse in SQL Server. It's great that I won't have to worry about this again! http://sqljunkies.com/WebLog/enigma/archive/2004/02/04/940.aspx
Read More...
The following URL goes to the SQL Server Feature Pack which consists of a listing of SQL Server 2005 redistributable components and add-ons for SQL Server. If you have a server that only needs ADOMD.NET for example, or Notification Servers Client Components,
Read More...
Here is the link for the MOSS 2007/WSS 3.0 add-in for SQL Server Reporting Services. http://www.microsoft.com/downloads/details.aspx?familyid=4E50BE6E-3F92-4552-A78C-B3BE1D94D5DA&displaylang=en
Read More...
Here is a great article on how to leverage the unit testing engine built into Visual Studio to test SQL Server Reporting Services. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/VS05PLTSQL.asp
Read More...
The feature pack is a set of separate downloads that allow you to install components of SQL Server without installing the whole server product. Available at the following URL: http://www.microsoft.com/downloads/details.aspx?familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en
Read More...
I recently ran into a question regarding the scope of connection pools that .NET creates when applications require a database connection. The following feedback and link was provided by a colleague of mine in response to the question: As per the folloiwng
Read More...
Federated database design relates to carrying service oriented architecture into the database layer. Because SQL Server 2005 has several application server-like capabilities (i.e., SQL Server Integration Services, SQL Server Service Broker, Web Services
Read More...
Use SQL Server Service Broker for asynchronous transactional messaging from applications where transactional throughput and scalability is required, as well as rehydratable and failure resistant transactional consistency is required. The example would
Read More...
I recently resolved an error with the SQL Server 2005 Configuration Manager. Occasionally, during setup, some .mof files don't get installed and registered correctly. There is a program called mofcomp that is responsible for registering and storing the
Read More...
Of course, by now everyone is running Visual Studio 2005, riiight? [8-|] For those folks that are just beginning to install, check out this tool that will clean your machine of previous versions of pre-released Visual Studio 2005 and SQL Server 2005 and
Read More...
Here is a situation I recently ran across. We created a report which executed a stored procedure. The parameters being passed had default values, so that when they were not qualified, they would default to pre-assigned values. Thus, when these "optional"
Read More...
