Blog Archives

T-SQL Tuesday #050: Automation, lessons learnt


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

Tagged with: , , ,
Posted in SQL Server

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.

Tagged with: ,
Posted in SQL Server

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: , , , , ,
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: , , , , , , , , ,
Posted in PowerShell, SQL Server

Filtering data from SQL*Server Errorlogs


Select from SQL*server error log with context.

Tagged with: , , , , , , ,
Posted in Fun-Stuff, PowerShell, SQL Server

T-SQL Tuesday #040: File and Filegroup Wisdom (Quick Introduction to FILESTREAM)


A quick and generic introduction to FILESTREAM for T-SQL Tuesday #40

Tagged with: , , , ,
Posted in 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: , , , , , , ,
Posted in PowerShell, SQL Server