(Scott Mattie) As I stated in my last post, I am going to do a series of the new features in Server 2012. Today, I am going to start with the most obvious change… the start menu that has died and is no longer present. Rumor mills have it that Microsoft is determined to leave it out, by removing all

(Jude O’Kelly) Entity Framework originally shipped with two modes – Model First which allowed for the entity model to be created using the designer UI and Database First which created the EF model from a database.

(Rick Dobson) Have you ever wanted to compute age, but the results from the DATEDIFF function seemed to be wrong some of the time? In this tip we cover why the DATEDIFF function does not always reliably compute age?

(Katie and Emil) In this SQL Tutorial I will show you how to create a Unique Constraints. For the purpose of this tutorial I will use SQL Server 2012.

(Matija Lah) The storage of large data used to present quite a challenge in previous versions of SQL Server, especially prior to SQL Server 2008. Although appropriate data types were already available in earlier versions of the platform (e.g. IMAGE, VARBINARY(MAX), or even TEXT, or NTEXT data types)

(Scott G Blood) SQL Server Management Studio provides most of the basic GUI based functionality required to manage an instance of SQL Server on a daily basis quite easily, however there are a number of functions missing from this, such as the ability to search for text within a stored procedure or s

(Pinal Dave) I personally use the sys schema and DMV to retrieve most of the information. However, I am not surprised see usage of Information_Schema. It has been very popular and works in most of the time.

(Jeremy Kadlec) In some of your tips you reference sp_recompile as a stored procedure that needs to be executed during some maintenance related processes. After doing some basic research it looks like I can execute sp_recompile against a particular stored procedure or against a table so that all ob

(Pinal Dave) Earlier this week I wrote a blog about Find Column Used in Stored Procedure – Search Stored Procedure for Column Name. I received plenty of comments on the subject. One of the statements which I used in the story (Time: Any Day – usually right before developer wants to go home) was very

(Colleen M. Morrow) Last time we went over the basics of creating a SQL Audit. Now obviously once you’ve gotten your audit in place, you’re going to want to look at the output once in a while, right? Right. So that’s what we’re going to go over today.