Sorry. I don't have something like that at my finger tips. I generally keep everything in source control and do all deployments from there. If you do a search online...

The fact that the current design consists of a giant table doing nothing but inserts and another giant table where you have to do twenty writes to concerns me quite...

Not really.

I'm confused by "different environments" though. Are we talking about Development, Testing and Production as "different environments"? Or are we saying, I've got one database on five different...

Sorry to hear what's going on. It sounds really tough.

Personally, I'd first try making changes to my current position. Explain to them where things are off the tracks and why....

In addition to what Gail talks about, another thing to consider is a layered approach. Depending on just how responsive and thorough you want your DR process to be, it...

GilaMonster (10/21/2015)

Grant Fritchey (10/21/2015)

There are sessions that we get to attend?...

If I had to deal with something like this, I'd go to extended events. You can capture events like object_altered, object_created and object_deleted to see what was done within the...

There are sessions that we get to attend? Huh. News to...

Assuming I'm reading this correctly, we can see the Student to Subject Relationship through the Semester to Subject table? I find that a little confusing. The Student isn't related to...

Typing this on a train. Apologies for curtness and typos.

You can't say for certain how many 9s you're satisfying until after the fact. but, the way you target a set...

Stuck next to Steve on a train across the uk. He's a seat hog.

Brandie Tarvin (10/13/2015)

Now she's hissing at me because I made the mistake of trying to move my other hand to the keyboard....

I would suggest that you do NOT reboot SQL Server.

First, take the database to EMERGENCY mode using ALTER DATABASE

ALTER DATABASE dbname SET EMERGENCY;

then, immediately take a COPY_ONLY backup and store...

To my knowledge SQL Audit will capture ad hoc queries, parameterized queries and stored procedures. It just doesn't keep the values that are passed to parameters. This is the same...

The optimizer won't always be able to spot that the indexed view provides all the columns needed for your data. This is especially true if the queries involved are beyond...