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.

SSMS Tools PACK 1.1 – now with SQL Server Management Studio 2008 support

Mladen Prajdić has updated his SSMS Tools PACK to work with SQL Server 2008. Here are some of the cool new things – Query Execution History (Soft Source Control) and Current Window History: Save all executed queries to file or database and easily find them. Current window history is a dockable window that show queries executed in a currently active window. There is also a search box at the top that filters results as you type

Read More...

VB.Net: Rhino mocks 3.5 and Lambda expressions and AssertWasCalled not always working

There is no bug in Rhino mocks if that’s what you’re thinking. Rhino mocks 3.5 just uses things that VB.Net 9.0 can’t use and that can be frustrating. I wonder what possessed them to do it like that? So let me tell the story. I got a service and a repository, the service calls the repo. Repo interface: Namespace Repository Public Interface IRepository(Of T) Function FindAll() As IList(Of T) Sub Update(ByVal ObjectToUpdate As T) End Interface End Namespace``` The repo implementation: ```vbnet Imports System.

Read More...

Mono 2.0 Has Been Released

Mono 2.0 Has Been Released Mono 2.0 is a portable and open source implementation of the .NET framework for Unix, Windows, MacOS and other operating systems. Some Details: Microsoft Compatible APIs ADO.NET 2.0 API for accessing databases. ASP.NET 2.0 API for developing Web-based applications. Windows.Forms 2.0 API to create desktop applications. System.XML 2.0: An API to manipulate XML documents. System.Core: Provides support for the Language Integrated Query (LINQ). System.Xml.Linq: Provides a LINQ provider for XML.

Read More...

Kilimanjaro is the code name for the next version of SQL Server

So after Shiloh, Sphinx, Yukon and Katmai now we have Kilimanjaro. Kilimanjaro is a mountain in Tanzania and the new codename for SQL Server 11 🙂 [Edit]Apparently Kilimanjaro is the code name for the next version of SQL Server but this is not SQL 11 🙁 Here is what it says in the press release Ted Kummert, corporate vice president of Microsoft’s Data and Platform Storage Division, showcased “Kilimanjaro,” which will further enrich SQL Server’s BI capabilities while providing a robust and scalable data platform capable of supporting the largest BI deployments.

Read More...

VB.Net: Visual studio intellisense doesn’t like lambda expressions

Well, not in this case anyway. I have this Rhino mocks method that uses a lambda expression. Like this: vb.net _MspFactory.Stub(Function(e) e.CrudLocus).Return(_CrudILocus) And that happens to work and compile. However, intellisense doesn’t seem to be able to infer the type of e like the compiler seems to be able to do. Just look at picture 1. But when I specify the type, it is happy to add the intellisense.

Read More...

Npgsql2 the PostgreSQL Net Data provider written 100% in C# has been released

Npgsql2 has been RTM 🙂 Npgsql is a .Net Data Provider for Postgresql. It allows any program developed for .Net framework to access the PostgreSQL database server. It is implemented in 100% C# code. Works with Postgresql 7.x and above. Npgsql2 Supports .Net 2.0 and 3.5 and there is even added support for the EntityFramework You can download all the goodies here: http://pgfoundry.org/frs/?group_id=1000140

Read More...

VB.Net: Rhino Mocks and the AAA syntax

So, last week Ayende made a new version of Rhino Mocks available, namely version 3.5. He made a post on what is new and shiny, but I would like to look at what the new AAA syntax has in store for us VB.Net users. And I want to tell you how it used to look and how it looks now. This is the old version, works with Rhino mocks 3.4.

Read More...

How To Convert IP Addresses Between Bigint and Varchar

Before we start with code let us take a sample IP address, does 127.0.0.1 look familiar? Yes that is your local IP address. Here it is in decimal and binary 127 0 0 1 01111111 00000000 00000000 00000001 Now to convert, you would take the first value, add the second value + 256 add the third value + (256 * 256) = 65536 add the fourth value + (256 * 256 * 256) =16777216

Read More...

Free SQL Server Books

Belle's sql musings blog has a list of 7 free SQL Server books. The books are the following ones SQL Server 2008 MS Press Free Ebook How to Become an Exceptional DBA Best of SQL Server Central Brad’s Sure Guide to SQL Server 2008 Brad’s Sure DBA Checklist RedGate’s SQL Server DBA Best Practices Dissecting SQL Server Execution Plans These books are offered by Microsoft Press, RedGate and SimpleTalk Get the links to all these books here: http://sqlmusings.

Read More...

Office Inspiration Quotes

A few tag lines for your motivational posters at work… Rome did not create a great empire by having meetings, they did it by killing all those who opposed them. If you can stay calm, while all around you is chaos… then you probably haven’t completely understood the seriousness of the situation. Doing a job RIGHT the first time gets the job done. Doing the job WRONG fourteen times gives you job security.

Read More...