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...

In addition to setting the max memory as Gail suggests, I'd want to see what your wait statistics are before and after you add this memory. Further, you want to...

Errors are likely to be in the error log, but there are a number of DMVs that are useful for observing behavior, especially retry rates, etc.

sys.dm_hadr_availability_replica_states

sys.dm_hadr_database_replica_states

sys.dm_tcp_listener_states

You can also gather information...