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. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.
Your profile
Tag cloud
book bug business intelligence database dates dmv functions gemini gotcha how to howto indexing interview madison performance performance tuning postgresql programming sql sql friday sql server sql server 2000 sql server 2005 sql server 2008 sql server 2008 r2 sqlserver t-sql tip trick xml
Authors
- SQLDenis (166)
- onpnt (86)
- George Mastros (32)
- chrissie1 (8)
- naomi (7)
- emtucifor (6)
- Alex Ullrich (6)
- thirster42 (4)
- ramireddyindia (2)
- riverguy (1)
- tarwn (1)
- pmch22 (1)
- More...
Main Categories
Search
XML FeedsGoogle Ads
Tags: best practices
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 and specify what to check.
I wonder if people would be interested in such a tool, I started a therad here: SQLCop and got some feedback from various people.
Here is what I want this tool to do
identify that:
no p...
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 of course. So what is ISO-11179?
The ...
LTD Social Sitings
Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.