Featured Article(s) Introduction to Windows Presentation Foundation With strong emphasis on declarative programming, Windows Presentation Foundation (WPF) formerly code named "Avalon", stands out as one of the most widely popular components added to the new versions of Microsoft .NET Framework for designing and developing applications visually stunning and rich user interfaces. This is the first in the series of articles […]

Featured Article(s) Tips for using SQL Server 2005 Database Console Commands (Part 3) In this article, Alexander Chigrik shows how you can optimize SQL Server 2005 performance by using database console commands. Cool Contest Have you seen this? They’re holding a contest looking for the biggest, baddest DTS package – and they even have a prize every month. Pretty cool. […]

Featured Article(s) Some simple T-SQL programming benefits of SQL 2008 The following article list some simple but very useful benefits for upgrading to SQL 2008 that makes T-SQL use easier. Its a good practice to use these new T-SQL enhancements. Working with Idera, SQL Sentry and Others? We need your feedback! We’re working with VendorRate to produce community-oriented and provided […]

Featured Article(s) Attach all databases in a single sp execution The following procedure called usp_AttachAllDBFromINI takes a database name and mdf files list that resides in an INI file. The procedure loops over the file and attaches all databases listed in it to the server. Do You Have Your SQL Server Operators and Notification Set Up… Yet? I am repeatedly […]

Featured Article(s) Maintenance Plans Gotchas SQL Server 2005 It almost looks as if SQL Server 2005 Maintenance Plans have been tossed into a blender with SQL Server 2000 DTS. In my opinion, for what its worth, I like the new look. But what should you watch out for… Final Thoughts on "Trust, But Verify" Jon writes "For SQL it should […]

Featured Article(s) Introducing the F# Programming Language The F# programming language an object oriented and functional multi paradigm programming language (combines the best of the best features of other languages) based upon OCaml, is freely available from Microsoft. It is a functional programming language that can be executed on top of Microsoft .NETs managed platform and provides a lot of […]

Featured Article(s) Tips for using SQL Server 2005 Database Console Commands (Part 2) In this article, Alexander Chigrik shows how you can optimize SQL Server 2005 performance by using database console commands. Due Diligence in a Smaller IT Shop Some great feedback on the "Trust, But Verify" discussion from yesterday. Please send in your thoughts here. Stephen: "This is an […]

Protecting Your Systems… from DBAs? Karen wrote in with a link to this story about a DBA that was caught stealing, then dismissed, of course. On the way out, they decided to take down the database for the company, effectively putting the company out of business. Lovely. There are a number of things that come from this story. First, the […]

2009 at SSWUG.ORG 2009 will be a killer year here at SSWUG – we have a series of new, exciting things that are coming to the site that will continue to make sure you can find what you need (and make it much easier to do so), contribute and even find local SSWUG affiliated user groups. We’ll be rolling things […]

Granting Access vs. Creating Reports Randy writes in with some feedback and thoughts about the question of whether it’s best to give your end-users full access to your databases so they can build their own reports, or is it better to build custom reports as needed, so you don’t have to give access… "It depends on the setup of your […]