Next Dejan's courses

 

Blog Archive

 

 Dejan Sarka

 
 
Dejan's Blog 
Course-Schedule
 
Dejan Sarka

Changing the Blog Provider

2013-10-08 17:45:17 by Dejan Sarka

After years of blogging at SolidQ site, I decided to move my blog here, to SQLBLOG.COM. It seems that most of the SQL Server specialists like to hang around together. In addition, blogging on a specific company's site is not too popular because of possible...

Dejan Sarka

Changing the Blog Provider

2013-10-08 17:44:39 by Dejan Sarka

After years of blogging at SolidQ site, I decided to move my blog here, to SQLBLOG.COM. It seems that most of the SQL Server specialists like to hang around together. In addition, blogging on a specific company's site is not too popular because of possible...

Dejan Sarka

EIM Seminar at SQL Rally Amsterdam

2013-09-17 09:26:05 by Dejan Sarka

Want to learn more about data quality and master data management? Then meet me at my pre-conference seminar at SQL Rally Amsterdam, November 6th. Here is the description of the seminar.

Enterprise Information Management with SQL Server 2012, level 400

Companies...

Dejan Sarka

EMA – When a Cursor Is Faster than a Set Oriented Query

2013-09-10 18:45:34 by Dejan Sarka

Moving averages smooth extreme values. There are many different ways to calculate a moving average. Examples include:

  • Simple moving average
  • Weighted moving average
  • Exponential moving average

The formula for the last one is above....

Dejan Sarka

Fall 2013 Conferences

2013-08-22 18:10:36 by Dejan Sarka

Here is the list of the fall 2013 conferences where I am going to attend and speak, or have a pre-conference seminar. Of course, if you are interested in this list. If not, you do not need to stop reading now. It is still a list of good conferences, even...

Dejan Sarka

Interval Queries in SQL Server Part 5

2013-08-16 10:27:14 by Dejan Sarka

This is the fifth part of the solutions for interval queries in SQL Server. I know I wrote in the first one that there would be four solutions; however, I tested another one, and I think it is worth mentioning. However, if you don't want to lose your...

Dejan Sarka

Interval Queries in SQL Server – Wrap Up

2013-07-26 12:58:04 by Dejan Sarka

Because SQL Server does not have any support for temporal data out of the box, there are always problems with this kind of data. The most important problem is the performance. Traditional solutions have to deal with slow queries, which also make slow...

Dejan Sarka

Interval Queries in SQL Server Part 4

2013-07-23 08:18:29 by Dejan Sarka

This is the fourth part of the solutions for interval queries in SQL Server. For an introduction, please refer to the blog post Interval Queries in SQL Server Part 1 (http://blogs.solidq.com/dsarka/Post.aspx?ID=149&title=Interval+Queries+in+SQL+Server+Part+1)....

Dejan Sarka

Interval Queries in SQL Server Part 3

2013-07-22 09:02:06 by Dejan Sarka

This is the third part of the solutions for interval queries in SQL Server. For an introduction, please refer to the blog post Interval Queries in SQL Server Part 1 (http://blogs.solidq.com/dsarka/Post.aspx?ID=149&title=Interval+Queries+in+SQL+Server+Part+1)....

Dejan Sarka

Interval Queries in SQL Server Part 2

2013-07-20 12:44:11 by Dejan Sarka

I am continuing with presenting different solutions for interval queries in SQL Server. For an introduction, please refer to the blog post Interval Queries in SQL Server Part 1 (http://blogs.solidq.com/dsarka/Post.aspx?ID=149&title=Interval+Queries+in+SQL+Server+Part+1)....

Dejan Sarka

Interval Queries in SQL Server Part 1

2013-07-19 09:10:54 by Dejan Sarka

My good old friend Itzik Ben-Gan wrote an excellent article on interval queries in SQL Server (http://sqlmag.com/t-sql/sql-server-interval-queries) by using the Relational Interval Tree model. Based on the model developed by Kriegel, Pötke, and Seidl,...

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

Follow us on: