Microsoft Excel is a very powerful tool, using excel we can connect to all most all known data sources available and create a report easily. In this post, we will learn how to connect to a SQL Server database from Continue Reading..
As a SQL Server DBA, I like to code in T-SQL mostly. Recently I had a requirement where I need to delete files on conditional basis. I could have done the same writing a simple batch script or vb script Continue Reading..
Recently a friend of mine asked me that how can he record his SQL Server service restart history in a database table, also would like to get some kind of notification email when the instance comes online after a server reboot or after the service Continue Reading..
We are very much familiar with a system stored procedure called sp_helptext, which gets us the object definition on query window itself, but that sp is limited to procedures, functions, triggers, computed columns, views etc. So far there are no system Continue Reading..
When you ask a DBA or developer that, what features they would most like to see added to the future versions of SQL Server, they will undoubtedly say, “The ability to backup of a single table to physical file system Continue Reading..
It’s always fun automating stuff using vbscript. As a DBA it’s an added advantage, if you know some scripting languages like VBS, Powershell etc. I assume you are familiar with the auto sleep mode available in TV, which turns it off after so and so Continue Reading..
Often, a DBA like us gets user requests to copy a table data from one instance to another. In that case, we first see the amount of data present inside the table then we decide a method to have the data transferred. Continue Reading..
I love playing around with automation stuff. In a recent automation task, I was to copy or move files and/or folders from one location to another in SQL Server without using SQLCMD. If you are novice to OLE automation in SQL server then Continue Reading..
I have been doing some cool automation stuff in SQL Server using OLE Automation objects. This is a series post on OLE automation, If you missed the first post then read it here to know what OLE Automation is and how to Continue Reading..
Recently I have been assigned to do some file system operation from SQL Server like saving a physical file into database in binary format and extract back the same file into file system when needed. This could have been done using cmd, powershell, vbs Continue Reading..