SQLvariations: SQL Server, a little PowerShell, maybe some Hyper-V Rotating Header Image

AppDev

Late June 2010 PASS VC Presentations

Jun 21st, 2010
by Aaron Nelson.
Comments are off for this post

 pass_logo
_____________________________________________________________

ETL with PowerShell
June 22nd 9:00 PM EDT (GMT -4)
Presenter: Chad Miller

In this session we will look at performing common data loading tasks with PowerShell. A basic understanding of PowerShell is helpful, but not necessary. Specific topics covered include importing structured files, XML, WMI objects and ADO.NET data sources.

Chad Miller
Chad Miller is a Senior Manager of Database Administration at Raymond James Financial. Chad has worked with Microsoft SQL Server since 1999 and has been automating administration tasks using Windows PowerShell since 2007. In his spare time he is the Project Coordinator/Developer of PowerShell-based Codeplex project SQL Server PowerShell Extensions (SQLPSX). Chad leads the Tampa PowerShell User Group and is also a frequent speaker at SQL Server users groups, SQL Saturdays and Code Camps.

How do I view the presentation?
Attendee URL:  Live Meeting link
_____________________________________________________________

How SQL Server Indexes Work
June 23rd 12:00 PM EDT (GMT -4)
Presenter: Sharon F. Dooley

There are many useful presentations about indexes. Most of these concentrate on tricks and techniques. This presentation will provide the background knowledge of index architectures so that you can understand why techniques work and select the appropriate indexing strategies for your databases. Topics covered include page splits/fragmentation, disk accesses required for different index types, covering indexes and optimization.

Speaker Bio:

Sharon Dooley (MCP, former SQL Server MVP) has worked with SQL Server since its first release. Her major areas of specialization are database design and performance tuning, though she also does a lot of administration. She has a consulting practice and teaches and writes courses for Learning Tree International, where she is SQL Server Curriculum Manager. Ms. Dooley is the author of SQL Server 7.0 Essential Reference (New Riders), the lead author of Professional SQL Server 6.5 Administration (Wrox). Sharon is an active member of PASS (The Professional Organization for SQL Server) and has presented at numerous conferences. She was named a Microsoft MVP in 2001 and was an MVP for SQL Server until 2004. In her spare time, she enjoys being bossed around by her cats.

Attendee URL: https://www.livemeeting.com/cc/8000181573/join?id=7DJZ27&role=attend

_____________________________________________________________

Reporting Services for the DBA
June 23rd 12:00 PM CDT (GMT -5)
Presenter: Ef Romero

Reporting Services for the DBA: Using Reporting Services to monitor and affect changes to SQL Server.

Ef Romero:
Ef Romero is a Senior Consultant at Hitachi Consulting where he specializes in business intelligence development with SQL Server. His work with SQL Server is concentrated in ETL, data warehouse development, database optimization, and reporting. He received his bachelor’s and master’s degrees, both in pure mathematics, from UTEP and has worked as a mathematician and BI developer for the past four years. He is a collaborator on the recently published book SQL Server Reporting Services Recipes: for Designing Expert Reports.

Attendee URL: Join the meeting

del.icio.us Tags: ,,,

Early May PASS VC Presentations

May 10th, 2010
by Aaron Nelson.
Comments are off for this post

Next week is the 24 Hours of SQL Server 2008 R2 PASS but before we get there the Virtual Chapters of PASS have some free training on tap for us:

pass_logo
_____________________________________________________________

“You Got XML In My Database? What’s Up With That?”
May 11th 12:00 PM EDT (GMT -4)
Add to Calendar
Presenter: Stuart Ainsworth

A brief presentation exploring the marriage of XML and relational databases, including when it works and when it doesn’t. Coverage will include various use case scenarios, and some tips on how to improve performance using design techniques.

Stuart Ainsworth:

Stuart I Ainsworth, MA, Med is a Database Architect working in the realm of Financial Information Security; over the last 15 years, he’s worked as a Research Analyst, a report writer, a DBA, a programmer, and a public speaking professor. He’s one of the chapter leaders for AtlantaMDF, the Atlanta chapter of PASS. A master of air guitar, he has yet to understand the point of Rock Band (“You push buttons? What’s that all about?”).

