Two things:

- Maybe my browser rendered the page incorrectly, but I had a hard time reading it as it was all black text on a dark grey background.

- The author...

My wife is generally the "just make it work" kind, also, but a number of years ago she was working in a local government office and decided to create a...

I'm pretty much the same, with the addition of downloading and installing SQL Server Express (free) or purchasing the Sql Server Developer version (available for around $60 or so) on...

Koen Verbeeck (10/16/2013)

---

ordered the book by the way, it will be delivered this week 🙂

In a few weeks I'll attend an analytics seminar where Kimball will deliver the keynotes.

Might...

I've run into this when there is an extra CR/LF at the end of the file: In other words, your last actual line of data has a CR/LF and there...

PiMané (9/30/2013)

---

Hi,

Why doesn't a RAISERROR inside an AFTER trigger "break" the transaction? Is there any flag or SET option to do it?

The update is committed even with the error raised...

Might I suggest Rodney Landrum's SQL Tacklebox located here:

http://www.red-gate.com/community/books/sql-server-tacklebox

He includes a boatload of scripts - downloadable as a zip file - for documenting and monitoring SQL Server instances using T-SQL...

Yuck.

You can also import each entire line into a table then use some kind of multi-pass replace() construct or a REGEX via CLR to change out the delimiters.

Nope. Only affects the session. I've been developing code to create and update a master calendar table for our organization so...

Just FYI - Kimball is up to third edition now. I haven't...

You also want to check your anti-virus software and firewalls and be sure DatabaseMail is permitted.

I've mentioned this example before, but it's completely appropos:

My boss used to work for a call center. Every so often the entire system would crash for no apparent reason....

Well, you CAN kill...

Did someone mention backups and restores?

Having just finished restoring a blown server which housed our SQL Server instance :crazy:, I'll put the exclamation point on backups/restores.

To wit -------> !

I remember a couple decades back reading about MCSEs and so forth, how Microsoft billed them as a way for professionals with demonstrated experience to document that and were intended...