Shaunt Khalatian is the senior DBA at Aora Consultancy in London. He has over 10 years of SQL Server experience, has a master's degree in computer distributed processing, and is an MSCE 2012, MCITP, MCDBA, and OCP 10g.
SQL Server 2005 introduced the EVENTDATA function. When called from within a Data Definition Language (DDL) trigger, this function generates an XML string that provides details (e.g., login name, host name, object name) about the statement that caused the trigger to fire.
Storing SQL Server Integration Services (SSIS) packages under a well-defined folder structure in msdb is advantageous, but getting them there can be a hassle. Here's a solution that does all the work for you.
Looking for an object in a SQL Server instance without knowing the object's exact name and the database in which it resides can be time-consuming. Here's a T-SQL stored procedure that will make your seach much quicker.
Power Pivot and other self-service BI tools are not a replacement for a data mart or data warehouse. When used correctly for Personal BI, Team BI, prototypes or proofs-of-concept, you can achieve truly agile, rapid reporting success with Excel Power Pivot....More
Recently, I've been working with a consulting client to help them tame CPU usage. Typically, they're clocking over 20,000 queries and operations per second on their e-commerce SQL Server, but ran into an issue where CPU started spiking up above 90 percent for sustained periods of time....More