How do I view the presentation?
Attendee URL:  Live Meeting link
_____________________________________________________________

Indexing Guidelines
May 12, 2010 Noon Mountain Time (-6 GMT)
Presenter: Greg Larsen

This session will discuss indexing guidelines. During this discussion there will be information about how developers and DBA’s should approach the indexing development lifecycle. This lifecycle will help attendees understand that you shouldn’t just develop some indexes while you are developing your applications and then forget about them. In addition some indexing guidelines will be discussed. These guidelines will help you make better choices on which columns to select for your indexes and how those columns should be ordered in multi-column indexes. There will be number of demonstrations to support this discussion. Lastly an indexing toolkit (a set of scripts) that you can use to help manage your indexes will be provided.

Greg Larsen:

Greg Larsen has been working with SQL Server since 1999. He has authored over 125 articles related to SQL Server. He holds a MCITP Database Administrator and Developer certification for SQL Server 2005 and is a SQL Server MVP. Greg also hosts the www.sqlserverexamples.com website which contains a number of T-SQL examples to help you manage your SQL Server environment and application T-SQL code. Greg has a full-time DBA gig, but also provides SQL Server consulting services in his spare time.


Door Prize: There will be a drawing for a $50.00 Amazon Gift Certificate
Registration: You can attend the meeting without registering but if you want to be entered in the drawing, you must register at https://www.livemeeting.com/lrs/8000181573/Registration.aspx?pageName=jhh2nc28185sd034 no later than 5:00 PM Eastern on May 11th.

Live Meeting Link: https://www.livemeeting.com/cc/usergroups/join?id=CPN75W&role=attend

_____________________________________________________________

12 Key Development Areas
May 13th 1:00 PM EDT (GMT -4)
Presenter: Andy Warren

A good professional development plan has to go far beyond ‘learning more technology’, it has to encompass the wide variety of skills you need to build the next step in your career, and it has to include a variety of learning methods. We’ll discuss how much time and money you should budget when building your plan, and how the distribution of time and money changes as your career evolves. We’ll look at the growth phases you’ll encounter, learning how you learn best, how to keep up with new technology without burning out, and even how things like blogging and Twitter can be an interesting part of your plan.

Andy Warren
Andy Warren (@SQLAndy) is a SQL trainer focusing on basic administration and performance tuning, he runs the free SQLShare.com training site, is currently a SQL Server MVP, blogs daily at SQLAndy.com, started the SQLSaturday franchise,  is co-President of the Orlando SQL Server Users Group, serves as a member of the Board of Directors of PASS, and was a founding partner in SQLServerCentral.com.  In his remaining free time he’s working on a book for first time managers and squeezes in some woodworking for relaxation.

Live Meeting Link: https://www323.livemeeting.com/cc/usergroups/join?id=5233Z9&role=attend

_____________________________________________________________

Extract, Transform, and Load your Data Warehouse
May 14, 2010 12:00 PM EDT (GMT -4) Add to calendar
Presenter: Jessica M. Moss

One data warehouse buzzword that often gets used is “ETL”, also known as extract, transform, and load.  But what does this really mean from a data warehousing perspective and how do we use SQL Server Integration Services to perform these ETL functions?  This session will answer these questions and show solutions to common ETL problems.

Jessica M. Moss

Jessica M. Moss, an architect with Ironworks Consulting and a Microsoft SQL Server MVP, is a well-known practitioner, author, and speaker in Microsoft SQL Server business intelligence.  Jessica has created numerous data warehousing solutions for companies in the retail, internet, health services, finance, and energy industries and authored technical content for multiple magazines, websites, and the book “Microsoft SQL Server 2008 Integration Services Problem-Design-Solution”.  Jessica enjoys working with the central Virginia community and speaks regularly at user groups, code camps, and conferences.  You can read about her work on her blog, http://www.jessicammoss.com.

Live Meeting Link: https://www.livemeeting.com/cc/usergroups/join?id=CPPC3S&role=attend

_____________________________________________________________

PASS Virtual Chapters Late April Presentations

Apr 23rd, 2010
by Aaron Nelson.
1 comment

