March 13, 2013 2:00 PM
Posted by: Denny Cherry
Andre Kamman,
Database,
Database Administration,
DBCC PAGE,
Mladen Prajdić,
Paul Randal,
SQL Saturday,
SQL Saturday 194,
SQL Server,
SQL Server 2005,
SQL Server 2008,
SQL Server 2008 R2,
SQL Server 2012,
System Objects,
TablesWhile attending SQL Saturday 194 in Exeter over in England one of the attendees came to Mladen Prajdić, Andre Kamman and myself with an interesting problem. She had a database table which was about 200 Gigs in size which she wanted to...
December 26, 2012 2:00 PM
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 2012Cross 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...
August 9, 2012 2:00 PM
Posted by: Denny Cherry
AlwaysOn,
Availability Groups,
Azure,
Data Loss,
Data Security,
Database Administration,
Database security,
Microsoft Windows,
Security,
SQL,
SQL Server,
SQL Server 2000,
SQL Server 2005,
SQL Server 2008,
SQL Server 2008 R2,
SQL Server 2012,
StorageIn case you missed the blog post over on securingsqlserver.com, I wanted to repost it here...
I'm afraid that I've got some bad news. You can no longer pre-order
July 26, 2012 2:00 PM
Posted by: Denny Cherry
Data Encryption,
Data Loss,
Data Security,
Database,
Database Administration,
Database Design,
Database security,
Encryption,
Security,
SQL Injection,
SQL PASS,
SQL PASS 2012,
SQL Server,
SQL Server 2000,
SQL Server 2005,
SQL Server 2008,
SQL Server 2008 R2,
SQL Server 2012The SQL PASS session list for the SQL PASS 2012 Summit has been released. This year there are 192 sessions being presented at the SQL PASS summit. Last year at the 2011 summit there were only a couple of sessions...
April 12, 2012 2:00 PM
Posted by: Denny Cherry
Error Message,
Grant Fritchey,
Hyper-V,
SQL Server,
SQL Server 2000,
SQL Server 2005,
SQL Server 2008,
SQL Server 2008 R2If you have physical SQL Servers that you plan on moving into a virtual environment you'll want to double check your affinity mask settings before actually moving the machine from a physical server to a VM when using P2V software. The reason for this is that if the affinity mask is set for...
April 9, 2012 5:06 PM
Posted by: Denny Cherry
Error 29112,
MERGE statement,
Microsoft Operations Manager,
Microsoft System Center,
OperationsManager,
OperationsManagerDW,
SQL Server,
SQL Server 2005,
SQL Server 2008 R2,
System Center Management Configuration ServiceSomething which has come up when upgrading Microsoft Operations Manager 2007 to 2012 is that there is an extra step which isn't really documented in the Ops Manager upgrade guide. You see when upgrading from Ops Manager 2007 to 2012 you also need to upgrade the SQL Server to SQL Server 2008 R2 as...
March 1, 2012 2:00 PM
Posted by: Denny Cherry
Replication,
SQL Server,
SQL Server 2000,
SQL Server 2005,
SQL Server 2008,
SQL Server 2008 R2One of the great features with SQL Replication is the ability to initialize a subscription from backup instead of from a snapshot. The official use for this is to take a database backup and restore it to a subscriber then replicate any additional changes to the backup.
However this technique...
December 5, 2011 2:00 PM
Posted by: Denny Cherry
Federated Database,
SQL Server,
SQL Server 2005,
SQL Server 2008 R2Just because you did a schema design change before doesn't mean that you shouldn't look into doing another one. A while back, before I started working with Phreesia, they decided to fix some performance problems by federating some data. The data is question...
June 15, 2011 5:27 PM
Posted by: Denny Cherry
BI,
Encryption,
SQL PASS,
SQL PASS 2011,
SQL Server,
SQL Server 11,
SQL Server 2000,
SQL Server 2005,
SQL Server 2008,
SQL Server 2008 R2,
SQL Server 2012,
SSAS,
Stacia MisnerSo I've managed to trick the kind folks of the SQL PASS program committee once again this year. I've gotten two sessions accepted for the summit.
The first is a "regular session" which is the normal 75 minute community session during which I'll be presenting "Where should I be encrypting my...
