Since Mr. Moden posted his note, I added this issue to our weekly meeting this week. We have warned Mr Celko a few times in the last few months. Quite...

Brandie Tarvin (7/25/2012)

---

And most people get "fair use" wrong, too. Fair Use doctrine refers to an educational institution's ability to cite and copy other people's work. It has nothing to...

calvo (7/25/2012)

---

Wow. If Lester hit that many Yankees in a game, there'd be a brawl or finger pointing or ejections or some type of drama. Too bad for A-Rod. For...

Scott D. Jacobson (7/25/2012)

---

Amen Steve. Well put. I need some inspiration morning. When I get home tonight, I'm going to spend at least an hour sending out...

😛

If you've never run a log backup on model, then you will have active log transactions you cannot shrink. truncate only is for data files and it only removes free...

I wonder if NYY didn't want to shake things up too much or offend the SEA fans by making it seem like they got the best part of a deal....

What is in the maintenance plan? Is there a T-SQL script that is there to restore something? There are no tasks in maintenance plans to do restores, as Gail mentioned.

If...

Chris.C-977504

---

I'd still worry about my barganing position with a cloud server (none) and what a transition to another cloud offering would look like.

Also the cost is ongoing - you can...

SQLRNNR (7/23/2012)

---

I would run it up the chain as a security hole. Explain the problems and then work to remove all users that are not DBA from the sysadmin...

It looks like you're connecting on named pipes. Usually that isn't enabled. Use TCPIP

On the list. It's a surprising amount of development work, so it hasn't been a priority. I have been thinking of these options:

- immediate

- never

- every hour

- every day

For the...

A couple things:

First, you might want to use .data, and not .query (that returns XML).

Second, XML is case sensitive, so "posttime" will not work. "PostTime" is needed.

Not entirely sure where...

Is Server C a SQL Server? If so, use a maintenance plan to delete old backup files. Very simple.

If not, then you can search on this site for "delete old...

Brandie Tarvin (7/23/2012)

---

Hey, guys. I am getting absolutely no response on the fundraising for the wildfire & flood victims. Any suggestions on how I can sweeten the pot to get...