ben.brugman (6/4/2012)

---

Grant Fritchey (6/4/2012)

---

When all you have available is the full backup, that's all you're going to get. If you have log backups available, you can restore right to the...

First, please don't edit the question to change it as it then wrecks the flow of the discussion. If you have a follow up, ask it. If you have a...

To build on Grant's note.

The RDBMS always does a recovery when you restore. This means that all commits in the log are verified as being in the data files as...

So very true.

Any of our data, even things we might not expect (like images/recording of our person, or...

Grant has good ideas.

By default you don't get access to any tables or objects in a database without being granted them. So only grant what you want users to have.

Use...

No, we are in the UK

Finally got ahold of one yesterday. Nice, just above the knees, a little inside, and I bounced it off the 360' fence for a double.

Feels like baseball season.

It's amazing how many "relations" you can make between the sci-fi movies and work. Often not as the original writers intended.

Take lots of breaks.

Seriously, that's important. Get up, even for 5 minutes.

Do some stretches. Google for the various ones for your wrist. Adding some strength/muscle will help. You don't have...

I tend to agree with Grant, overall. Experience matters more.

If you want to learn more, as Gail mentioned, get the Masters. Otherwise, go to work.

Biased as well, but here's my take.

Summit - Excellent networking, SQL Server focused. Sessions are a little hit and miss since they are volunteers, and less experienced speakers. The choices...

An excellent response to Celko: http://www.sqlservercentral.com/Forums/FindPost1310443.aspx

You cannot do that. The point of a hash is a one way function applied to a password. It's possible there are multiple passwords that could hash to the same...

I would follow Gail's advice. Take log backups on the primary. Don't truncate the logs. Once you have those set up, if you need to shrink the logs, you can...

You probably want to group the data by date first, then the other columns, but are you showing all the data for a week?

If I have

Red, 4, 4/1/2012

Blue, 5, 4/2/2012

Blue,...