 In SQL 2012 RTM, in Master Data Manager home page, there is a link to MDS Excel Add-in. However, the link is broken. However, as my good friend Allan Mitchell pointed me, you can download it from SQL Server... I noticed an interesting issue with SQL Server 2012 RC0 Master Data Services. It seems that security does not work for some built-in Windows groups. It looks like MDS is not recognizing membership of some... How can you measure the quality of forecasted values with the Time Series algorithm when you do not have the actual data yet? Waiting until the data is available is likely not practical because by that... If the XML data type exist() function returns NULL and is used in comparison with 0, the comparison returns NULL in SQL 2012. Such comparison returned TRUE in previous versions. Consider the following... From SQL Server 2012, XQuery functions are surrogate-aware. SQL Server Unicode data types, including NCHAR, NVARCHAR, and XML, encode text in UTF-16 format. SQL Server allocates for each character a unique... In SSAS 2012 RC0 Dimensional, importing a model with dependencies using the DMX IMPORT statement does not import data source views from a backup made with SSAS 2005, 2008 or 2008 R2. Thus, the imported... With friends Matevž Gačnik and Dušan Zupančič, we are preparing the Bleeding Edge conference for the fourth year. During last three years, the conference achieved status »different« among attendees. What... Microsoft Slovenia decided that they will join Bleeding Edge with the //BUILD/Slovenija event. And it is even better – we did not raise the price. Therefore, for the price of one, you get two days of in-depth... With Davide Mauri, we finished a new e-book "Data Quality and Master Data Management with Microsoft SQL Server 2008 R2". We decided that we are making the book available as free download. You... A picture is worth 1,000 words…
My good friend Gianluca informed me that Microsoft created a new add-in for Excel 2010: Fuzzy Lookup. Fuzzy Lookup was developed by Microsoft Research and was first introduced in SSIS 2005. Now it is available... With mixed feelings I am announcing this: C. J. Date has a two-day seminar in Ljubljana (http://www.dbprof.com/).
Why are my feelings mixed? Well, IMHO C. J. Date is the most important contemporary theorist... SQL Server supports CLR objects in a database. But – how much do we use them? I find myself as one of the rare SQL CLR users. I created myself a set of tools that include data types, scalar and especially... I felt many times that it is not so clear what to do to make a successful data mining project. Here are some guidelines I like to follow.
In the beginning, I have to point out that data mining is not a... From a conversation with other MVPs, I came to a conclusion that most of people are confused with term "lookup table". Many different opinions arose, like whether to have a single or multiple... |
|