Don’t miss SQL Server 911 – June 5.
Featured Article(s)
SQL Server PowerShell : Basics
PowerShell is a great tool that allows DBAs and Developers alike to script, manage and automate SQL Server tasks. Most of the objects and tasks will require SMO (SQL Server Management Objects). This article gets you started with SQL Server PowerShell by walking you through the basic steps of setting execution policy, loading assemblies, different ways of connecting to SQL Server.
On Demand Webinar Series
Join SQL Server authors and MVPs on demand webinar series and get the latest on Microsoft Business Intelligence inside your environment. If you are in any stage of a data warehouse design, administration or planning these webinars on demand are a must. In these sessions, you will learn how to design a data warehouse, load it using SSIS, place a cube on top of it using SSAS and report against it using SSRS. Finally, you’ll see how to performance tune and scale the data warehouse using common techniques. All speakers have authored many of your favorite books from Wrox . There is some great learning available from these expert speakers – things you can put in place in your own applications right away. Get more information here.
Interesting Article Series – Relational Database Deployments
I noticed this very intriguing article series posted by Tony Bain – he’s talking about issues he sees with the deployment models of relational databases. While not specific to SQL Server, it does pertain to SQL Server in some of the examples and thoughts presented – check it out here.
The issues he’s presenting revolve around the difficulties in optimizing and managing relational database systems. From optimization of queries to managing workloads to different aspects of server sprawl and such, it’s full of good thought about what we’ll simply have to come to address at some point as databases mature and more simple query optimization becomes "not enough."
What has me thinking as I read through this article (and the part 2 linked at the top of the posting), is how this applies to the art of server consolidation. One of the things I hear more and more is that the server consolidation, virtualization and so-on that people are struggling with configurations, results, justification and successes with trying to optimize servers. It’s not about optimization of that server overall, instead, of course, your work has to include taking into account those peak queries, along with the slower times. It’s a tough battle to win.
Take a look at the article(s) linked here, then drop me a note – what do you think?
Featured White Paper(s)
SQL Server and SharePoint – The More You Know, the Better Off You Are
The SharePoint platform is growing and so is your role as a SQL Server DBA. This dependency creep may mean that you’ll be as… (read more)