SQL Server Archives - Page 135 of 393 - SQL Authority with Pinal Dave

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

September 11, 2012

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…