 In these times of weird economics in many places, more and more small and medium companies try to operate without a dedicated database administrator (DBA). Other companies still have one or more dedicated DBAs, however, (s)he or they is or are overwhelmed... First a quick note to my regular readers. I decided for a post in Slovenian language, because I want to address my fellow citizens only. You are not missing anything, this is not a technical blog.
Končana je 18. NT konferenca, kot kaže, tudi zadnja NT... This is just a very quick information about SQL Server 2012 Data Quality Services (DQS) and Master Data Services (MDS). If you don't have a clue what they are useful for, this blog post should give you the basic idea.
Many companies or organizations do... Bad database design and inefficient queries lead to applications that are hard to maintain and upgrade and that don't perform well. Why don't you start with a good design? Join me during the DevWeek 2013 post-conference seminar that provides developers... Contingency tables are used to examine the relationship between subjects' scores on two qualitative or categorical variables. They show the actual and expected distribution of cases in a cross-tabulated (pivoted) format for the two variables. Here is... After finishing two books, I am not finished with writing yet. I renewed my Data Mining course to SQL Server 2012 version. In addition, I am currently writing an Enterprise Information Management course with title Data Quality and Master Data Management... I would like to invite you to my presentations in the SQL Saturday #176 event in Pordenone, Italy, November 17th, 2012. I am having two presentations: Market Basket Analysis and High Performance Statistical Queries. I just want to give you little bit... I created a diagram for the standard learning path in Slovenia for SQL Server 2012. We are implementing this learning path together with Kompas Xnet. The learning path includes both, Microsoft and SolidQ courses. Our courses complement Microsoft courses.... 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 2012 feature Pack site - http://www.microsoft.com/download/en/details.aspx?id=29065.... 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 groups. For example, the following picture shows... 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 time, you might already have made wrong decisions... 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 code:
DECLARE @test AS XML;
SET @test = NULL;
-- Returns... 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 codepoint, a value in the range 0x0000 to 0x10FFFF.... 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 models cannot be processed and used. I tried with... 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 is the reason for this status, what makes it different... |
|