The topic for the golden jubilee edition is, “Automation”. What is T-SQL Tuesday? T-SQL Tuesday is a monthly blog party hosted by a different blogger each month. This blog party was started by Adam Machanic (blog|twitter). You can take part…
Blog Archives
T-SQL Tuesday #050: Automation, how much of it is the same?
Automation plays a huge part in our lives and the DBA profession is no so different. A couple of years ago this topic was shared by Pat Wright. I would like to revisit this again and see how much of our approach has changed.
T-SQL Tuesday #46: You did what? Creative hacks to common problems
This whole thing, was put in a store procedure and then called from a job step for a long running job. For example, like a database backup job. And additional logic was written around the return value to write proper error numbers to application log. These event-ids where then picked up by monitoring applications and alerts where raised.
I have mixed feelings about this solution. Although, it worked without a problem (I am secretly proud that I was able to write something like this); I would have loved to just upgrade the servers to SQL 2008 and be done with it.
Tagged with: execution state, proof of concept, rube goldberg machine, SQL Server, T-SQL Tuesday, technology
Posted in SQL Server
Posted in SQL Server
Down the rabbit hole with PowerShell and Windows Azure SQL Database
In this post we look at how we can REST API to interact with the SQL Azure Database Server.
Tagged with: google search results, Invoke-RestMethod, Invoke-WebRequest, Powershell, REST, SQL Database, sql database server, SQL Server, Windows Azure, Windows Azure SQL Database
Posted in PowerShell, SQL Server
Posted in PowerShell, SQL Server
Filtering data from SQL*Server Errorlogs
Tagged with: Context, Error Log, ErrorLog, ErrorLogPath, Powershell, Select-String, SMO, SQL Server
Posted in Fun-Stuff, PowerShell, SQL Server
Posted in Fun-Stuff, PowerShell, SQL Server
T-SQL Tuesday #39: Getting Installed Instances, querying logs
This week’s T-SQL Tuesday is being hosted by Wayne Sheffield, and the topic is to blog about anything PowerShell related to SQL Server.
Today I am going to write about a few things:
-Getting a list of installed instances on a particular box.
-Reading the SQL*Server error logs using SMO.
-Querying the Windows event logs for errors.
Tagged with: ErrorLog, EventLog, Get-Item, Get-ItemProperty, Powershell, Registry, SQLServer, T-SQL Tuesday
Posted in PowerShell, SQL Server
Posted in PowerShell, SQL Server
Adding Extended Properties to SQL*Server Databases Using PowerShell
When you are working as part of a team that manages a few hundred SQL*Server instances; sometimes, it becomes hard to keep track of all the people who need to be notified when you plan for database migrations and such. Also, if there is an issue that needs their input ($’s); we do not want to send it to the wrong person now, would we. Maintaining the information in excel sheets is good but, wouldn’t it be nice to have the information available on the DB itself? We can get all the information in one shot and send out e-mails to the concerned (correct) individuals.
Tagged with: Extended Properties, Powershell, SMO, SQL Server, technology
Posted in PowerShell, SQL Server
Posted in PowerShell, SQL Server
Creating a Slipstream SQL Server install media using #PowerShell
Slipstream is a term used to describe merging original source media with updates and then installing the updated files. Blah..Blablablablah…Learn how to do this with Powershell 🙂
SqlChow 