Browse by Tags

• Administration
• Agent
• Best Practices
• DBA
• Design
• Developer
• Development
• Maintenance
• Maintenance Plans
• Management
• Metadata
• Microsoft
• Monitoring
• Performance Tuning
• Planning
• PowerShell
• Process
• Security
• SQL Server Management Studio
• SSMS
• Standard Reports
• Tips
• Troubleshooting
• T-SQL
• Tutorials
• Virtualization
• Walkthroughs
• Web

• PowerShell for the DBA: Search the Windows Event Logs for Errors

  This is a very simple script - but it's one I run each morning. It searches the Windows System Event Log for an error condition. You can replace "System" here with "Application" or "Security", or any of the other logs that are created on your Windows Read More... Posted Wednesday, August 04, 2010 7:43 AM by BuckWoody | 1 Comments Filed under: Monitoring, PowerShell, Scripts, SQL Server, Troubleshooting

• PowerShell and Extended Properties

  I use Extended Properties on databases and their objects all the time. They are a great way to include information about the object – I use them for versioning the database, detailing what a column is used for and so on. They can be a little tricky Read More... Posted Tuesday, July 20, 2010 6:43 AM by BuckWoody | 0 Comments Filed under: PowerShell, Scripts, SQL Server

• Check Script

  Someone contacted me yesterday and said they were getting blocked when they tried to create a FileStream data column type. On investigation, I found they were Mirroring that database – and the two aren’t compatible. Which got me to thinking – it’s probably Read More... Posted Wednesday, June 30, 2010 8:10 AM by BuckWoody | 0 Comments Filed under: Scripts, SQL Server, T-SQL

• Create and Track Your Own License Keys with PowerShell

  SQL Server used to have  cool little tool that would let you track your licenses. Microsoft didn’t use it to limit your system or anything, it was just a place on the server where you could put that this system used this license key. I miss those Read More... Posted Thursday, April 15, 2010 7:10 AM by BuckWoody | 1 Comments Filed under: Administration, PowerShell, Scripts, SQL Server

• List SQL Server Instances using the Registry

  I read this interesting article on using PowerShell and the registry , and thought I would modify his information a bit to list the SQL Server Instances on a box. The interesting thing about listing instances this was is that you can touch remote machines, Read More... Posted Wednesday, March 31, 2010 7:41 AM by BuckWoody | 4 Comments Filed under: Administration, Metadata, PowerShell, Scripts, SQL Server

• Backup Meta-Data

  I'm working on a PowerShell script to show me the trending durations of my backup activities. The first thing I need is the data, so I looked at the Standard Reports in SQL Server Management Studio, and found a report that suited my needs, so I pulled Read More... Posted Tuesday, March 30, 2010 8:46 AM by BuckWoody | 3 Comments Filed under: Administration, DBA, Design, Maintenance, Maintenance Plans, Metadata, Scripts, SQL Server, SQL Server Management Studio, Standard Reports, T-SQL

• Open the SQL Server Error Log with PowerShell

  Using the Server Management Objects (SMO) library, you don’t even need to have the SQL Server 2008 PowerShell Provider to read the SQL Server Error Logs – in fact, you can use regular old everyday PowerShell. Keep in mind you will need the SMO libraries Read More... Posted Monday, March 29, 2010 7:35 AM by BuckWoody | 1 Comments Filed under: Administration, DBA, PowerShell, Scripts, SQL Server

• PowerShell: Read Excel to Create Inserts

  I’m writing a series of articles on how to migrate “departmental” data into SQL Server . I also hold workshops on the entire process – from discovering that the data exists to the modeling process and then how to design the Extract, Transform and Load Read More... Posted Thursday, March 18, 2010 6:09 AM by BuckWoody | 5 Comments Filed under: PowerShell, Scripts, SQL Server, Tips, T-SQL, Walkthroughs, Web

• PowerShell Version Two – Get Continuous Perf Counters

  In version 2.0 of PowerShell, you can now use a direct command-let (get-Counter) to get at the Performance Monitor counters. For instance, to show the current value of the Processor Percent Time, use this command:   Get-Counter '\Processor(*)\% Processor Read More... Posted Thursday, February 25, 2010 7:32 AM by BuckWoody | 0 Comments Filed under: Performance Tuning, PowerShell, Scripts, SQL Server, Tips

• Tools and Processes for “Fitting it all in”

  Most data professionals I’ve met work in two modes: we plan for our day, and we react to the situations around us. I’m staring at my list of things that I need to do today right now, which is my planned work. Of course, I have no idea how much of that Read More... Posted Monday, January 18, 2010 7:42 AM by BuckWoody | 0 Comments Filed under: Agent, DBA, Design, Developer, Development, Management, Microsoft, Planning, PowerShell, Process, Scripts, SQL Server, SQL Server Management Studio, SSMS, Tips, Web

• SQL Server Best Practices: Use Roles When You Can

  SQL Server has two major security vectors: “Principals”, which are primarily users and roles (groups), and “Securables”, which are primarily objects on the server or in the database, like tables or views. Many applications use Logins for their users, Read More... Posted Monday, December 07, 2009 7:49 AM by BuckWoody | 0 Comments Filed under: Best Practices, DBA, Scripts, Security, SQL Server

• Code that Writes Code

  I have scripts that re-create my databases for testing and development purposes. But sometimes I want to take the data from a set of tables and move it as well – I could use SSIS, or a SELECT INTO statement, but what if I want to “re-set” the data to Read More... Posted Wednesday, November 25, 2009 7:01 AM by BuckWoody | 5 Comments Filed under: DBA, Design, Developer, Development, Scripts, SQL Server, SQL Server Management Studio, SSMS, Tips, T-SQL, Tutorials, Virtualization, Web