To finish up the month of April we’ve got sessions from AppDev and DBA and I’m even including one from PASS on ‘Intro to Speaking At PASS’.  The AppDev group will be hosting the SARGability session twice, once for people having Lunch in Australia or Dinner in L.A. and once as a Late lunch for people in the UK (*I think).

pass_logo
_____________________________________________________________
Understanding SARGability (to make your queries run faster)
April 27th 12:30 PM Adelaide, AUS CST  (GMT +9:30) [April 26th at 8:00 PM PDT (GMT -7)]
Add to Calendar (AUS)
April 27th 8:00 AM EDT (GMT -4)
Add to Calendar
Presenter: Rob Farley

SARGable means Search ARGument able. It relates to the ability to search through an index for a value, but unfortunately, many database professionals don’t really understand it. This can lead to queries which miss out on the potential to run much quicker. This is a talk involving lots of demos, showing plenty of queries and execution plans. Any time I’m not typing on the screen, I’ll be waving my hands around to explain things, with apologies to those tuned in through Live Meeting.

Rob Farley:
rob_side
Rob Farley runs LobsterPot Solutions, a consultancy based in Adelaide, Australia. He has been consulting in IT since completing a Computer Science degree with first class honours in 1997 and using SQL Server since 1998. He is a regular presenter at conferences such as TechEd Australia, heads up the Adelaide SQL Server User Group and holds many Microsoft certifications. He is a Microsoft Certified Trainer and is a recipient of the Microsoft MVP Award for SQL Server. Rob has also helped create several exams for Microsoft Learning, and has recently written two chapters for the book SQL Server MVP Deep Dives. Rob’s blog can be read at http://sqlblog.com/blogs/rob_farley/

How do I view the presentation?

Attendee URL (AUS):  Live Meeting link

Attendee URL: Live Meeting Link
_____________________________________________________________

SQL Server 2008 Audit
April 28, Noon Eastern Time (GMT -4)
Presenter: Thomas LaRock

With SQL Server 2008 you now have the ability to set up auditing with SQL Server Audit. Attend this session for an overview of SQL Server Audit, learn how to initially configure an audit for your server or databases, and examine the audit logs to report on the information that is captured.

Thomas LaRock:
DBA_Survivor
Thomas LaRock is a seasoned IT professional with over a decade of technical and management experience. Thomas is a member of Quest Software’s Association of SQL Server Experts, currently serves on the Board of Directors for the Professional Association for SQL Server (PASS), and is a SQL Server MVP. Thomas can also be found blogging at http://thomaslarock.com and is the author of DBA Survivor: Become a Rock Star DBA.


Door Prize: There will be a drawing for a $50.00 Amazon Gift Certificate
Registration: You can attend the meeting without registering but if you want to be entered in the drawing, you must register at https://www.livemeeting.com/lrs/8000181573/Registration.aspx?pageName=fmxpl8tdzwcrc6z0 no later than 5:00 PM Eastern on April 27th.

Live Meeting Link: https://www.livemeeting.com/cc/8000181573/join?id=6K8GPR&role=attend

_____________________________________________________________

Intro to Speaking At PASS: Creating a Winning Abstract (If I Can Do It, Anyone Can!)
April 28, Noon Central Time (GMT -5)
Presenter: Chuck Heinzelman

Have you ever attended a conference (such as PASS) and thought to yourself, “Wow, I wish I could speak at something like this!” Speaking at a conference like PASS is not something reserved for the superstar speakers. Each year PASS actively calls out for presentation proposals from members of the SQL Server community. During this session we’ll talk about what goes into creating a submission for the call for speakers with the goal of reducing the fear and anxiety that can go along with the process.

Live Meeting Link: https://www.livemeeting.com/lrs/0000000379_116/Registration.aspx?pageName=nk4md836r0tzp94j

______________________________________________________

Coming in May…

Stuart Ainsworth presents “You Got XML In My Database? What’s Up With That?”

and

Patrick LeBlanc presents “Introduction to SQL Server Profiler”

LiveJournal Tags: ,,,

PASS Virtual Chapters Early April Presentations

Apr 5th, 2010
by Aaron Nelson.
Comments are off for this post

In April we’ve got free training coming your way from the usual suspects of the PASS VCs (AppDev, DBA, and Virtualization).  Here’s what’s on tap in chronological order:

