Featured Article(s) SQLXML : How To Save XML Query Results to a File Using BCP Creating XML from within SQL Server 2005/2008 has been greatly simplified with the introduction of the XML data type, FOR PATH mode, and the support for several XML XPath functions. However exporting these XML documents to an external file can still remain a challenge. This […]

Featured Article(s) Troubleshooting SQL Server 2005 Locking (Part 2) In this article, Alexander Chigrik explains some problems that you can have with SQL Server 2005 locking. He also tells how you can resolve these problems. PowerShell – Learning and Understanding It There isn’t any doubt that PowerShell is one of those technologies that can help out in your shop. You […]

Featured Article(s) How to Use the SharePoint PeopleEditor Control: Loading Data This post was really planned as a Part 2 to the first post I made about saving data from the PeopleEditor control. My aim for this entry is to tackle the reverse scenario: reading data from a field of type Person or Group and loading it into a PeopleEditor […]

It’s vConference Week! If you’ve waited to register, now’s the time. Get registered here! It’s easy and painless. Heck, you can even add-on a SSWUG membership for cheap! If you’re already registered, a couple of things to know: – You’ll be receiving an email with instructions on testing your system, how to get into the vConference, etc. KEEP this email […]

There is a lot happening at SSWUG – the community event, new article, new show today and the vConference next week! Community Event Today Starts at 9a Pacific – should last until mid-afternoon. Head here to register/attend: [Go Now] Featured Article(s) Understanding SQL Server 2008 Backup Compression SQL Server 2008 Backup Compression New SQL Server Video Show [Watch] SelectViews: The […]

Featured Article(s) Static Methods and Thread Safety A static method belongs to the class and a non-static method belongs to an instance of a class. That is, a non-static method can only be called on an object of a class that it belongs to. While a static method can access only static members, a non-static method can access both static […]

Featured Article(s) Troubleshooting SQL Server 2005 Locking (Part 1) In this article, Alexander Chigrik explains some problems that you can have with SQL Server 2005 locking. He also tells how you can resolve these problems. What is Your Process for Addressing Vulnerabilities? When you hear about issues with SQL Server-based applications, what do you do? I ask because there are […]

Featured Article(s) A New Approach to Cubing Data: The Need for Something Different OLAP cubes are steeped in well-documented benefits: speed of thought response times, hypothesis testing, business term presentation, and more. BUT they have some trade-offs such as LAN traffic for the cubing building process, external engines, single version of the truth, and more. Learn how a new technology […]

The SSWUG.ORG vConference – Last Full Week to Register! SQL Server, BI, .NET and SharePoint – amazing speakers and content. [More information here] Featured Article(s) SQL Server and SharePoint – The More You Know, the Better Off You Are IT dependencies on Microsoft technologies are becoming more and more pronounced — and the proliferation of Microsoft SharePoint is one reason […]

vConference Registration vConfernece registration is open and the conference is just around the corner – make sure you get registered right away – you can even take advantage of $30 SSWUG memberships… but time is running out. SQL Server, Business Intelligence, SharePoint and .NET technologies await, speakers you know and love from traditional in-person conferences, but we bring all the […]