Featured Article(s) SQL Server 2005 Clustering Optimization Tips (Part 2) Here are some helpful tips to work with SQL Server 2005 clustering. Have You Registered Yet? There will be some amazing presenters at the conferences this fall – Julie Yack, Buck Woody, Kathleen Dollard, Scott Golightly, Tim Heuer, Ben Hoelting, Matthew Roche, Don Farmer, Brian Knight, Ted Malone, Sonya McNeal, […]

Data Use and Checks Some feedback from SSWUG Readers on this – good commentary – and ideas. I really do think that making proper use (whatever that is) of data is going to redefine what we do as DBAs. [Send in your comments here] Robert: "Information vs Data. Tree View Controls – that is the answer. Those who master the […]

Featured Article(s) Using the Merge Statement Inside an Application This article describes how to use the Merge statement with the Dual table to reduce the number of SQL calls and to simplify application code How Do You Vet Your Information? Not your data, your information. We’ve talked before in this space about data usage, how you manage data and such. […]

New SQL Server Show Posted Special: SQL Server 2008 Features: Chris Shaw takes a look at some of the new features of SQL Server – and how they work. This is a special airing of his session from the June Virtual Conference. [ Watch the Show Now ] Featured Article(s) Oracle 2-Day DBA in x Days Post 10; Oracle Automatic […]

Application-Aware Data Management I don’t know how I missed this article from InfoStor a bit ago, but it had me thinking… It sort of answers the call about the whole "how do I split up my databases for recovery, for performance, for reporting… and should I?" It doesn’t really ask that question, but if you think about what they’re saying […]

Featured Article(s) SQL Server 2005 Clustering Optimization Tips (Part 1) Here are some helpful tips to work with SQL Server 2005 clustering. EMC and Microsoft I don’t know if you’ve seen it, but Microsoft and EMC are really working closely together in a number of areas. One is the backup and recover area, and another is in the area of […]

Video How-To Available TSQL 103 – Part 3 of 3 of the TSQL Introduction Series from the Spring Virtual Conference. This is the final segment, reviewing tips and how TSQL works, essential query elements, etc. [ Watch the Show ] AJAX – Are You Doing Applications Work With It Yet? AJAX is the big thing happening right now – allowing […]

Featured Article(s) Provide login access to all databases in an instance Automating login creations and and assigning appropriate rights – a script. Does "Web 2.0" Help, or Hurt, Your Projects? I know there are some good tools out there, but when it comes to building out projects, creating new tools for your organization, do you think collaboration is paying off […]

Featured Article(s) Oracle 2-Day DBA in x Days Post 9; Oracle Automatic Memory Management Chapter 5 of the 2-Day DBA Guide has a nice couple of sections on Oracle memory. I’ll be hitting on them as always, giving my comments, and adding a little more where needed. New Video Posted Today TSQL 103 – Part 3 of 3 of the […]

Final SQL Server 2008 Feedback Items Just a few more SQL Server 2008 migration feedback bits to share – it seems that most are taking the update in stride and rolling it out as needed, as I mentioned before. Daniel: "We are constrained by the technical maturity of our industry. Some of the products we are dependent are still built […]