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.

Windows Azure, SQL Azure and .NET Services pricing announced

Microsoft announced pricing for Azure. Today, during the Microsoft Worldwide Partner Conference 2009 Microsoft announced the business and partner model for the Windows Azure platform including service level agreements and support programs. Windows Azure, SQL Azure and .NET Services will be commercially available at the Professional Developer Conference 2009 and Microsoft hopes you will continue building on the Community Technology Preview (CTP) at no cost today. Upon commercial availability Microsoft will offer Windows Azure through a consumption-based pricing model, allowing partners and customers to pay only for the services that they consume.

Read More...

Messing around with Office 2010, I like what I see

I installed Office 2010 last night and already I am liking it a lot after using it for about 30 minutes. There are some time savers in this release that will come in handy. This will be just a short post and I will only cover Excel 2010 and Word 2010. The first new thing I noticed is that you can customize the ribbon now very easy. Another handy thing is that when you hit print, you get the print preview right away.

Read More...

Vulnerability in Microsoft Office Web Components control could allow remote code execution

Vulnerability in Microsoft Office Web Components control could allow remote code execution Another critical problem that is currently being exploited in the wild (0 day attack). Microsoft is investigating a privately reported vulnerability in Microsoft Office Web Components. An attacker who successfully exploited this vulnerability could gain the same user rights as the local user. When using Internet Explorer, code execution is remote and may not require any user intervention.

Read More...

Shrink log in all your user databases

A recent post in the forum I frequent presented an interesting problem – shrink log file in all user databases. See the reasons why it may not be a good idea explained in Do not truncate your LDF files and Why you want to be restrictive with shrink of database files.

The first idea that came to mind was to use sp_MSForEachDB non-documented stored procedure for this task. You can find this article by Arshad Ali very helpful in understanding sp_MsForEachTable and sp_MSForEachDB stored procedures and their parameters.

Read More...

How to get data out of Microsoft Dynamics Great Plains

Well as anyone who has had the luxury of working with Great Plains and its database, you know it’s close to impossible to find data in the database. Well fear not, for there is a way to navigate this labyrinth of a database. The Great Plains developers, as kind as they are, created a tool that allows you to see their documentation on the database and application. If you know the name of the form you want to get data from, you can get it.

Read More...

Well as anyone who has had the luxury of working with Great Plains and its database, you know it’s close to impossible to find data in the database. Well fear not, for there is a way to navigate this labyrinth of a database. The Great Plains developers, as kind as they are, created a tool that allows you to see their documentation on the database and application. If you know the name of the form you want to get data from, you can get it.

Read More...

How to get data out of Microsoft Dynamics Great Plains

Well as anyone who has had the luxury of working with Great Plains and its database, you know it’s close to impossible to find data in the database. Well fear not, for there is a way to navigate this labyrinth of a database. The Great Plains developers, as kind as they are, created a tool that allows you to see their documentation on the database and application. If you know the name of the form you want to get data from, you can get it.

Read More...

Go ahead and click it! I triple dog dare you!!!

As a DBA the word no comes out of us often. It’s just the nature of our jobs that we will find ourselves not accepting requests and revoking bad choices already made. If you are a DBA and you’re a yes type of person then you’re in the wrong field. Protecting the company heart and soul in the form of data cannot be successful with the word yes. It’s just not possible.

Read More...

Push your DBA skills over the edge by becoming a better developer

A few days ago I had a situation in which I needed to get backups for one of my DBs off to the hot site for disaster/recovery purposes. The primary goal was for me to again remove the need to rely on tape backups from my recovery plans. I already have Quests Litespeed in place and with that have the ability to retain a month of backups on a disk array attached to the instance that this DB resides on.

Read More...

How to search for all words inclusive without using Full Text search

I encountered this question last October in one of the forums I’m frequent. The question was: given the table with the keywords, find all records from some table which would include all these words (Implementing search with AND keyword).

Read More...