Featured Article(s) XML DOM Advanced XML DOM is the W3C standard for accessing the content and structure of XML documents. It provides a number of interfaces for accessing the XML document. The hierarchical tree structure consists of a number of Nodes. A number of interfaces are present for the creation and manipulation of nodes in an XML document. Since XML […]

Announcing: DBA School – Learning SQL Server for the Rest of Us A new three-day course taught by Stephen Wynkoop and Chris Shaw – centered around real-world experiences, how-to information and specific demonstrations and labs that will let you use and explore the topics covered. We’ll be covering Performance, Management, Auditing, Security, Disaster Recovery and Very Large Database considerations. Find […]

Featured Article(s) Working with Language Integrated Query in C# – [Part I] Language Integrated Query, or LINQ as it is called, ships with the Microsoft .NET Framework and provides an easy way to access data, execute queries, and model your databases using .NET objects. This is the first part in the series of articles on Language Integrated Query. Tomorrow: Special […]

Deadlocks, Explained You just have to see this. It’s an instant classic. Ever wanted to explain deadlocks to someone? Now you have a quick drawing to do so. Great stuff. Take a look here. Featured Article(s) Tips for using SQL Server 2005 Distributed Queries Here you can find some useful tips to use SQL Server 2005 distributed queries. Webcast Today: […]

Featured Article(s) SSEE, WSS, MOSS and SQL Server 2005 Express The purpose of this article is to simply clarify what type of database the stand-alone installation of WSS 3.0 actually uses. There seems to be a lot of confusion around the different versions of SQL Server that are available and how those versions relate to SharePoint so let’s see if […]

Featured Article(s) Mastering Microsoft Business Intelligence: Introducing Named Sets in Analysis Services, Pt. 3 Part 3: Get hands-on exposure to Named Sets within Analysis Services. Join BI Architect Bill Pearson as he introduces the Mastering Microsoft Business Intelligence series, another new SSWUG exclusive. Webcast: How to Hire a DBA Part 3 of 3 Are you looking to hire a DBA? […]

Featured Article(s) Oracle 2-Day DBA in x Days Post 18; UNDO Tablespaces Ok, so what are these UNDO Tablespaces all about and how do I manage them? Important Law Changes are Happening – Did you know? Did you know that states are passing laws that will impact how you deploy your systems? I noticed this article from several references to […]

Featured Article(s) Mastering Microsoft Business Intelligence: Introducing Named Sets in Analysis Services, Pt. 2 Part 2: Get hands-on exposure to Named Sets within Analysis Services. Join BI Architect Bill Pearson as he introduces the Mastering Microsoft Business Intelligence series, another new SSWUG exclusive. Windows 7 and SQL Server (and Windows Server 2008 R2 RC) There is a new knowledge base […]

Featured Article(s) Using System Monitor to tune SQL Server 2005 (Part 2) Here are some helpful tips to use System Monitor with SQL Server 2005. Virtual Conference Starts Today [ Enter Here ] – looking forward to seeing everyone there! Chris and I will be going over our top 10 scripts (each) today live – debating top picks and getting […]

Featured Article(s) Mastering Microsoft Business Intelligence: Introducing Named Sets in Analysis Services, Pt. 1 Part 1: Get hands-on exposure to Named Sets within Analysis Services. Join BI Architect Bill Pearson as he introduces the Mastering Microsoft Business Intelligence series, another new SSWUG exclusive. Last Day to Register is Today – vConference Begins Tomorrow Don’t forget – the vConference begins tomorrow […]