pass_logo
_____________________________________________________________
Using Virtualization to Solve Common Dev/QA Environment Problems
April 7th Noon Eastern (GMT -4)
Presenters: Aaron Nelson & Dushyanth Nataraj

Isn’t two always better than one?  This month the Virtualization Virtual Chapter is going to run a unique double session with two separate presentations focused on solving common problems for Development and Quality Assurance environments using virtualization technology!

Our first session will focus on using Microsoft Hyper-V to solve problems DBA’s face when trying to QA a change before moving it to production.  Aaron will show you how Microsoft’s Hyper-V can streamline the process and ensure results from your QA testing that will be consistent in your production environment.

In our second session session Dushyanth Nataraj will give attendees an overview of VMware vCenter Lab Manager. You will learn how VMware vSphere and Lab Manager can help you build a internal cloud for dev/test. The session will conclude with a demo of Lab Manager running a SQL workload showcasing how you can use the product for test/dev.

About the speakers

  • Aaron Nelson (@SQLvariant ) http://sqlvariant.com/wordpress/
    Aaron is a Senior SQL Server Architect with over 10 years experience in architecture, business intelligence, development, and performance tuning of SQL Server.  He has experience managing enterprise-wide data needs in both transactional and data warehouse environments.
  • Dushyanth Nataraj
    Dushyanth is the Technical Marketing Manager for Lab Manager. He has been with VMware 5 years and has held roles in Engineering and Technical Marketing. He holds a MS in Computer Science from the University of Kansas.

This live one-hour webcast will happen on Wednesday, April 7th at 12:00 noon Eastern, 16:00 GMT.

How do I view the presentation?
Click here to join the webcast.

Want to speak at our next event?  We’re looking for database administrators who can talk about how virtualization has worked for them, what they’ve learned, and any tips they can pass on.  It can be as formal or informal as you like.  To volunteer, email Tim Edwards at tim_edwards@fsafood.com.
_____________________________________________________________________

PowerShell for Database Developers
April 13th at 12:00 PM Eastern (GMT -4)
Presenter: Peter Schott
Add to Calendar

PowerShell for Database Developers

PowerShell

Peter Schott is currently working as a Development DBA for Fellowship Technologies, using SQL Server, SSIS, and PowerShell (in his spare time). He has worked with SQL Server since 1996, designing databases, writing reports, scripting, performance tuning, and moving around lots of data. Peter blogs at Schott SQL. (And is open to better names for his blog.)

How do I view the presentation?
Attendee URL:  Live Meeting link
_____________________________________________________________________

Using SQL Server 2008 Database Mirroring to Become a Super Hero!
Date: April 14, Noon Mountain Time (GMT -6)
Presenter: Glenn Berry

Abstract:
Database mirroring is a valuable technology that can be used to minimize or avoid downtime due to hardware failures, with less complexity than fail-over clustering. It can also be used for other innovative uses, such as easily migrating from SQL Server 2005 to SQL Server 2008 with a sub-minute outage. Database mirroring can be used during normal scheduled maintenance for rolling updates to minimize downtime. Database mirroring works very well for migrating very large databases from one SAN to another with minimal downtime. This session will cover all of these scenarios, with practical techniques, scripts and tips to help you take advantage of database mirroring.

Speaker:
Glenn Berry works as a Database Architect at NewsGator Technologies in Denver, CO. He is a SQL Server MVP, and he has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. His expertise includes DMVs, high availability, full text search, and SQL Azure.

He is also an Adjunct Faculty member at University College – University of Denver, where has been teaching since 2000. He recently completed the Master Teacher Program at University College.

Door Prize: There will be a drawing for a $50.00 Amazon Gift Certificate
Registration: You can attend the meeting without registering but if you want to be entered in the drawing, you must register at https://www.livemeeting.com/lrs/8000181573/Registration.aspx?pageName=dt7v502vq7nrtbmj no later than 5:00 PM Eastern on April 13th.

How do I view the presentation?
Live Meeting Link: https://www.livemeeting.com/cc/8000181573/join?id=Z92ZRJ&role=attend

Late March PASS VC Presentations

Mar 23rd, 2010
by Aaron Nelson.
Comments are off for this post

pass_logo

The PASS AppDev and DBA Virtual Chapters have even more free training lined up for you:

