Tag Archives | SQL Server

Get Going on Powershell

By now, I hope you have heard of a wonderful tool called Powershell which can make your life easier in some respects. Whether you are needing to interact with SQL Server, Exchange, or Active Directory there are resources available to guide you along the way. I’m not going to try and reinvent the wheel when it comes to great blog posts, so there may be a good deal of linking and summarizing.

Powershell is a command-line shell that will allow you to perform administrative tasks that would have been much more tedious if attempted in a different manner. It’s built upon the .NET so it can interact with .Net Framework objects.  Microsoft came out with Version 2.0 and released it with Windows 7 and Windows 2008 R2 (although you have to enable it).

If you already have PowerShell 1.0 installed then you may want to remove it first, unless you want to look into running both versions. You can also see how to check for a PowerShell installation. To correctly uninstall PowerShell 1.0 you can follow the instructions on MSDN.

If you haven’t already got Powershell 2.0, you’ll want to get that by downloading the Windows Management Framework Core. That core package comes with Windows PowerShell 2.0 and Windows Remote Management 2.0 (also known WinRM).

In regards to Powershell, you will now have two ways to test-drive your shiny new toy. It’s probably a good idea to try and hold off using the PowerShell ISE (Integrated Scripting Environment) in favor of using the basic PowerShell interface while you are starting out.

Getting Started
Windows PowerShell on MSDN
ScriptCenter
Why This SQL Server DBA is Learning Powershell
I’m a SQL Server DBA, and I’m in Love with PowerShell
Mastering PowerShell eBook with Dr. Tobias Weltner
Effective Windows PowerShell: The Free eBook
PowerShell in Practice (not free, but well worth it.)

Little Deeper
Administrator’s Guide to Windows PowerShell Remoting

Third Party PowerShell Editors
Once you begin to get a basic understanding of how things work I’d start looking at your other choices for editors. I use PowerGUI, but there’s also PowerShell Plus and Sapien’s PrimalScript. You can get more info about the comparison between the three from Don Jones and Michael Otey.

Add-ons
Idera Active Directory Scripts pack

SQL Server PowerShell Extensions
What’s New in SQLPSX 2.3

Active Directory cmdlets from Quest

Other Resources
http://technet.microsoft.com/en-us/scriptcenter/powershell.aspx
http://gallery.technet.microsoft.com/ScriptCenter/en-us/site/search?f[0].Type=ScriptLanguage&f[0].Value=Powershell&f[0].Text=Windows%20PowerShell
http://powershell.com/cs/
http://poshcode.org/
http://powershellcommunity.org/Forums.aspx
http://www.powershellpro.com/powershell-tutorial-introduction/powershell-tutorial-active-directory/
http://blogs.microsoft.co.il/blogs/ScriptFanatic/
http://technet.microsoft.com/en-us/scriptcenter/ee861518.aspx
http://www.networkworld.com/community/node/42218?source=nww_rss
http://dmitrysotnikov.wordpress.com/2007/06/28/get-a-list-of-all-user-properties/

Comments { 1 } Posted on November 29, 2010 in Education, PowerShell, SQL General, SQLServerPedia Syndication

Performance Counters Missing

We’ve been running SQL Server 2000 x86 on Windows Server 2003 R2 x64 for some time. While there have been a few issues here and there, monitoring SQL related counters can be troublesome whether you are local or remote.

If you are local to the server when you open up performance monitor you will receive the x64 counters and this won’t help you since your SQL Server is x86. For the 32 bit version just use %SystemRoot%\SysWow64\Perfmon.exe.

If you are remote then you’ll need to make some registry modifications on the server that you are monitoring. You’ll need to modify 2 registry entries to read SysWow64 instead of System32:

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\RemoteRegistry]
“ImagePath”=”%SystemRoot%\SysWow64\svchost.exe -k regsvc”
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\RemoteRegistry\Parameters]
“ServiceDll”=”%SystemRoot%\SysWow64\regsvc.dll”

Restart the Remote Registry Service and you should be good to go now.

Resources:
http://www.code-magazine.com/articleprint.aspx?quickid=080015&printmode=true
(Maybe you couldn’t run SQL 2000 under a x64 bit OS at the time of this writing)

