A year ago, I sat down and wrote 2011 Goals: Bring It On. I wanted to go big in 2011. I wanted to grow. I wanted to experience new things. And the year was a smashing success. Highlights The people. From the LTD posse to my MADPASS posse to the people I met at the FreeCon in March to all 1,000 people I introduced myself to at Summit (I’ll get the other 4,000 next year)…the best part of my year was the people.
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.
After a few weeks of work (having fun) I decided that the next step would be to publish my first attempt at a real android app. That real android app was the Hanselminutes player for which you can find the sourcecode on github. And you can find the app on the market. My first attempt was just for android 3.2 and above, but I changed that today to make it 2.
Another year is about to end, time to do another post with some stats and numbers The 10 most read posts of the year We had a lot of blog posts in 2011, I blogged 105 times the last year. Here is a list of the ten most read posts for the year 2011 Should I abandon VB.Net? Calculating Mean, Median and Mode with SQL Server The Ten Most Asked SQL Server Questions And Their Answers You need to have hardware virtualization enabled if you want to run Windows 8 in Virtual Box 6 ways to import data into SQL Server SQL Server Zipcode Latitude/Longitude proximity distance search How to enable xp_cmdshell and Ad Hoc Distributed Queries on SQL Server 2005 VB.
Several weeks ago I was refreshing my memory on some nvarchar/varchar tradeoffs when I ran into a post by Michael J Swart (blog|twitter) where he shared the results of investigating a performance problem in one of his live environments. After changing many columns from varchar to nvarchar, he had several procedures that were taking much longer to execute without any changes in I/O profile. This led him to compare the execution times of searching a varchar vs an nvarchar column, where he found that searching an nvarchar took 800% as long as a varchar.
Continuing onwards with the SQL Server auditing feature, let’s start off by creating a simple audit that will capture some database level events. Previously we looked at how to create a Server Audit Specification and creating a Database Specification follows the same steps. The main difference is the location, as well as the objects to capture. In the following example we will look at capturing delete statements on a database.
This is the last post as part of SQL Advent 2011. You can find all of them linked here: SQL Advent 2011 Recap All the posts so far were about SQL Server 2005 and SQL Server 2008, this post will have links to all the SQL Server 2012 posts I have created First look at SQL Server Management Studio Denali In this post I show you what the new SQL Server Management Studio which is based on Visual Studio 2010 looks like
SQL Advent 2011 has come to an end. I had lots of fun writing these but I wished I started earlier instead of 2 days before December 1, on some days I was really racing against the clock and I feel like I made some posts much shorter than I had in mind initially. But it is what it is, I hope you enjoyed them, maybe I will do this again next year.
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.
For my android application I made a class that contains an alertdialog with just a yes and a no button. I use winforms a lot and I was thinking the alertdialog in android was the same. Well it isn’t. ```java public class YesNoAlertDialogImpl implements YesNoAlertDialog { @Override public boolean show(View view, String title, String message) { boolean result = false; AlertDialog.Builder alert = new AlertDialog.Builder(view.getContext()); alert.setTitle(title); alert.setMessage(message); alert.setPositiveButton("Yes",new DialogInterface.OnClickListener() { @Override public void onClick(DialogInterface dialogInterface, int i) { result = true; } }); alert.
Upgrade Assistant for SQL Server 2012 (UAFS) has Released To Web(RTW). Upgrade Assistant for SQL Server 2012 is shipped as a free web-downloadable tool. It performs application compatibility testing and detects potential functional and performance issues that may impact a database upgrade from an earlier version of SQL Server (SQL Server 2005, SQL Server 2008 or SQL Server 2008 R2) to SQL Server 2012. Comparing to the early version of Upgrade Assistant tool, Upgrade Assistant for SQL Server 2012 significantly enhances replay scalability and performance by building on top of SQL Server 2012 Distributed Replay (D-Replay) feature, which is the first released application that demonstrates the value of D-Replay in a practical application.