Index Statistics
March 23rd at 12:00 PM Eastern (GMT -4)
Presenter: Josef Richberg
Add to Calendar

A semi-technical guide to understanding and using non-clustered  indexes in your databases. Learn the benefits of covered indexes and  their differences between SQL 2000 and SQL 2005+.

Josef Richberg

Josef Richberg is a DBA for HarperCollins Publishers working with SQL Server and SSIS. He has over 17 years experience designing, building, and tuning SQL Server. He is the recipient of the ’2009 Exceptional DBA’ award and actively blogs at http://josef-richberg.squarespace.com

How do I view the presentation?

Attendee URL:  Live Meeting link

_____________________________________________________________________

Topic:  SQL Server Internals and Architecture

Date: March 24, Noon EasternTime (GMT -4)

Abstract:

Let’s face it.  You can effectively do many IT jobs related to SQL Server without knowing the internals of how SQL Server works.  Many great developers, DBAs, and designers get their day-to-day work completed on time and with reasonable quality while never really knowing what’s happening behind the scenes.  But if you want to take your skills to the next level, it’s critical to know SQL Server’s internal processes and architecture.  This session will answer questions like:

- What’s different about 32- and 64-bit systems?

- What are the various areas of memory inside of SQL Server?

- How are queries handled behind the scenes?

- What does SQL Server do with procedural code, like functions, procedures, and triggers?

- What happens during checkpoints?  Lazywrites?

- How are IOs handled with regards to transaction logs and database?

- What happens when transaction logs and databases grow or shrinks?

This fast paced session will take you through many aspects of the internal operations of SQL Server and, for those topics we don’t cover, will point you to resources where you can get more information.  So strap on your silly, as we cover all these topics and more at speed with tongue planted firmly in cheek!

Prerequisites: Basic understanding of SQL Server operations and activities – such as transactions, queries, and preventative maintenance tasks like backup and recovery.

Speaker: Kevin Kline is the Technical Strategy Manager for SQL Server Solutions at Quest Software. A Microsoft SQL Server MVP, Kevin is a founding board member of PASS and the author of popular IT books like “SQL in a Nutshell” (O’Reilly & Associates). Kevin is a top-rated speaker at industry trade shows and has been active in the IT industry for over 20 years.

Door Prize:
Kevin will have two copies of his “In a nutshell” book that will be raffled off to attendees. You must register no later than 5:00 PM Eastern on March 23rd to be included in the raffle.

Registration: You can attend the meeting without registering but if you want to be entered in the drawing, you must register at

https://www.livemeeting.com/lrs/8000181573/Registration.aspx?pageName=pzjr7664vdwssm3t

Live Meeting Link (just paste into your browser):
https://www.livemeeting.com/cc/8000181573/join?id=344ND5&role=attend

Early March 2010 PASS VC Presentations

Mar 9th, 2010
by Aaron Nelson.
Comments are off for this post


Free Training from Virtual Chapters:
AppDev: Jessica Moss on “Adding SSRS Report Bells and Whistles,” March 9, noon ET (GMT-5)
DBA: Clifford Dibble“Microsoft SQL Server 2008 R2 Application and Multi-Server Management,” March 10, 12-1pm MT (GMT-7)
Virtualization: “Microsoft Hyper-V” presented by Sylvia Vargas. March 16, noon ET (GMT-5)

_____________________________________________________________________
JMMossSmall
Adding SSRS Report Bells and Whistles
March 9th at 12:00 PM Eastern (GMT -5)
Presenter: Jessica M. Moss
Add to Calendar

Producing a good looking report will wow your business users even if your data isn’t all that impressive. If you’ve ever had trouble finding the best way to display that data or how to show trends appropriately, this is the session for you. We will review grouping logic, graphs, gauges, and more in Reporting Services 2008. With the knowledge in this session, you won’t ever need to show a plain, boring report again.

Jessica M. Moss

Jessica M. Moss, an architect with Ironworks Consulting and a Microsoft SQL Server MVP, is a well-known practitioner, author, and speaker in Microsoft SQL Server business intelligence. Jessica has created numerous data warehousing solutions for companies in the retail, internet, health services, finance, and energy industries and authored technical content for multiple magazines, websites, and the book “Microsoft SQL Server 2008 Integration Services Problem-Design-Solution. Jessica enjoys working with the central Virginia community and speaks regularly at user groups, code camps, and conferences. You can read about her work on her blog,http://www.jessicammoss.com.

