Viewing 15 posts - 1,861 through 1,875 (of 3,616 total)
I'm working on a large data warehouse project so data quality issues are my world at present.
Data quality in any shape or form is everyones responsibility. It doesn't matter...
July 14, 2011 at 8:14 am
Oil is cheaper than engines:hehe:
Cleaning out your trunk/boot will save you fuel because you aren't lugging a lot of dead weight around. Get those purge/archive strategies defined.
Keep it clean...
June 29, 2011 at 2:49 pm
I tend to evaluate sites over time. Some authors I learn to trust, others I use to provoke thought.
In general I look for articles that give examples. In...
June 28, 2011 at 3:16 pm
The "Cloud" is a broad description that ranges from your own virtualised server infrastructure, through virtual servers in someone elses data centre and on to virtualised facilities in the public...
June 28, 2011 at 3:07 pm
The Italians reckon there are 3 ways to get rich.
Complex regulation is great for lawyers. Marry a lawyer quick!
If regulations were written as "How to comply...
June 23, 2011 at 1:19 pm
It's a fact of life that most people work for companies whose prime function is not to test software and fund software companies. Most companies see IT as a...
June 23, 2011 at 1:05 pm
I had a look at Pragmatic works BI documenter. It's pretty good.
I think Microsoft's next big step in the BI world should be a centrally managed meta data repository...
May 2, 2011 at 3:38 pm
Thomas Keller (4/11/2011)
Rather than changing the server default collation just to avoid the issue on the next database creation, how about changing the collation in the model database?
Nice thought, but...
April 13, 2011 at 2:57 am
The intent of Version 0 is to show what can be achieved. A taster with a promise of jam tomorrow. My worry is that executive thinking is "if...
April 11, 2011 at 3:27 pm
There are a couple of ways of fixing it. The one that springs to mind is as mentioned in Todd's blog. Change the mapping file in nHibernate...
April 11, 2011 at 3:19 pm
In addition to the "right tool in the right hands" comment I should like to add that you should make sure that you are using the right tool for the...
April 11, 2011 at 1:20 pm
If your field is an NVARCHAR and you use VARCHAR parameters you will get a seek because SQL is happier to turn a VARCHAR into an NVARCHAR than the other...
April 11, 2011 at 9:36 am
Nice to know I'm not the only one who bothers with this stuff.
The key points I was hoping to address were
Make it...
February 17, 2011 at 3:59 pm
I don't think it is worth compressing small lookup tables. In fact I noticed that a database containing nothing but small (<100 record) lookup tables actually grew.
Does the concept...
January 13, 2011 at 2:53 am
Wish I had a few more databases of sub-billion row tables:-P
The thing that has made MPP so attractive in the BI world is the explosion in data volumes. Not...
January 4, 2011 at 12:00 pm
Viewing 15 posts - 1,861 through 1,875 (of 3,616 total)