(Pinal Dave) Here is a very interesting question asked on the blog by Karthik. I really liked the question and I would like to discuss this here.

(Mangesh Mharolkar) I am not a regular ETL developer but I do “dabble” in developing code from time to time. One requirement that I come across is looping (while, for, infinite) in a job and performing a task based on condition and then going to sleep for a period of time. This certainly can be acco

(Greg Larsen) For years SQL Server has supported the IDENTITY property for automatically generating a unique number that is incremented from one value to another based on an increment value. With the introduction of SQL Server 2012, Microsoft introduced a new method to generate a sequence number, u

(Michael Otey) Although virtualizing SQL Server was once unheard of, today it’s pretty common. However, not all virtualized SQL Server instances are implemented in the best way.

(Svetlana Golovko) So, you have created a SQL Server Policy to check database recovery models. Now you need to check the databases on all of your SQL Server instances. In this tip we will show how you can evaluate a SQL Server policy against multiple instances.

(VidhyaSagar) Script to retrieve auditing configuration details in sql server. Auditing feature is released from SQL Server 2008 onward so if you have utilized this feature then you can make use of this script to get quick information about audit configuration.

(Stanley Johns K.) You may have written ad-hoc queries to pull data for a certain date range. As this report gets popular over time and the date range expands, you may be asked to do a break down of the report.

(Chris Shaw) Often I am asked about the importance of a security audit, with the majority of these questions being asked by representatives of smaller organizations. The questions are centered around if there is a need to perform a security audit when the organization has taken some measures to prot

(Kenneth Fisher) The INSERT command has two distinct ways to load data into a table.

(Arshad Ali) In my earlier articles of the series, I discussed what partitioning in SQL Server is; the different kinds of partitioning options that we have, why and when we should go for partitioning and what benefits partition table/index provides.