Tales from the trenches.

Alan's profileTales from the trenches.BlogLists

Microsoft SQL Team Blogs

The following blogs contain essential information for the dedicated SQL Server DBA


SQL Server Development Customer Advisory Team SQL Server Customer Advisory team (SQLCAT). This team spends 75% of their time away from the halls of Redmond, Washington working directly with the largest and most challenging SQL Server implementations across the world.

SQL Server Engine Tips Guidelines, Best Practices, TSQL and SQL Programming Tips & Tricks.

SQL Server Manageability Team Blog Tools, scripts, webcasts, and miscellaneous tips that will help you get the most out of SQL Server.

SQL Server Performance Best Practices, Tips, Benchmarks, Troubleshooting and Monitoring - SQL Server, ADO.NET, Analysis Services, Integration Services and Reporting Services

SQL Programmability & API Development Team Our team implements some of the essential engine components like plan cache, metadata storage, framework for executing queries, type system, XML runtime, extensibility and CLR runtime.

SQL Server Protocols Discussions related to Microsoft's SQL Server Protocols - Netlibs, TDS and (new for SQL 2005) SOAP. Topics include connections and SQL connectivity.

SQL Server PSS Engineers This is the official team Web Log for Microsoft PSS SQL Support. Posts are mostly provided by the PSS SQL Escalation Services team.

SQL Server Query Processing Team The query processing team - query optimization & execution - providing tips, tricks, advice and answers to freqeuently-asked questions in a continued effort to make your queries run faster and smoother in SQL Server.

SQL Server Samples A blog about code samples for mainly Microsoft SQL Server.

SQL Server Service Broker Conversations A series of Service Broker examples.

SQL Server SSIS Information about SSIS from the point of view of a new Microsoft employee.

SQL Server Storage Engine

SQL Server Support Microsoft Technical Support Engineers post solutions to the most common issues we see in SQL Support!

SQL Server Synchronization All sort of information about synchronization technologies in sync and replication.

SQL Server Typed XML Main area of focus is typed XML. XML schemas, validation of XML instances against thoses schemas, and running XQueries over typed XML. Focus on issues specific to schemas and typed XML.

XML Team

I am an enterprise DBA for SQL Server and MySQL. I will post various "gotchas" encountered in live production environments. The names of the guilty will be omitted to protect the not so innocent. Life as a production DBA is always challenging and sometimes much more exciting than one would wish for. It seems that something comes up every week where searches take significant effort to craft the right question to get the desired answer. I will keep this blog short and point to the detailed explanations.

9:03 PM | Permalink | Blog it

Tales from the trenches.

Microsoft SQL Team Blogs

SQL Server Gotchas

Tales from the trenches

Profile

Alan Weber

Links

Books

Categories

When I was young.