Shaunt Khalatian

Shaunt
Khalatian

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.

Articles
Use T-SQL to Add SQL Server Startup Parameters 1
Using SQL Server Configuration Manager to add a startup parameter on numerous SQL Server instances can be time-consuming. Here's a T-SQL script that makes this task much easier and quicker.
Filtering DML Statements 1
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.
Stored Procedure Retrieves Information About Partitioned Tables 1
SQL Server Management Studio (SSMS) doesn't have a GUI that lets you easily obtain information about partitioned tables. Here's a stored procedure that helps fill this gap.
Easily Import and Export SSIS Packages 3
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.
Need to Find an Object But You Don't Know Its Exact Name? Try this Search Engine 4
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.
Track Database Disk-Space Usage on a Granular Level 1
The SpaceUsedAnalyzer stored procedure provides detailed information on how much space is being used by tables and their indexes so that you can manage disk space more efficiently.
Evaluate Index Usage in Databases
Here's a T-SQL stored procedure that you can use to identify tables without indexes, indexes that aren't being used, and indexes that aren't being used efficiently.

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.

 

From the Blogs
Jul 17, 2017
Sponsored

How Inferred Linking in Matched Records Digs Deeper into Your Data

Duplicate records clutter databases and render the data within them unclear. This kind of problem is very common, and it’s the main reason that deduping software exists. But there’s another benefit to deduplication software: the ability to infer connections between individual records from various data sets....More
May 22, 2017
Sponsored

Chief Data Officer Playbook: How to Be Successful in This Ground-Breaking Role

Companies looking to grow and extract value from their data are increasingly turning to Chief Data Officers (CDOs) to execute their data strategy. The role is new, and a playbook is necessary to address the many challenges CDOs face....More
May 12, 2017
blog

5 Common Challenges to Building BI in the Cloud

After spending 20 years building analytics, BI and database solutions, I've focused on Cloud data solutions over the past 2 years. I've chosen 5 common challenges that I face every day with Cloud migrations and that you'll face in your Cloud BI projects....More

Sponsored Introduction Continue on to (or wait seconds) ×