Yearly Archives: 2011

2011 in review

The 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 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\ 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 – 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