How do I view the presentation?
Attendee URL:  Live Meeting link

_____________________________________________________________________
Microsoft SQL Server 2008 R2 Application and Multi-Server Management
March 10, Noon Mountain Time (GMT-7)
Presenter: Clifford Dibble

Are you missing critical utilization insights into your growing database environment? Attend this session to learn how the application and multi-server management capabilities shipping with SQL Server 2008 R2 will expose resource utilization data and help streamline consolidation management. New extensions in SQL Server Management Studio allow DBAs to quickly create SQL Server control point and enroll instances them into multi-server management. Once enrolled, DBAs can define utilization policies across applications and Database Engine instances and view resource utilization to maximize investments. Meanwhile, the introduction of a single unit of deployment helps accelerate deployments, moves and upgrades associated with consolidation management.

Clifford Dibble:

Clifford Dibble has been a program manager in SQL Server since 2002.  Among other things, he was the active PM for “system views”, “DMVs”, “DDL triggers”, and “resource database” during the 9.0 release.   During the 10.0 release, Clifford was off working on an incubation project.  For the 10.5 and 11.0 releases, he is focused on multi-instance manageability and SQL management packs.

Live Meeting Link (just paste into your browser):
https://www.livemeeting.com/cc/usergroups/join?id=P7FJ9Z&role=attend

_____________________________________________________________
Microsoft Hyper-V
March 16th at 12:00 PM Eastern (GMT -5)
Presenter: Sylvia Vargas

