Until product owners are willing to put enough detail into requirements documents, we're not going to see AI build complete programs. I know that I routinely round trip back to...

• This reply was modified 6 years, 5 months ago by Tom Uellner.

I wouldn't be a fan of 45-50 minute sessions. Presenters need a little bit of time to introduce themselves and give a little background and that takes some time from...

We have several internal applications that make use of the same database. We use schemas to separate data and code specific to one application or another into their own schemas....

Rather than download SQL Server 6.5 from a random FTP site, you can download WinSQL Lite free and connect to your 6.5 database via that.
WinSQL

I don't believe that SSMS is ever going to be efficient in displaying that many users in Object Explorer. You are far better off looking at that kind of data...

Installing on a new VM allows you to take advantage of installing a newer OS version as well. Just one more thing to consider.
Not so bad if you're current...

As the Mythbusters frequently said, “Failure is always an option.”

Nobody gets everything right the first time, all the time. Developers and DBAs need to be able to experiment...

One place I worked we did one code review and I was the reviewer. The person who’s code I reviewed was a VB6 / Access guy who was thrown into...

Life before SQL Server was as a software engineer (which I still do to a small extent). I'd probably go back to that but I'd also be very tempted to...

We are using Ecrion to produce reports. The report designer is similar to the usual Office tools but it can be a steep learning curve for more complex documents. There...

I really like Redgate SQL Prompt. With some of the horrendous T-SQL code I inherit, it makes my life a lot easier. Sometimes I just reformat a section of code...

I've only had to restore twice at my current job. Once when a developer dropped a table. That was reference data and restored from the previous nights backup. The other...