Cleaning Up Reporting Services Snapshots
If you’ve been running a SQL Server Reporting Services machine for a long time you may have noticed that your ReportServerTempDB database has filled up quite large over the years with lots of crap. And it’s just kept going. This is because sometimes SQL Server Reporting Services may be keeping more Snapshot data than it […]
Recommended reading from mrdenny for February 15, 2013
This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week. Disabling Visual Studio 2012's All-Caps Feature Suggestion: ALLFILES option for RESTORE Getting Started with Partially Contained Databases Ask Slashdot: Is TSA's PreCheck System Easy To Game? Using PerformancePoint against tabular data This […]
SQL Saturday Albuquerque Slide Deck
This last weekend was SQL Saturday Albuquerque (#183) and I had the privilege of speaking at their first SQL Saturday. I had a great time at the event, and kudos to the event team for putting together a fantastic SQL Saturday. The session which I presented at SQL Saturday was titled “SQL Server Indexing for […]
Recommended reading from mrdenny for February 08, 2013
This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week. Does a Clustered Index really physically store the rows in key order? Your online security is only as good as the weakest link Less Useful Soft Skills Declarative Architectures in Infrastructure as […]