Browse by Tags

All Tags » SQL Server 2008   (RSS)
PowerShell Provider for SQL Server Script of the Day - Script all objects
If you're using the PowerShell provider for SQL Server, you can quickly script out all of the objects in a "directory" using a simple method. Just navigate to the directory of objects you're interested in, say the "Views" of a certain Read More...
Posted 08 January 09 08:00 by Buck Woody | 0 Comments   
Filed under , ,
SQL Server Compliance Tools
I've been in a couple of firms that were suject to government regulations such as "Sarbanes Oxley" and HIPPA - and it can be a real challenge to put the safeguards in place that they require. In SQL Server 2008, we've included several new features such Read More...
Posted 10 December 08 06:34 by Buck Woody | 0 Comments   
Filed under
Enterprise Policy Management Framework
A good friend of mine, Lara Rubbelke, created a great framework for Policy Based Management. It uses a combination of PowerShell and Reporting Services along with PBM to help you track multiple servers, and keep them in compliance. She's posted the whole Read More...
Posted 08 December 08 09:56 by Buck Woody | 0 Comments   
Filed under ,
SQL Server 2008 Whitepaper Access Point
A special site is available to get at the whitepapers for SQL Server 2008. You can find that here: http://www.microsoft.com/sql/2008/learning/whitepapers.mspx . And here are a few of my personal favorites: Performance and Scale http://www.microsoft.com/sql/techinfo/whitepapers/sql_2008_perfandscale.mspx Read More...
Posted 04 December 08 09:33 by Buck Woody | 1 Comments   
Filed under , , , , , , ,
PowerShell and SQL Server - Use a Text File to Drive A Script
Happy Thanksgiving! If you're in the US, we give one day a year (although I'm thankful year-round) to giving thanks for all our blessings. Today I thought I might share a little technique I use to perform an action across a set of objects, using a text Read More...
Posted 27 November 08 08:41 by Buck Woody | 1 Comments   
Filed under , ,
Application and Multi-Server Management
Our team made some announcements at PASS about a new set of features we're working on, and it generated a lot of questions. If you're one of those folks, or if you weren't able to get to PASS this year, there are some good links I'd like to pass on about Read More...
Posted 24 November 08 08:57 by Buck Woody | 1 Comments   
Filed under
PASS 2008 Conference - Day Four
This morning started bright and early for the Manageability Team (MPU) that I'm a part of. We hosted a breakfast for a select group of Most Valuable Professionals (MVPs) for SQL Server to go over some of the information we presented yesterday in the keynote, Read More...
Posted 20 November 08 09:07 by Buck Woody | 1 Comments   
Filed under ,
PASS 2008 Conference - Day Three
Well, the "official" start of PASS was today, and it opened with a bang! Ted Kummert, the "head guy" of the entire SQL Server product, gave the keynote and he introduced a lot of the new technology we're working towards. First things first: We're releasing Read More...
Posted 19 November 08 08:25 by Buck Woody | 1 Comments   
Filed under ,
TechEd Europe 2008 Day Five – Policy Based Management
Bringing all the concepts I've described in the last few posts into place, you can see the results of what Alexi wants in a Policy. Navigating to the Management node in SQL Server Management Studio, he can create a new Policy, give it a name, and since Read More...
Posted 10 November 08 06:49 by Buck Woody | 1 Comments   
Filed under ,
TechEd Europe 2008 Day Four – Policy Based Management
I’ve presented 6 sessions so far at TechEd Europe in Barcelona, and I’m explaining the how and why of the basics of Policy Based Management. Today I wanted to clear up a few terms that we use in PBM. The example I use in the demos is of a DBA named Alexi Read More...
Posted 08 November 08 05:46 by Buck Woody | 1 Comments   
Filed under ,
TechEd Europe 2008 Day Three – Policy Based Management
Following on from yesterday’s post, I wanted to develop this idea of “intent” in management. What we mean by that is that you should be able to declare your intent about a situation on your server, such as “I want to make sure that all stored procedures Read More...
Posted 06 November 08 01:52 by Buck Woody | 1 Comments   
Filed under ,
TechEd Europe 2008 Day Two - Policy Based Management
Yesterday I gave two presentations to the attendees at TechEd Europe here in Barcelona, Spain. The first was on “A Day in the Life of the DBA”, which I’ve blogged about previously. The second presentation was on an overview of Policy Based Management. Read More...
Posted 04 November 08 11:02 by Buck Woody | 2 Comments   
Filed under ,
Opening SQL Server Profiler from SSMS
The new Activity Monitor has another trick up its sleeve: If you open it and then expand the first band of information just below the four graphs, you'll see a list of processes that you can order, sort and filter. If you right-click any process, you'll Read More...
Posted 28 October 08 06:16 by Buck Woody | 2 Comments   
Filed under , , , , ,
A few minutes of the virtual...
This is pretty cool – the first 10 minutes or so of one of the virtual conference I did earlier last month is now available for free online. You can see it here: http://www.vconferenceonline.com/speaker.asp?id=BWoody Read More...
Posted 23 October 08 06:21 by Buck Woody | 1 Comments   
Filed under ,
SQL Server 2008 Feature Pack
This is to let you know that the SQL Server 2008 Feature Pack for October is now available. What’s in this release? Find more details here : · ADOMD.Net · AMO · DMViewer · PowerShell extensions for SQL Server Replication Management Objects · Report Builder Read More...
Posted 21 October 08 08:22 by Buck Woody | 0 Comments   
Filed under , ,
More Posts Next page »
Page view tracker