September 2009 - Posts

References + Deck + SQL Samples from my System Management presentation on 20090929 @ MS Data Management Conference in London

Note that I will be going into more detail in a series of 30-40 minute LiveMeetings starting towards the end of October, please see sqlserverfaq.com for more information - I'll be posting the info this weekend so check back after then. The session abstract: This predominately demo based session explores the features around the management of SQL Server 2008, specifically the Management Data Warehouse (Data Collector) and its use as a problem determination tool and for capacity planning, using Powershell and SQLCmd for routine maintenance and its use in applications, Event Notifications and Extended Events for keeping an eye out for unfolding problems, Policy Based Management to protect your Production environment and Dynamic Management Views (DMV's) for your day to day administration. The demos will be used to build a real world working system.

If you want a copy of the database for the Data Collector (MDW) demo workload you can download it here: http://sqlcontent.sqlblogcasts.com/meetings/ms20090929_datacollectiondemo.zip (75MB); make sure you check out the attached ZIP which contains the script prompt I used which will help you find your way through - any questions just email me tonyrogerson@torver.net.

The SQL Demos and my demo talk script can be got from here: http://sqlcontent.sqlblogcasts.com/meetings/MS20090929_SlideDeck_SQLDemos_TalkNotesScript.zip 

References

Enterprise Policy Management Framework

http://www.codeplex.com/EPMFramework

SQL Server Policy Based Management Blog

http://blogs.msdn.com/sqlpbm/archive/2008/04/20/policy-based-management-overview.aspx

SQL Server 2008 Feature Pack

http://www.microsoft.com/downloads/details.aspx?familyid=B33D2C78-1059-4CE2-B80D-2343C099BCB4&displaylang=en

Keep up-to-date with any new policies

Get Report Builder 2.0“Administering Servers by Using Policy-Based Management” – “Configuring Alerts to Notify Policy Failures”: ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_4deptrbl/html/ef2a7b3b-614b-405d-a04a-2464a019df40.htm

Central Management System

http://sqlcms.codeplex.com/ (Buck Woody Microsoft)

Powershell

Free Powershell scripts -> http://www.idera.com/Products/Free-Tools/PowerShell-scripts/

Extended Events

http://www.codeplex.com/ExtendedEventManager/ (by Jonathan Kehayias SQL MVP)

Event Notifications

http://sqlblogcasts.com/blogs/martinbell/archive/2009/05/22/Event-Notifications.aspx

http://sqlblogcasts.com/blogs/martinbell/archive/2009/05/26/WMI-Event-Alerts.aspx

 

Posted 25 September 2009 10:01 by tonyrogerson | with no comments
Filed under: , , , , ,

My Systems Management session (20090929 in London) - Management Data Warehouse (Data Collector), Powershell, SQLCmd, Event Notifications and Extended Events, Policy Based Management

Quite a lot to cover in 45 minutes but my plan is to overview the areas in demo and a one slider and then attack each area from the beginning of October in more detail on LiveMeeting - going to sort the dates over the weekend.

Here is the new abstract:

SQL10 - Systems ManagementThis predominately demo based session explores the features around the management of SQL Server 2008, specifically the Management Data Warehouse (Data Collector) and its use as a problem determination tool and for capacity planning, using Powershell and SQLCmd for routine maintenance and its use in applications, Event Notifications and Extended Events for keeping an eye out for unfolding problems, Policy Based Management to protect your Production environment and Dynamic Management Views (DMV's) for your day to day administration. The demos will be used to build a real world working system.

See you there!

Tony.

Posted 25 September 2009 08:28 by tonyrogerson | with no comments
Filed under: , , , , , ,

Operations Manager on Windows 2008 Active Directory Machine - Discovery Failed

Thanks to Gordon Mckenna (http://www.inframon.com/) for sorting this for me.

For my demo environment I've 3 VM's - one an Active Directory machine and the other two nodes of a cluster all running Windows 2008 R2 Enterprise.

I wanted to run Ops Manager on the AD machine so installed W2008 Dev and applied SP1.

Got Ops Manager installed fine, but using the discovery wizard it always came back "Discovery Failed"

Solution: sp_changedbowner to 'sa' for the OperationsManager database.

Thanks Gordon - your a star!

Posted 23 September 2009 20:00 by tonyrogerson | with no comments
Filed under:

SQL User Group meeting this Wednesday in Reading - MS Support Engineers Discuss also Tony Rogerson on DR/Business Continuity

Don't forget this Wednesdays user group at Microsoft in Reading, please visit http://sqlserverfaq.com?eid=169 to register; briefly we have Clive Challinor, SQL Core Escalation Engineer and Daniel Sol, SQL Server Technical Support Engineer talking about Cluster Setup and SQL Memory considerations amongst other general things and we also have myself talking about DR, basically Edition Features - a talk around what's available to you, Defining the strategy, Licencing, Backup and Restore discussed - how it works, the concepts, point in time recovery, Log Shipping fundementals and Mirrorings Fundementals - the majority of the presentation will be demo's; oh, and the chance to network etc....  

Agenda:

5.30pm – 6:00 Registration and networking + Tea/Coffee with biscuits.

Meet and greet.

6:00pm – 6:30pm Round Table discussion and Nuggets - ALL

Take stock and get the latest news in the SQL Server field. This is also a great opportunity to ask any burning questions you have, may be a problem at work.

It's also a great opportunity to share your knowledge and gain exposure in the industry by giving a short 1 - 6 minute "nugget" demo/tip.

6.30pm – 7:30pm

Clive Challinor, SQL Core Escalation engineer and Daniel Sol SQL Server Technical Support engineer

SQL 2008 Cluster Setup by Clive
SQL Memory Considerations by Daniel

Q & A.

7:30pm – 7:50 BREAK: Light refreshments

More time to network and ask questions...

7:50pm – 9.00pm

Building a Resilient Environment - Backups/Restore; Log Shipping and Mirroring - Tony Rogerson, SQL Server MVP

In this session Tony will look at the basics an environment needs in order to be able to recover from problems be they an administrator dropping tables accidentally, users deleting data, corruption etc... Applicable for SQL Express through to Enterprise we look at what is available and how to set it up and how it works; agenda: Edition Features - a talk around what's available to you, Defining the strategy, Licencing, Backup and Restore discussed - how it works, the concepts, point in time recovery, Log Shipping fundementals and Mirrorings Fundementals - the majority of the presentation will be demo's.


Posted 08 September 2009 07:13 by tonyrogerson | with no comments
Filed under: , , , ,

TRUNCATE TABLE transactional?

create table blah ( 
    acol int ) 

insert blah ( acol ) values( 1 )
insert blah ( acol ) values( 1 )
insert blah ( acol ) values( 1 )
insert blah ( acol ) values( 1 )

begin tran

truncate table blah

select COUNT(*) from blah

rollback

select COUNT(*) from blah

drop table blah

So, yes - it is subject to the transaction; also - it is a logged operation, its just that the individual rows are not logged "individually" like they would if you used DELETE.

 

Posted 05 September 2009 10:42 by tonyrogerson | with no comments
Filed under: ,