Today is the two year anniversary of Less Than Dot, time is flying by so fast. I would like to list some stats about the site and also list the most popular blogposts, wiki pages and forum posts. Site stats Browsers Internet Explorer 43.64% Firefox 40.585% Chrome 10.55% Safari 2.
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.
Yes it has been 2 years since we launched this website. But I think the we started this thing about a year earlier. In the beginning mostly talking about it and then someone (damber) decided it was time for action and we set up the website. First we did this on a development server. First we had to choose the platform we were going to use. That was easy since money was a problem we choose a linux platform.
A virtual domain controller (DC) can be both a powerful and lightweight addition to your virtual lab. A central AD implementation not only gives you another set of services to work with, it also provides a more realistic environment with the power of domain accounts and policies that will be useful when you start working with multi-server setups. This article will walk through the creation of a basic 2008 R2 Domain Controller.
I’ve been approached on the web, in the SQL Community and in person several times with the question: “My Reporting Services instance loads Report Manager extremely slow. Why?” There are a few common primary causes of this. One is the instance being located on a DMZ and behind policies that cause the slow load times. I’m not a network guru and haven’t played in that field for 7-8 years so I can’t give you a lot of ideas to fix it.
Today I decided it was time to set some of my projects to use .Net 4 instead of .Net 3.5 and I felt the pain. First, I had some trouble with my barcodereader framework which was built for .Net 1.1. No problem, I quickly changed it over with another framework I like better and which is built for .Net 4.0. Then I committed and I broke the built :-(. The test projects I had converted to .
My favorite topic, “The SHRINK!” The topic really does cause pain. Shrinking a file in SQL Server is inherently a terrible action to take. However, we all know that in some cases when maintenance was never setup and recovery models were not properly chosen, the need does come up. An interesting topic came up on LTD in the forums regarding moving an overloaded and unmaintained log file to a server that had less disk space than the original.
I have been using Chrome for over a year now and have been very happy with it. Yesterday version 5 was released, you can get it here: http://www.google.com/chrome I decided to look at some stats for this site and compared April of this year to April of last year. The image below has this information. As you can see FireFox lost about 10% while Chrome gained 9% and Safari gained almost 1%.
Sometimes you have to “empty” the database, meaning you have to keep everything except data. One way is to script “everything”, drop DB and create it again. Another way is to delete data table by table, taking care of FK constraints, or to drop all FKs, then to remove data and at the end to restore FKs. Here are 2 scripts for creating SQL code to: a) Drop all existing FKs b) Truncate tables
A virtual database server provides you the ability to not only work on database-relate tools and services, but also to try out hundreds of vendor products throughout the market that require a database backend. This article will walk through a basic database setup for SQL Server 2008 R2 on a virtual machine using mostly standard installation options. This first installation will be limited to basic settings and a virtual harddrive, leaving us ready to customize the setup for later uses.
I have a bunch of processes that run at then end of the day. Some of these processes are configured dynamic since table names, server names, database names and a whole bunch of other stuff might change. So you might have a (over simplified here) table like this Typeid TypeName TypeValue 1 ActiveServerName SQLDenisDB1 1 DatabaseName MyDB 1 LogTableName LogFileTable And there might be a dozen more configurations for a process