Free SQL Server Administrator’s Expo – Friday
[Register Here]
SelectViews Show
SQL Server service packs, VS CTP, SQL Server features and applications, SQL Server Tip: Auditing your systems.
End-user SharePoint resources for your systems, new mobile devices with SharePoint, upcoming events and more.
[Watch the Show]
Be Sure to Register ASAP
We have several things coming up to learn all about SQL Server – from Accidental DBA-type things (DBA School) to Full-up 75-session events (vConference):
– SQL Server Admin Expo – Apr 26 – Free event – 3 sessions by excellent speakers, about SQL Server administration
– Spring 2010 SSWUG.ORG Virtual Conference – SQL Server, Business Intelligence, SharePoint – 75 sessions, 20 speakers…
– DBA School – (50% sold-out already) 15 ppl max – Apr 19, 20, 21 – In-Person class that focuses on the things you really need to know – and shows/teaches how to apply it.
Want to Help Form a Future SQL Server Feature?
Microsoft Connect is a service that lets you submit ideas, provide feedback on other people’s submissions, search reported issues and so-on. It is an important line to the teams at Microsoft, and one area is, of course, SQL Server.
There was a discussion on the email discussion lists about an item that’s been submitted to update the use of TempDB. Here’s the synopsis:
"Rather than have a central tempdb, wouldn’t it be better to add a temp filegroup to each database, and to perform the sorting/joining/worktable/temptable activities within this filegroup."
You can take a look at the item details, see some of the discussions around it and more at the Connect site, located here. When you visit, you’ll see that Microsoft has responded a couple of times – this is a great example of how the system works – but I’m asking for some help. While I didn’t submit the item, if you read it over and have suggestions for alternate ways that TempDB could be managed, please feel free to post them. It would be great to get some assistance and ideas presented.
While you’re there, take a look through other reports on areas you might be working on. While this item is closed, you can still comment on it and vote "up" or "down."
Webcast: High Availability Through SQL Server
With failover clustering, data mirroring, peer-to-peer replication, and log shipping available there is an option or two for every scenario. While each technology has a place in the world, they aren’t interchangeable and provide the greatest benefit when applied to the proper solution. A walkthrough of each of these technologies and where they fit in your environment.
Presented by: Jason Strate
> Register Now
> Live date: 2/24/2010 at 12:00 Pacific
Featured Article(s)
Emulate Inheritance In Your Relational Database
One of the reasons object oriented programming has become so popular is the ability to re-use code. Once that code is perfected, it does not have to be repeated. Applying the same principal to a relational database you reap the same benefit of re-use and reduced effort. In this article I explore one method of emulating inheritance in a relational database design.