Chandra Sekhar Pathivada

Chandra Sekhar
Pathivada

Chandra Sekhar Pathivada is an independent consultant based in San Francisco. An MCST in SQL Server 2005 and SQL Server 2000, he specializes in developing and administering SQL Server database servers. He hosts the www.calsql.com website to help fellow DBAs and the SQL Server user community.

Articles
white cubes of assorted size on blue and yellow data grid background
Revisiting How to Avoid Referential Integrity Errors
In this updated version of "Avoid Referential Integrity Errors When Deleting Records from Databases," Chandra Sekhar Pathivada goes more in-depth into the concepts behind his PR_HIERARCHIAL_DATA stored procedure.
white cubes of assorted size on blue and yellow data grid background
Avoid Referential Integrity Errors When Deleting Records from Databases 8
Deleting all the records in a database can be tricky when it includes tables with foreign keys. Here's a script you can use if you have ALTER TABLE permission and a stored procedure you can use if you don't.

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
business people around a table and laptop
Oct 9, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 10: Dynamic Detection Gotcha #3

You can interject a SQL Server Job Step into your Jobs and have this new/injected Job Step do some checking for you. Here's a look at everything that’s involved in such an approach....More
Man holding a piece of paper with the word GOTCHA
Oct 7, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 9: Dynamic Detection Gotcha #2 3

Given that a USE statement is parsed before code is actually run, there are a few options that could be used as a around when it comes to detecting whether or not code should be run....More
iceberg
Oct 2, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 8: Dynamic Detection Gotcha #1 1

Learn about why the option of dynamically detecting whether or not to run a SQL Server Job at execution time is quite a bit more problematic than you might think....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×