Carpe Datum
Data Flotsam and Jetsam
Browse by Tags
All Tags
»
SQL Server 2008
(RSS)
Administration
Conferences
Connections
Customer Contact
DBA
Design
Developer
Development
Documentation
Downloads
Help
Latest Version
Links
Maintenance
Management
Microsoft
Microsoft Update
PBM
Performance Tuning
Planning
Policy Based Management
PowerShell
Process
Questions
Scripts
SQL Server
SQL Server Downloads
SQL Server Management Studio
SSMS
Tips
Tutorials
Upgrades
Walkthroughs
Web
Windows 2008
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
More Posts
Next page »
Search
Go
This Blog
Home
About
Email
Having trouble with a feed from this site? Post a reply to any blog entry.
Tags
Administration
Business Intelligence
Career
Computing
Conferences
Connections
Customer Contact
DBA
Design
Developer
Development
Disaster Recovery
Documentation
Downloads
Encryption
Error Codes
Help
Indexes
Latest Version
Links
Locks
Longhorn
Maintenance
Maintenance Plans
Management
Metadata
Microsoft
Microsoft Update
MSDN
PASS
PBM
Performance Tuning
Personal
Planning
Podcast
Policy Based Management
PowerShell
Process
Questions
Quote Of The Day
Rant
Real World DBA
SCOM
Scripts
Searching
Security
Service Packs
SOA
SQL Server
SQL Server 2000
SQL Server 2008
SQL Server Documentation
SQL Server Downloads
SQL Server Management Studio
SSIS
SSMS
Standard Reports
Strings
Support
System Center Operations Manager
Technet
Testing
Tips
T-SQL
Tutorials
Upgrades
Virtualization
Walkthroughs
Web
Windows 2008
Archives
January 2009 (6)
December 2008 (23)
November 2008 (19)
October 2008 (24)
September 2008 (22)
August 2008 (22)
July 2008 (21)
June 2008 (21)
May 2008 (21)
April 2008 (25)
March 2008 (23)
February 2008 (22)
January 2008 (21)
December 2007 (15)
November 2007 (18)
October 2007 (23)
September 2007 (21)
August 2007 (21)
July 2007 (1)
June 2007 (3)
May 2007 (3)
April 2007 (3)
March 2007 (2)
February 2007 (3)
Syndication
RSS 2.0
Atom 1.0