LessThanDot Site Logo

LessThanDot

A decade of helpful technical content

This is an archive of the posts published to LessThanDot from 2008 to 2018, over a decade of useful content. While we're no longer adding new content, we still receive a lot of visitors and wanted to make sure the content didn't disappear forever.

Troubleshooting Merge Replication – Logging

When setting up and designing a merge replication publication that will utilize join filters, logging levels can be vital to determining design issues in the setup. Logging the synchronizing process quickly identifies points of failure and where to focus efforts to find a solution to the problems causing the failures. The following publication on AdventureWorks database has a design flaw relating to the article SalesOrderDetail. This publication has a parameterized filter on Person.

Read More...

SQL Advent 2011 Day 12: Table Value Constructor

In my Are you ready for SQL Server 2012 or are you still partying like it is 1999? post, I wrote about how you should start using SQL Server 2005 and SQL Server 2008 functionality now in order to prepare for SQL Server 2012. I still see tons of code that is written in the pre 2005 style and people still keep using those functions, procs and statements even though SQL Server 2005 and 2008 have much better functionality.

Read More...

SQL Advent 2011 Day 11: DML statements with the OUTPUT clause

In my Are you ready for SQL Server 2012 or are you still partying like it is 1999? post, I wrote about how you should start using SQL Server 2005 and SQL Server 2008 functionality now in order to prepare for SQL Server 2012. I still see tons of code that is written in the pre 2005 style and people still keep using those functions, procs and statements even though SQL Server 2005 and 2008 have much better functionality.

Read More...

SQL Advent 2011 Day 10: Upsert by using the Merge statement

In my Are you ready for SQL Server 2012 or are you still partying like it is 1999? post, I wrote about how you should start using SQL Server 2005 and SQL Server 2008 functionality now in order to prepare for SQL Server 2012. I still see tons of code that is written in the pre 2005 style and people still keep using those functions, procs and statements even though SQL Server 2005 and 2008 have much better functionality.

Read More...

Silverlight 5 available for download, will it be the last version?

Microsoft has made Silverlight 5 available for download. Here are some of the developer related enhancements: XAML Debugging with breakpoints for binding debugging Implicit data templates for easy UI reuse Double (and multi) click support GPU-accelerated XNA-compatible 3D and immediate-mode 2D API Low-latency sound effects and WAV support Real operating system windows and multi-display support Significant performance improvements, fixes and much more The question on my mind is if anyone should invest in Silverlight 5, will there be a version 6 or is this the last version that will be delivered?

Read More...

The Hanselminutes podcast player for Android 3.2 version 0.2

In the beginning of the week I started writing the Hanselminutes player for Android 3.2 because it seemed like something I would learn from. And man did I learn. First of all, it is still up on github. And I am now using IntelliJ instead of Eclipse. What I learned from version 0.2 Endless paging with a listview. AsyncTasks Adding progressdialogs Adding a contextmenu What did add in Version 0.

Read More...

Presentation Files: EDMPASS and ABQ SQL

One of the (many) great things about PASS Summit was the contacts I made for speaking at user groups. I was able to recruit many speakers for my UG, MADPASS, and I was also able to connect with other UG leaders who asked me to present for them. Thursday, December 8, I had the pleasure of speaking for the Edmonton, Alberta, Canada user group, EDMPASS. I talked about “Reporting Services 201: From Basic To WOW!

Read More...

Merge Replication – Parameterized Filters

Merge Replication can be a powerful tool for data mobility and distribution. Data can be distributed across a wide geographical range and maintained either from a client online or offline, and receive data changes from one or many sources on demand. With any large geographical distance, the least amount of data distributed per subscriber is ideal. If the source or originating data is in the hundreds of gigabytes, sending the entire database is simply not feasible.

Read More...

SQL Advent 2011 Day 9: Dynamic TOP

In my Are you ready for SQL Server 2012 or are you still partying like it is 1999? post, I wrote about how you should start using SQL Server 2005 and SQL Server 2008 functionality now in order to prepare for SQL Server 2012. I still see tons of code that is written in the pre 2005 style and people still keep using those functions, procs and statements even though SQL Server 2005 and 2008 have much better functionality.

Read More...

SQL Saturday in Chicago – Third year!

Today I have the absolute pleasure of announcing the third SQL Saturday in Chicago!!! It seems like only a few weeks ago the first SQL Saturday in Chicago ended. And wow, what a great event the first one was. Thinking about it now, that was SQL Saturday #31. We are all the way up to #119 now for total SQL Saturday events. That truly is remarkable and a great success in itself.

Read More...