Yearly Archives: 2011

2011 in review


The WordPress.com stats helper monkeys prepared a 2011 annual report for this blog. Here’s an excerpt: A San Francisco cable car holds 60 people. This blog was viewed about 1,700 times in 2011. If it were a cable car, it

Posted in Uncategorized

Emailing job output as a file attachment


One of our customer would like to email result of a SQL Agent job to email id. related thread. You can achieve this by enabling job step output to a file, add a new job step in current job that

Tagged with:
Posted in SQL Agent

SQL Server 2012 Unattended installation


Note: You can download  SQL 2012 Developer edition if you are a MSDN subscriber https://msdn.microsoft.com/en-us/subscriptions/securedownloads/hh442898#searchTerm=&ProductFamilyId=461&Languages=en&PageSize=50&PageIndex=0 OR Download SQL 2012 Evaluation: 1) To download evaluation edition Goto Download for x86, Download  following files to local folder on your machine ENU\x86\SQLFULL_x86_ENU_Core.box ENU\x86\SQLFULL_x86_ENU_Install.exe

Posted in SQL Server

SQL Server Denali CTP3 on Windows 2008 R2 Server Core


Windows Server Core is a minimal server installation option for computers running on the Windows Server 2008 R2 operating system. You can learn more about Server Core here –  http://msdn.microsoft.com/en-us/library/ee391626(v=VS.85).aspx SQL Server Denali supports installing on Windows server core. You

Posted in server core, SQL Server, SysPrep

Get list of unsigned binaries in a given folder


    get-childitem c:\binpath\*.* | foreach-object {Get-AuthenticodeSignature $_}  | where {$_.status –ne "Valid"} | select-object Path | fl

Posted in Uncategorized

Auditing & XE Event sessions


— Audits changes done to syscollector_execution_log_internal directly / through stored procs — Also captures XEvents when validation error 14262 occurs USE [master] GO — Step #0 – Create a folder c:\TraceLogs — Step #1 – Create Audit session and start

Posted in Uncategorized