LessThanDot Site Logo

LessThanDot

A decade of helpful technical content

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary.

Browsing "best practices"

Scripts to Detect Data Warehouse Issues

Standards and best practices are like flu shots you take before you’re infected; Database best practices protect your databases from bad things. But, we all make mistakes. It could be because we’re on a time crunch, or we’re lazy (which I’m guilty of by…

Read More...

Please don’t use blacklists, use parameterized queries or stored procs instead

Every now and then you will hear how some site will use a blacklist to ‘protect’ themselves against sql injection. Using a blacklist is very foolish because you can’t ever think of all the different ways that the bad guys will try to bypass your little…

Read More...

SQLCop behind a Proxy

SQLCop uses an internet connection to ensure that all checks and updates that are added are maintained. When SQLCop first loads, it checks the SQLCopConfig.xml file to determine if a new SQLCop.xml file needs to be downloaded. If SQLCop is unable to download the configuration file, it will automatically use the previously saved sqlcop.xml file. Because of this, a remote file request is always performed when you start up SQLCop.In order to work around this problem with proxy servers there is one of two things you can do to run SQLCop.

Read More...

SQLCop, FxCop For SQL Server, Would You Be Interested in This?

I have been thinking about creating a tool like this for a while now. I know that there is the SQL Server 2005 Best Practices Analyzer and that in SQL server 2008 this has become Policy Management. What I want to create is a pure T-SQL tool where you can just run a stored proc […]

Read More...

Patterns And Practices Application Architecture Guide 2.0, Something Everyone Should Read

I was listening to show number 426 on dotnetrocks: Rob Boucher on Application Architecture Guidance! They mentioned the Patterns And Practices Application Architecture Guide 2.0, this guide is available for free on codeplex.

Although it is a Microsof…

Read More...

Want To Learn Scrum? Visit About Scrum.

I noticed that a new site has been launched named About Scrum This site is intended to be a resource for those who wish to learn about SCRUM and software project management in general. So far it is looking great, they have a couple of videos up and also a bunch of articles. Here is […]

Read More...

ISO-11179 Naming Conventions

Straight from the man himself comes this statement posted in the microsoft.public.sqlserver.programming forum: “You need to read ISO-11179 so you use proper data element names. You actually had “tbl-“on the table names! Sometimes “id” id a prefix and sometimes it is a postfix.” Of course you know who I am talking about? No? Joe Celko […]

Read More...