July 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Walking the Table Hierarchy in Microsoft SQL Server Database – Notes from the Field #076

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Notes from the Field, SQL Function, SQL Scripts
[Note from Pinal]: This is a 76th episode of Notes from the Field series. Hierarchy is one of the most important concepts in SQL Server but there are not clear tutorial for it. I have often observed that this simple concept is often ignored or poorly handled due to lack of understanding. In…
Read More

SQL SERVER – Is XP_CMDSHELL Enabled on the Server?

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Stored Procedure

I am not a big fan of using command line utilities in general. But from time to time I do explore and play around with command line tools that make my life easier. Having said that, when working with SQL Server, I do often give out the recommendation of not trying to use the native xp_cmdshell commands with SQL Server. Even the SQL_Server_2012_Security_Best_Practice_Whitepaper talks about xp_cmdshell and recommends to avoid the same if it is possible. These are basic building blocks of security that I highly recommend my customers from time to time.

Read More

SQL SERVER – The Basics of the File System Task – Part 2 – Notes from the Field #075

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Notes from the Field, SQL Backup and Restore, SSIS
[Note from Pinal]: This is a new episode of Notes from the Field series. SQL Server Integration Service (SSIS) is one of the most key essential part of the entire Business Intelligence (BI) story. It is a platform for data integration and workflow applications. In this episode of the Notes from the…
Read More