(Pinal Dave) Yesterday I had faced error when I was connecting SQL Server using 127.0.0.1. I had immediately checked if SQL Server is working perfectly by connecting to it by specifiing my local box computer. While I was doing this suddenly I realize that it is indeed interesting to know how many di

(Mihail Mateev) Many developers have been asking since the release of SQL 2008 for support of Spatial data types in the Entity Framework. It was a dream for the Microsoft ORM users to create .NET business applications quickly, using spatial data. In May of this year the release candidate for Entity

(Seth Delconte) What is the most efficient way to modify XML values? To allow for precise modification of XML nodes and values, the XQuery XML query language employs an extension known as the XML Data Modification Language (DML). The XML DML uses the XML modify() method, which makes use of three ope

(Vipendra Verma) In this article I am explaining how to fetch records using a cursor in SQL Server 2012. A cursor in SQL serever 2012 is a database object that points to a result set. We use a cursor in SQL Server 2012 to retrieve a specific row or data from a result set.

(Glenn Berry, Louis Davidson and Tim Ford) There is a persistent need to minimize logical and physical I/O. The collection of I/O-related database management objects (DMOs) helps investigate, specifically, physical I/O taking place on your system, when data is written to and read from disk.

(Pinal Dave) Just a day ago, I was doing small attempt to connect to my local SQL Server using IP 127.0.0.1. The IP is of my local machine and SQL Server is installed on the local box as well. However, whenever I try to connect to the server it gave me following strange error.

(Ben Snaidero) Referential integrity is a very important thing to consider when designing a database. In my years as a DBA I’ve seen database designs that sit on both ends of the spectrum, none at all and cases where every table is linked to multiple tables. While the later certainly can be a little

In the previous SSWUG TV interview with Stephen Wynkoop, we covered “How to handle the situation when your peer is now your boss?” This is a more detailed discussion of that topic.

(Michael McLaughlin) After you’ve installed Microsoft SQL Server 2012 and created a database schema, you still need to setup or configure the database schema. That means you must grant permissions to a user to work in the database schema, otherwise you get the following type of error message.

(Vipendra Verma) A Trigger in SQL Server 2012 is a special kind of stored procedure that is automatically fired, invoked or executes when an event occurs in the database server. We can create a Data Manipulation Language (DML) trigger and a Data Definition Language (DDL) trigger in SQL Server 2012.