Featured Article(s) RANK(), ROW_NUMBER(), and PARTITION to Solve Business Needs This article presents a business case and solution showing how Common Table Expressions, RANK(), ROW_NUMBER(), and PARTITION can be used to get specific sets of data, in a clear concise manner. The article provides an overview of the functions, and the procedures needed Experiences Keeping Up With Releases Kathy wrote […]

Great Webcasts on DMVs and SharePoint Don’t miss Quest’s instructive webcasts on SQL Server and SharePoint management, hosted by expert Brent Ozar. In “DMVs – What are They and Why Should I Care,” you will find out how to interpret the various performance metrics shown through the Dynamic Management View (DMV) and resolve issues faster. And in “The Converging Paths […]

Featured Article(s) SQL Server 2005 Transact-SQL Optimization Tips (Part 1) Here are some helpful SQL Server 2005 Transact-SQL tips. Using LINQ to… <insert platform/technology> Yet? I know a lot of people have been talking about the LINQ technologies and approaches to working with SQL Server. The object-oriented approach, the more integrated view of the database from the context of application […]

Last Day to Register Before the Virtual Conference SSWUG.ORG Virtual Conference – More than 100 sessions, 40 speakers, 3 days… AMAZING content. This is NOT your typical webcast, trust me. Top industry presenters, authors, MVPs and experts, downloadable transcripts of sessions, download the scripts from the demonstrations, see the presenter as they’re talking and showing off the technologies. There is […]

Featured Article(s) How to set Compatibility Mode for a Database Using T-SQL I participated in a database server migration from SQL Server 2000 to SQL Server 2005 and noticed some query performance issues that came up during testing. When a database is upgraded from SQL 2000 to SQL Server 2005 using backuprestore or sp_attach, the database retains its current compatibility […]

Only a few days remain to get registered… Featured Article(s) SQL CLR a new approach Microsoft SQL Server 2005/8 has extended the database programming to next level by integrating the MS .NET 2.0 CLR(Common Language Runtime) Features. Be Smart About Your SharePoint Installation… Make sure you have it backed up, make sure it’s recoverable and covered from a database and […]

Building a Safe SharePoint Extranet Yes, it’s possible. When you decide to make additional information available to your outside partners, suppliers and customer, SharePoint has some amazing tools to help. Getting things going, up and running and secure can be really challenging, but not if you have the right tools. Check out these great toolsets from SharePointSolutions – they will […]

Featured Article(s) Troubleshooting SQL Server 2005 Analysis Services problems (Part 5) In this article, Alexander Chigrik explains some problems that you can have when you work with SQL Server 2005 Analysis Services. He also tells how you can resolve these problems. Dig Into Your SQL Servers Getting detailed information to help you make informed decisions about how to tune, tweak […]

Have You Registered for the Virtual Conference Yet? 3 days, 120 sessions, 40 speakers… SQL Server, Business Intelligence, SharePoint, .NET Development technologies – at only $100 per area, you simply can’t go wrong. Webcast TODAY, Weds Understanding Key Fundamentals of SANs and SQL Server Learn about some key returns on investment that you can expect with SANs, along with best […]

Featured Article(s) Limiting Database View To Owned Databases On large SQL Server systems where an individual only has 1 database that is theirs many individuals do not want them being able to see ALL other database names when connecting via SSMS. This article walks through a solution allowing the user to only see their OWN database. PDC Kicks Off PDC […]