Overview of how Microsoft IT uses, configures, and manages their virtualization environment.  Learn how Microsoft leverages Virtualization for their SQL Server environments using System Center VMM.

  • Sylvia is a Microsoft certified SQL Server professional and  Senior Systems Engineer in Microsoft IT’s Virtualization Engineering group.  Prior to joining Microsoft in 2006, Sylvia spent 24 years in various management and technical roles specializing in the architecting, development and deployment of data based solutions for companies including Areva, Boeing, ORACLE, Merrill Lynch,  Nestle and Texaco.  Sylvia has been a contributing author on The Real MCTS SQL Server 2008 Exam 70-432 Prep Kit by Syngress and an instructor at the University of Washington SQL Server Certificate program.
  • Mark Pohto is the Principal Service Engineer responsible for the IT Cloud organization which provides virtual server engineering and delivery in Microsoft data centers. Previous to his current role, Mark was instrumental in architecting corporate monitoring systems, database administration automation solutions and IT SQL Server consolidation.  As the Group Manager for the Microsoft SQL Server Center of Excellence, Mark managed the team responsible for the Microsoft Certified Architect program and the SQL Risk Assessment program.

    • Event Link:
    https://www.livemeeting.com/cc/usergroups/join?id=QB6GSJ&role=attend&pw=Fz8b%7BT%27jN

    Get More Done with SQLPSX

    Feb 25th, 2010
    by Aaron Nelson.
    Comments are off for this post

    In my LiveMeeting session for the AppDev Virtual Chapter of PASS yesterday I talked about building on top of tools that others had already built for you to use.  A great one for any DBA to use is the SQL PowerShell Extensions known as SQLPSX.  Even if you’ve never used PowerShell before you should take a look at this.  Heck even Sys Admins in shops that don’t have a DBA should have a look at this.  I have found the commands I have worked with very easy to use; even easier than T-SQL in some cases.

    SQLPSX

    After you download the files and RTFM you can then you can follow along on this next part.  Oh wait, first a little warning straight from Buck Woody:

    Script Disclaimer, for people who need to be told this sort of thing:  

    Never trust any script, including those that you find here, until you understand exactly what it does and how it will act on your systems. Always check the script on a test system or Virtual Machine, not a production system. All scripts on this site are performed by a professional stunt driver on a closed course. Your mileage may vary. Void where prohibited. Offer good for a limited time only. Keep out of reach of small children. Do not operate heavy machinery while using this script. If you experience blurry vision, indigestion or diarrhea during the operation of this script, see a physician immediately.

    get-module -listAvailable

    import-module SQLServer

    Invoke-SqlBackup -sqlserver "WINX64ULT7\Kilimanjaro" -dbname "AdventureWorks" `

    -filepath "C:\Temp\AdventureWorks_db_$(((Get-Date).ToString("yyyyMMddHHmm"))).bak"

    Now this little script here (above) will backup a db for you and even include the current YearMonthDayHourMinute in the file string.  This one below will backup all of the non-system databases on your instance.  If you’re like me you’re thinking this doesn’t do anything that you can’t already do today with a maintenance plan.  That’s true and maybe I should have titled this post “Get Something Done with SQLPSX” but I will build on how you can leverage this more tomorrow.  For now, why don’t you add an AND clause only backup all the databases that start with ‘A’ ;-) 

    foreach ($dbn in invoke-sqlcmd -query "SELECT name  FROM sys.databases WHERE owner_sid !=0x01" `

    -database master -serverinstance WIN7\Kilimanjaro )

    {

    $k="C:\Temp\" + $($dbn.name) + "_db_$(((Get-Date).ToString("yyyyMMddHHmm"))).bak"WIN7\Kilimanjaro" -dbname $($dbn.name)  -filepath $k

    $dbn; Invoke-SQLBackup -sqlserver "

    }

    I’ve gone ahead and included the SQLPSX help items here.  Please see if there’s one that catches your eye and see if it might work for you.

    * Get-AgentAlert

    * Get-AgentAlertCategory

    * Get-AgentJob

    * Get-AgentJobHistory

    * Get-AgentJobSchedule

    * Get-AgentJobServer

    * Get-AgentJobStep

    * Get-AgentOperator

    * Get-AgentOperatorCategory

    * Get-AgentProxyAccount

    * Get-AgentSchedule

    * Get-AgentTargetServer

    * Get-AgentTargetServerGroup

    * Set-AgentJobHistoryFilter

    * Get-ReplArticle

    * Get-ReplEnumLogReaderAgent

    * Get-ReplEnumPublications

    * Get-ReplEnumPublications2

    * Get-ReplEnumSnapshotAgent

    * Get-ReplEnumSubscriptions

    * Get-ReplEnumSubscriptions2

    * Get-ReplLightPublication

    * Get-ReplMonitor

    * Get-ReplPublication

    * Get-ReplPublicationMonitor

    * Get-ReplPublisherMonitor

    * Get-ReplScript

    * Get-ReplServer

    * Get-ReplSubscriberSubscription

    * Get-ReplSubscription

    * Get-ReplTransPendingCommandInfo

    * New-ReplMergePublication

    * New-ReplScriptOptions

    * New-ReplTransPublication

    * Get-GroupUser

    * Get-ShowMbrs

    * New-ShowMbrs

    * Set-ShowMbrs

    * Out-SqlScript

    * Test-SqlScript

    * Add-SqlDatabase

    * Add-SqlDatabaseRole

    * Add-SqlDatabaseRoleMember

    * Add-SqlDataFile

    * Add-SqlFileGroup

    * Add-SqlLogFile

    * Add-SqlLogin

    * Add-SqlServerRoleMember

    * Add-SqlUser

    * Get-Sql

    * Get-SqlCheck

    * Get-SqlColumn

    * Get-SqlConnection

    * Get-SqlData

    * Get-SqlDatabase

    * Get-SqlDatabasePermission

    * Get-SqlDatabaseRole

    * Get-SqlDataFile

    * Get-SqlDefaultDir

    * Get-SqlEdition

    * Get-SqlErrorLog

    * Get-SqlForeignKey

    * Get-SqlIndex

    * Get-SqlIndexFragmentation

    * Get-SqlInformation_Schema.Columns

    * Get-SqlInformation_Schema.Routines

    * Get-SqlInformation_Schema.Tables

    * Get-SqlInformation_Schema.Views

    * Get-SqlLinkedServerLogin

    * Get-SqlLogFile

    * Get-SqlLogin

    * Get-SqlObjectPermission

    * Get-SqlPort

    * Get-SqlProcess

    * Get-SqlSchema

    * Get-SqlScripter

    * Get-SqlServer

    * Get-SqlServerPermission

    * Get-SqlServerRole

    * Get-SqlShowMbrs

    * Get-SqlStatistic

    * Get-SqlStoredProcedure

    * Get-SqlSynonym

    * Get-SqlSysDatabases

    * Get-SqlTable

    * Get-SqlTransaction

    * Get-SqlTrigger

    * Get-SqlUser

    * Get-SqlUserDefinedDataType

    * Get-SqlUserDefinedFunction

    * Get-SqlVersion

    * Get-SqlView

    * Invoke-SqlBackup

    * Invoke-SqlDatabaseCheck

    * Invoke-SqlIndexDefrag

    * Invoke-SqlIndexRebuild

    * Invoke-SqlRestore

    * New-SqlScriptingOptions

    * Remove-SqlDatabase

    * Remove-SqlDatabaseRole

    * Remove-SqlDatabaseRoleMember

    * Remove-SqlLogin

    * Remove-SqlServerRoleMember

    * Remove-SqlUser

    * Set-SqlData

    * Set-SqlDatabasePermission

    * Set-SqlObjectPermission

    * Set-SqlServerPermission

    * Update-SqlStatistic

    * Copy-ISItemFileToSQL

    * Copy-ISItemSQLToFile

    * Copy-ISItemSQLToSQL

    * Get-ISData

    * Get-ISItem

    * Get-ISPackage

    * Get-ISRunningPackage

    * Get-ISSqlConfigurationItem

    * New-ISApplication

    * New-ISItem

    * Remove-ISItem

    * Rename-ISItem

    * Set-ISConnectionString

    * Set-ISPackage

    * Test-ISPath

    PASS Virtual Chapter Late February Presentations

    Feb 16th, 2010
    by Aaron Nelson.
    1 comment

    PASS AppDev Presents: PowerShell for Data Professionals

    For this session we have partnered with SQL User Groups on the other side of the planet to do multiple live sessions in time slots that are convenient for them.  If you would like your User Group to partner with us on a time slot for a future session please contact us here:  appdev_DL@sqlpass.org

    Date: Start Time:  End Time:  Time Zone: Add to your calendar
    2/23/2010 12:00 PM 1:00 PM GMT+13:00  Click Here
    2/23/2010 12:30 PM 1:30 PM GMT+10:30  Click Here
    2/23/2010 12:00 PM 1:00 PM GMT-5  Click Here

    Event Description:
    In this session we will learn to perform several everyday data tasks including user database backups, scripting table objects and evaluating disk space usage with PowerShell. For each task we will explore the benefits of using PowerShell over the standard method. Only a basic understanding of PowerShell or DOS is needed. This session should serve as a good introduction to PowerShell for database users. The goal is to help everyone get their feet wet using PowerShell.

    Aaron Nelson:
     Aaron twitter
    Aaron is a Senior SQL Server Architect with over 10 years experience in architecture, business intelligence, development, and performance tuning of SQL Server.

    He has experience managing enterprise-wide data needs in both transactional and data warehouse environments.  He also holds certifications for  MCITP: Business Intelligence Developer, Database Administrator, Database Developer; as well as MCTS: Windows Server Virtualization, Configuration (meaning Hyper-V). Aaron blogs at SQLvariations

    How do I view the presentation?
    Attendee URL:�
    Live Meeting Link (Auckland, NZ)
    Live Meeting link (Australia)
    Live Meeting link (Eastern US Time Zone)

    ____________________________________________________________________________________________________


    PASS DBA VC Presents: SQL Server Locking & Blocking Made Simple

     

    Date: Start Time:  End Time:  Time Zone: Add to your calendar
    2/10/2010 12:00 PM 1:00 PM GMT-5  

    Event Description:
    A good working knowledge of how SQL Server makes use of locking and transaction isolation levels can go a long way toward improving an application’s performance. In this session, we will explore SQL Server’s locking methodology and discover techniques for enhancing query response times.

    Joe Webb:
     joewebb
    Joe Webb, a Microsoft SQL Server MVP, serves as Chief Operating Manager for WebbTech Solutions, a Nashville-based consulting company. He has over 14 years of industry experience and has consulted extensively with companies in the areas of software development, database design, and technical training.

    Live Meeting Information:
    Attendee URL: Live Meeting Link

    ← Earlier Posts Newer Posts →