There are countless sources for information on SQL Server available today. There are books, webcasts, conferences, and blogs. With all of these sources, it is easy to forget that there are white papers available from Microsoft. It is important that we make an effort to read the white papers that are available. The trouble is, [...]
Last week, a new white paper was released that discusses supportability roadmaps for ISVs. The white paper is Testing and Developing Supportability Roadmaps for Independent Software Vendor Applications. What a mouthful… aren’t you glad you aren’t working at an ISV? Well, even if you aren’t I’d recommend reading this white paper because it applies to [...]
If you talk to Sarah (twitter), she’ll tell you that I like lists. Lists are awesome – they are almost like non-structured data. They are hierarchies of information that I can work with. They are Data. Microsoft must have known I liked lists because over the weekend I discovered (see below) their SQL Server Best [...]
One of SQL Server 2008 features I’ve been especially thrilled about is the Management Data Warehouse (MDW). Just recently, Microsoft released a white paper by Kalen Delany that goes into a bit a depth on MDW and covers some best practices and things to watch out for. Happy reading!
One of the things I get to do pretty often is to visit with clients and discuss how they’ve implemented their SQL Server environment. And if the title of this post is any indication of the contents there are a number of issues that I tend to be able to make recommendations on in all [...]
While working on some parallelism issues today I started using the query that detects whether there are queries currently running utilizing parallelism. It’s the same query that can be found in the white paper Troubleshooting Performance Problems in SQL Server 2005. Which I’ve included below: SELECT r.session_id, r.request_id, MAX(ISNULL(exec_context_id, 0)) as number_of_workers, r.sql_handle, r.statement_start_offset, r.statement_end_offset, [...]
I keep hearing this story and similar variations… ”On a dark and stormy night, I developed a SQL Server Integration Services (SSIS) package. It worked wonderfully on my desktop development environment. All the files were properly accessed and the data was processed in a magnificent matter.” ”But suddenly I deployed the SSIS package to production [...]
I was working through some performance issues on a "fun" table. A bit of half a billion rows and with some apparent I/O issues as the entire table is being read by some of the clients services to create an extract. In working through some of the performance bottlenecks, I found the following white paper [...]
A good read on the benefits of going to Enterprise Edition on SQL Server 2005… sure I contributed to the white paper but that would never color my vision… Empowering Enterprise Solutions with SQL Server 2005 Enterprise Edition.
There is a new white paper out regarding connectivity with SSIS to various data sources. These include connections to SQL Server, DB2, Oracle, Access, Excel, and other file-based database systems. There is some nice information in there. The summary from the white paper: This white paper enumerates the connectivity options for databases with SQL Server [...]