Next Dejan's courses

 

Blog Archive

 

 Dejan Sarka

 
 
Dejan's Blog 
Course-Schedule
 
Dejan Sarka

Introducing DB Flex

2013-05-23 07:09:23 by Dejan Sarka

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...

Dejan Sarka

Kako smo požrli NT konferenco

2013-04-29 10:10:52 by Dejan Sarka

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...

Dejan Sarka

What Are DQS and MDS About

2013-03-23 09:21:43 by Dejan Sarka

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...

Dejan Sarka

Data Modeling Essentials Seminar at DevWeek 2013

2013-02-25 10:54:24 by Dejan Sarka

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...

Dejan Sarka

Contingency Tables in SQL Server 2012

2013-02-05 09:42:23 by Dejan Sarka

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...

Dejan Sarka

New Courses in Stockholm

2013-01-22 08:10:39 by Dejan Sarka

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...

Dejan Sarka

SQL Saturday 176 Pordenone Presentation

2012-11-05 19:32:34 by Dejan Sarka

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...

Dejan Sarka

MS SQL Server 2012 Learning Path (Slovenia)

2012-10-31 08:45:25 by Dejan Sarka

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....

Dejan Sarka

SQL Server 2012 MDS Excel Add-in Link and DQS Integration

2012-03-11 08:15:57 by Dejan Sarka

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....

Dejan Sarka

MDS 2012 RC0 and Windows Built-In Groups

2012-02-21 07:13:30 by Dejan Sarka

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...

Dejan Sarka

Why Time Series Forecasts Impossible Numbers

2012-02-16 12:51:48 by Dejan Sarka

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...

Dejan Sarka

SQL 2012 XML exist() Function NULL Comparison

2012-02-11 23:34:08 by Dejan Sarka

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...

Dejan Sarka

SQL Server 2012 XQuery Supplementary Characters Support

2012-02-09 15:56:25 by Dejan Sarka

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....

Dejan Sarka

SSAS 2012 RC0 DMX IMPORT bug Workaround

2012-02-08 08:17:40 by Dejan Sarka

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...

Dejan Sarka

Why Is Bleeding Edge a Different Conference?

2011-07-29 15:31:59 by Dejan Sarka

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...

Follow us on: