Webcast Today: SQL Server Best Practices Having worked with databases for some time now, I felt it important to get some best practices documented. This presentation will touch on the simple things that we often take for granted while using our favorite database systems. From naming conventions, to cursors,to temporary, derived and variable tables, to the use of dynamic sql. […]

Want to Stay Up To Speed with SQL Server? Oct 15 – One Day Away! [Register Here] SQL Server 911 Extreme backup and recovery vWorkshop with Chris Shaw Oct 21, 22, 23 – SSWUG.ORG Virtual Conference [Register Here] 75+ sessions, expert speakers, time is running out to register! Oct 26, 27, 28 – Smart Database Design Class with Paul Nielson […]

Featured Article(s) Archiving Partitioned Data to the Cloud This article describes a solution to backup partitioned data to a cloud storage provider for long term retention. It also describes how to partition a table, partial backup concept, and cloud storage software. Featured White Paper(s) Inside SQL Server 2008: Management Studio improvements With the launch of SQL Server 2008, Microsoft has […]

Upcoming Learning/Demo/Events Here’s a look at what’s coming soon from SSWUG.ORG: SQL Server 911 vWorkshop with Chris Shaw – Really Understand Backup, Recovery and all of your options [Register Here] SSWUG.ORG Virtual Conference 75 sessions, expert speakers, time is running out to register [Register Here] Smart Database Design Class with Paul Nielson In-person, hands-on class about best practices, approaches and […]

Featured Article(s) Troubleshooting Replication subscribers not in sync Have you encountered a situation where the replication monitor does not show any errors but the users accessing the subscriber table keeps complaining of missing records? Featured White Paper(s) How to Achieve 40:1 Backup Compression with LiteSpeed for SQL Server’s SmartDiff SQL Server can do differential backups, which capture only the parts […]

Watch your email for a special VIP code to save $25 on the Virtual Conference – early bird will go away in days! [Check Out the vConference] Featured Article(s) Tips for using SQL Server 2005 indexed views Here you can find some useful tips to use SQL Server 2005 indexed views. Featured White Paper(s) SSIS Accelerator Series: Working with SSIS […]

Upcoming Events vWorkshop: SQL Server 911 Learn about what really matters with backup and recovery – including what you need to know if a recovery fails. This virtual workshop goes into all of the options and tools you have available to protect your systems. SQL Server MVP Chris Shaw will go through how backups work, how you know what types […]

Featured Article(s) Cloud computing and Database Part – 1 Cloud computing and Database – start learning more about these technologies that are key to future database work. SelecTViews Show On the show this week, hear from Kevin Kline and TJay Belt. Talking buy vs. build, consolidation lessons learned, the cloud, security and many other great tips. [Watch Now] Previous shows, […]

New SelecTViews Show On the show this week, hear from Kevin Kline and TJay Belt. Talking buy vs. build, consolidation lessons learned, the cloud, security and many other great tips. [Watch Now] Previous shows, available now: [Watch Now] Craig Utley and Jason Strate on SelecTViews. [Watch Now] Donald Farmer and Buck Woody on SelecTViews. Have You Registered for the Smart […]

Featured Article(s) Prevent users from overwriting changes made by other users – PART III Prevent users from overwriting changes made by other users Featured White Paper(s) Open Database Connectivity Database connections are the lifeblood of enterprise applications, administrating the secure and steady flow of information b… (read more) Upcoming Events Workshop: SQL Server 911 Are you aware that there are […]