SQL Server with Mr. Denny:

December, 2012

1

December 28, 2012  7:00 PM

Recommended reading from mrdenny for December 28, 2012



Posted by: Denny Cherry
SQL Server, Top 10

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.

Bookmark and Share     0 Comments     RSS Feed     Email a friend

December 26, 2012  2:00 PM

Cross Database Chaining



Posted by: Denny Cherry
Data Security, Database, Database security, Security, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012

Cross database chaining in SQL Server is actually a fairly old feature, first introduced in SQL Server 2000 SP3.  However this feature isn't often understood mostly because it isn't often used. Database chaining is when permissions cascade from one object to another because they are used by the...


December 19, 2012  2:00 PM

Moving a Sharepoint Site Between Farms With Different Templates



Posted by: Denny Cherry
Backup & recovery, BACKUP DATABASE, Database, PowerShell, SharePoint, SharePoint 2012, SQL Server

A client came to be with a pretty scary problem.  Their SharePoint site was totally down.  The databases were there but the actual SharePoint farm was totally dead.  All of the SharePoint tools said that the farm wasn't configured yet so there were some pretty big problems.  Thankfully they had...


December 12, 2012  2:00 PM

The Least Expensive SQL Server 2012 High Availability Solution



Posted by: Denny Cherry
Database, Database Administration, Microsoft Cluster Service, Microsoft Windows, MSCS, SQL, SQL Server, SQL Server 2012, Storage

As we all know by now AlwaysOn Availability Groups are an enterprise edition feature and SQL Server Clustering is a standard edition feature.  Butt what happens when you have a small business that is running its apps on SQL Server Express.  Can't SQL Express have any sort of high...


December 6, 2012  12:42 PM

SQL Saturday 194 (#sqlsat194) Here I Come



Posted by: Denny Cherry
Data Encryption, Database security, Encryption, Security, SQL PASS, SQL Saturday, SQL Saturday 194, SQL Server

I'm so happy to be able to announce that I'll be giving a precon at SQL Saturday 194 over in England on Friday March 8th, 2013.  This precon will be will be on SQL Server...


December 5, 2012  2:00 PM

Databases With Large Tables Should Use Auto Stats Async Update Feature



Posted by: Denny Cherry
Auto Update Statistics Asynchronously, Auto Update Stats, Database, Database Administration, SQL, SQL Server, Statistics, Tables

A pretty cool feature that was introduced in SQL Server 2008 R2 SP1 is the ability to change the auto stats algorithm from the default of 20%+500 rows to a sliding scale. ...


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: