(Pinal Dave) Some people call it laziness, some will call it efficiency, some think it is the right thing to do. At any rate, tools are meant to make a job easier, and I like to use various tools.

(Svetlana Golovko) I am new to Database Administration and have been asked to prepare data for an audit. I know there are a lot of different metrics I can pull from SQL Server, but I am not exactly sure where to begin. What items would you suggest to look into to make sure that we have information

(Richard Carr) Prior to SQL Server 2008 it is not possible to provide multiple sets of raw data to an INSERT statement to create more than one row in a table. However, it is possible to insert a query’s results into a table. This can be used to add several rows at once.

(K. Brian Kelley) I have to support a third party application that periodically creates a new database on the fly. This obviously causes issues with our backup mechanisms. The databases have a particular pattern for naming, so I can identify the set of databases, however, I need to make sure I’m alw

(Rohatash Kumar) This article will give you an idea of how to use the space function in SQL Server. Here, you will see the space function with select and print or message statement. For example, if you concatenate two strings containing the first name Rohatash and the last name Kumar.

(Arshad Ali) SQL Server 2012 introduced an unified BI Semantic Model (BISM) which is based on some of the existing as well as some new technologies. This model is intended to serve as one model for all end user experiences for reporting, analytics, scorecards, dashboards, etc.

(Rohatash Kumar) In this article, you will see the SQL aggregate function Count in two forms, Count(All) and Count(Distinct) in SQL Server. The Count function is a part of the aggregate functions. In aggregates we consider various types of functions like count, max, avg, min, and sum.

(Jugal Shah) I have a requirement to add the Log Shipping Monitor for an existing installation. I have heard you can only complete this by rebuilding the Log Shipping infrastructure. Is that true? Are there any other options? In this tip I will explain how we can add the Log Shipping monitor to a

(Pinal Dave) Here is the question received just this morning.

(K. Brian Kelley) My organization is looking at SQL Server 2012 and I know that the ability to create roles at the server level is a new feature. Since this is new and impacts security, how do I handle them and how do I audit them?