http://blogs.msdn.com/edglas/archive/2006/09/06/reading-32-bit-counters-on-a-64-bit-machine.aspx

Comments { 2 } Posted on October 28, 2009 in SQL General, SQLServerPedia Syndication

SQL Server Tacklebox

I know I’m a little late posting this as I’m sure you’ve already downloaded the free Ebook and read through it, but if you haven’t be sure to go grab a copy.

It’s got some good stuff in it.

Comments { 0 } Posted on August 24, 2009 in Education, SQL General

24 hours of free SQL training

From the site:
24 Hours of PASS is a series of live one-hour webcasts broadcast over a 24-hour period that focus on a host of SQL Server topics. The 24 one-hour presentations will begin at 00:00 GMT (UTC) on September 2, 2009

Be sure to take into account the whole GMT issue. Since I’m on Central Standard Time it would start for me at 7:00 pm on September 1. I haven’t seen whether or not they will archive the sessions but I hope they do.

Session 01 (Dev) – Start time: 00:00 GMT
10 Big Ideas in Database Design
Presenters: Louis Davidson and Paul Nielsen

Session 02 (DBA) – Start time: 01:00 GMT
Using PowerShell to Get the Most Out of SQL Server
Presenter: Allen White

Session 03 (PD) – Start time: 02:00 GMT
Team Management Fundamentals
Presenter: Kevin Kline

Session 04 (BI) – Start time 03:00 GMT
Delivering Good Performance Consistently with SSIS
Presenter: John Welch

Session 05 (DBA) – Start time 04:00 GMT
Using SQLdiag to Troubleshoot SQL Server Problems
Presenter: Brad McGehee

Session 06 (DBA) – Start time 05:00 GMT
The SQL Server 2008 Vanishing Act
Presenter:  Peter Ward

Session 07 (BI) – Start time 06:00 GMT
Text Mining
Presenter: Dejan Sarka

Session 08 (Dev) – Start time 07:00 GMT
Tips and Tricks for Writing SET Based Queries
Presenter: Jacob Sebastian

Session 09 (DBA) – Start time 08:00 GMT
Mirrored Databases
Presenter: Thomas Grohser

Session 10 (Dev) – Start time 09:00 GMT
Working with Spatial Data in SQL Server 2008
Presenter: Greg Low

Session 11 (DBA) – Start time 10:00 GMT
Effective Indexing
Presenter: Gail Shaw

Session 12 (BI) – Start time 11:00 GMT
Reporting Services Inside Out: The Things You Should Know
Presenter: Simon Sabin

Session 13 (DBA) – Start time 12:00 GMT
Query Performance Tuning 101
Presenter: Grant Fritchey

Session 14 (BI) – Start time 13:00 GMT
Reporting from Analysis Services Cubes Using Excel 2007
Presenter: Peter Myers

Session 15 (BI) – Start time 14:00 GMT
Data Warehousing: Laying the Foundation to Success
Presenter: Erik Veerman

Session 16 (DBA) – Start time 15:00 GMT
Database Compatibility Settings: What They Really Do… and Don’t Do
Presenter: Don Vilen

Session 17 (PD) – Start time 16:00 GMT
Building a Better Blog
Presenter: Steve Jones

Session 18 (Dev) – Start time 17:00 GMT
Building Flexible Data Services for the Web Using the ADO .NET Data Services Framework
Presenter: Artemakis Artemiou

Session 19 (Dev) – Start time 18:00 GMT
SQLCLR or T-SQL? A Brief Survey of Performance Options
Presenter: Adam Machanic

Session 20 (BI) – Start time 19:00 GMT
Loading a Data Warehouse in SSIS
Presenter: Brian Knight

Session 21 (DBA) – Start time 20:00 GMT
What’s Simple about Simple Recovery Model
Presenter: Kalen Delaney

Session 22 (Dev) – Start time 21:00 GMT
What’s New, Harder, and Easier in SQL Server 2008 Security
Presenter: Don Kiely

Session 23 (DBA) – Start time 22:00 GMT
Analyzing File and Wait Statistics
Presenter: Andrew Kelly

Session 24 (BI): Start time 23:00 GMT
Embed Reporting Services into Your Applications
Presenter: Jessica Moss

Comments { 1 } Posted on August 6, 2009 in Education, General, SQL General