New SQL on Call Show Posted
SQLonCall: Working with third-party software tool and application vendors. As you build out solutions that depend on outside resources, there are some key things to remember as you work with them on your team.
> Watch Now
Also Available
[Watch] SelectViews –
[Watch] SQLonCall: Conferences and why you should consider attending
A Virtualization Tool You’ll Want to Have
Our friends at SQL Sentry have really been helping out a lot of people with virtualized environments. It might seem odd at first to think about the tool in that light, since it’s about managing your job subsystem. But, if you consider the resources that could be in contention in a shared, virtual environment, all of a sudden you see that you can make a *huge* difference in performance, reliability and functionality for your systems. How? By managing the resource impact of jobs and coordinating that impact across virtual instances on a server so the physical server can operate at peak efficiency. Find out how to control your schedules across virtual servers, physical servers and more. Get more information here – you won’t be sorry.
SQL Server Tools to Take a Hit?
A very thoughtful post from Scott Stonehouse caught my attention and had me thinking… He’s talking about the impact of services in the cloud – impact on tools, impact on environments not using those services in the cloud. Seems like a really reasonable observation, frankly. I do wonder how, as a company, Microsoft will be splitting resources between the cloud-type services, the enterprise class software and software for those running their own shops.
Add to this the fact that Microsoft is indeed getting into the hosting business for some large-scale accounts and the balance of power relative to tool development changes a bit. It begins to favor more one-up tools and more behind the scenes in-house tools and tricks. You see this frequently at service providers – "Wow – nice software you’ve developed to help manage your systems! Can we get a copy/buy it/whatever?" the answer can often be "sorry, no. It’s for internal use only."
I hope that the different environments will bring added exposure for product development – that’s a great thing. But I hope too that Microsoft does indeed keep their eye on the ball (along with third party software makers) and not slowly let the air leak out of tools or support for the local environments. I agree with Scott, I don’t think this would happen overnight, but it could happen over time, and I hope that we don’t see this.
Featured Article(s)
Tips for using indexes in SQL Server 2005 (Part 1)
Here are some helpful tips to performance tune and optimize SQL Server 2005 indexes.
Featured White Paper(s)
Making Databases Explorable
This paper looks at common difficulties encountered when maintaining a large number of databases and how the products in the … (read more)
SQL Server 2005 – Major New Features
This white paper highlights the new features of SQL Server 2005, including the user interface and the architecture changes, a… (read more)