(Beth Stackpole) If much of SQL Server 2008 R2’s focus was on making business intelligence (BI) more accessible to users as a self-service, then SQL Server 2012 is about building on that vision while making the concept of self-service BI easier for IT to manage, industry watchers say.

When you use either SCOPE_IDENTITY() or @@IDENTITY functions to retrieve the values inserted into an identity column, you may notice that these functions sometimes return incorrect values.

(Ashish Kumar Mehta) SQL Server 2012, code named Denali, has new features to perform Logical Functions such as CHOOSE and IIF that can be used to perform logical operations. In this tip we take a look at some basic examples of how this could be used.

(Madhivanan) As you know I have started a new series on “Exploring SSMS” by which I will be posting some features that are available in SSMS which will be very helping during the development. In this post we will see how to insert code template for creating a table, stored procedure, login etc in th

(Erin Stellato) I recently blogged about an interesting behavior in SQL Server when the database option, Auto Update Statistics, is disabled…and that post requires a sequel. The summary is that when you have the Auto Update Statistics option disabled for a database, query plans for tables are not r

(Pinal Dave) If you are following my recent blog posts, you may have noticed that I’ve been writing a lot about Guest User in SQL Server. Here are all the blog posts which I have written on this subject:

(Israel Cris Valenzuela) It is a frequent occurrence that we must remove leading and trailing whitespaces from a string before additional processing or sending it to another layer in an application. We can’t always control how the data is entered. The data might come from another system, a data conv

(Cathy Dumas) It is very handy to views as the table source definition in the the tabular model.

(Brady Upton) My boss is asking for a list of email addresses and phone numbers for all users in the company. I know this data exists in Active Directory, so how can I access this data from SQL Server? In this tip we walk through how you can query Active Directory from within SQL Server Management

(Satnam Singh) Scenario: A couple of days back, I got a call from one of my users saying that the Data is not being replicated properly onto the Production Reporting Server from the Production OLTP server.