If you want to read more about the product and the upcoming changes, check out Red-Gate's forum for SQLPrompt. It includes a special price offer: $99 introductory offer for pre-orders.
Read more →
A couple of months ago, I wrote a quick post about SQLPromptwhich had been purchased by Red-Gate Software. I have been using it since then and it really has proven to be a handy tool.
Read more →
I just downloaded and installed the free tool SQLPrompt, now from Red-Gate Software, and I'm really liking it. It provides Intellisense or statement-completion features in SQL Query Analyzer, SQL Server Management Studio, Visual Studio, and other development tools.
Read more →
Jakob Nielsen, a renowned web design and usability expert, has come up with the Top 10 Design Mistakes for Weblog Usability. You might think, from the title, that there is nothing you can do because you did not design your weblog, you are using someone else's software.
Read more →
From The Daily WTF... How NOT to SELECT records in your database.
Apparently in his version of SQL Server, WHERE clauses only work on Temp tables.
Legacy Comments
Brett
2004-09-01
re: How NOT to Select Records That's great.
Read more →
This is a real pet peeve of mine, and I know some of you consider what I'm about to rant about to be some form of “best practices” or that “it just makes sense”, but I don't like it and I wish you'd stop.
Read more →
A question on SQLTeam a few weeks ago got me thinking about the idea of what language you THINK in. Do you remember the movie Firefox? (Okay, that came out in 1982, before some of you were even born, but at the time I was a Clint Eastwood fan and into military aircraft, so back off!
Read more →
A while back, I blogged about having separate dev, test/QA, and production environments. Recently, I was discussing with one of my clients the fact that they really needed more than one test/QA environment because they needed specific scenarios in their data to test the functionality of a broad spectrum of code paths.
Read more →
In the comments section of my SCRIPT IT post, Lisa asked a couple of questions for clarification. These were a good reminder to me that some of the things that I just take for granted these days are actually very new concepts to others who haven't had the same experience.
Read more →
The focus of MS DevDays 2004 was on writing secure code. In the Web Development Track of the event, Paul Litwin demonstrated SQL Injection attacks against a simple Login web page.
Read more →
In the comments to my post on running separate dev, test, and live databases, Karl raises a question about the build process and using source control. Well, first, if you've read my Script It!
Read more →
You DO backup your databases, don't you? And you do test your backups occasionally to make sure they're good, don't you?
One of my clients didn't, and they got bit hard recently.
Read more →
“You DO have a separate development environment, don't you?” I've made a comment like that a few times here on the blog, and to an experienced DBA it seems so obvious, but let's talk about it just to be sure (and for those people just starting their careers).
Read more →
Whether 'tis nobler in the CPU to suffer the slings and arrows of outraged users... oh, never mind. Back to the topic at hand which really is all about how you modify your SQL Server objects.
Read more →
If you use Enterprise Manager (EM) to create or edit table structures, data, stored procedures, or much of anything else, you are a rookie. Now, each one of us was a rookie at some point, and you do have to start somewhere, but if you want to be considered a professional, you HAVE TO learn the SQL syntax and get comfortable living in Query Analyzer (QA).
Read more →
Damian recently spoke out on versioning code, and it reminded me of a nightmare I'm involved in with versioning documentation. Yes, it's true, documents (you know, things like written specs, test plans, etc.
Read more →