All Articles - SQL Authority with Pinal Dave

SQL SERVER – Core Concepts – Elasticity, Scalability and ACID Properties – Exploring NuoDB an Elastically Scalable Database System

September 13, 2012

I have been recently exploring Elasticity and Scalability attributes of databases. You can see that in my earlier blog posts about NuoDB where I wanted to look at Elasticity and Scalability concepts. The concepts are very interesting, and intriguing as well. I have discussed these concepts with my friend Joyti M and together we have come…

SQL SERVER – Get Date and Time From Current DateTime – SQL in Sixty Seconds #025 – Video

September 12, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video

Database, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio

This is 25th video of series SQL in Sixty Seconds we started a few months ago. Even though this is 25th video it seems like we have just started this few days ago. The best part of this SQL in Sixty Seconds is that one can learn something new in…

SQL SERVER – Why Do We Need Master Data Management – Importance and Significance of Master Data Management (MDM)

September 11, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Let me paint a picture of everyday life for you. Let’s say you and your wife both have address books for your groups of friends. There is definitely overlap between them, so that you both have the addresses for your mutual friends, and there are addresses that only you know,…

SQL SERVER – Why Do We Need Data Quality Services – Importance and Significance of Data Quality Services (DQS)

September 10, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Data Quality Services, DQS

Databases are awesome. I’m sure my readers know my opinion about this – I have made SQL Server my life’s work after all! I love technology and all things computer-related. Of course, even with my love for technology, I have to admit that it has its limits. For example, it…

SQL SERVER – Configuring Interactive Cleansing Suggestion Min Score for Suggestions in Data Quality Services (DQS) – Sensitivity of Suggestion

September 9, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Data Quality Services, DQS

Earlier I talked about what kind of questions, I do not like when I get asked. Today we will go over the question which I like when I get asked the same. One of the reader practices various steps in my earlier blog post Step by Step Guide to Beginning…

SQL SERVER – Unable to DELETE Project in Data Quality Projects (DQS)

September 8, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Data Quality Services, DQS

Here is the email which made me write this blog post. When I write a blog post I write keeping in mind that if the developer is not familiar with the concept he will attempt this on the development server. If due to any reason you attempt it on any…

SQL SERVER – Fun Post – Connecting Same SQL Server using Different Methods

September 7, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

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…

SQL SERVER – FIX ERROR – Cannot connect to . Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. (Microsoft SQL Server, Error: 18452)

September 6, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

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…

SQLAuthority News – A Quick Note on @Pluralsight Video – Call Me Maybe Developer Way

September 5, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video

I write a lot about how important learning and training is. Any of my readers will know that I think the key to success is staying current with your education and taking very opportunity to increase your “tool kit” of skills. I hope that I have not made the impression…

SQL SERVER – Step by Step Guide to Beginning Data Quality Services in SQL Server 2012 – Introduction to DQS

September 4, 2012

Pinal Dave

SQL Tips and Tricks

Business Intelligence, Data Quality Services, Data Warehousing, DQS, SQL Server

Data Quality Services is a very important concept of SQL Server. I have recently started to explore the same and I am really learning some good concepts. Here are two very important blog posts which one should go over before continuing this blog post about Data Quality Services.