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...
February 25, 2013 11:44 PM
Posted by: Denny Cherry
SQL Saturday,
SQL Saturday 177,
SQL Server,
SQL Server 2008,
SQL Server 2008 R2,
SQL Server 2012This last weekend I had the privilege of speaking at SQL Saturday 177 in Mountain View, CA. One of the great things about this SQL Saturday is that in some ways it is an extension of the MVP Summit as for the second year in a row (that I know of) this SQL Saturday has been scheduled the weekend...
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...
December 12, 2012 2:00 PM
Posted by: Denny Cherry
Database,
Database Administration,
Microsoft Cluster Service,
Microsoft Windows,
MSCS,
SQL,
SQL Server,
SQL Server 2012,
StorageAs 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...
November 17, 2012 2:00 PM
Posted by: Denny Cherry
Backup & recovery,
BACKUP DATABASE,
CREATE TRIGGER,
Data Loss,
Database,
Database Administration,
DDL Trigger,
Recovery,
SQL Server,
SQL Server 2008 R2,
SQL Server 2012,
T/SQL,
Transactions,
Trigger,
xp_create_subdirOne of the companies which I work with has the occasion to create new databases when they do releases of their software. Normally this isn't a problem, except that they are setup to use maintenance plans to handle the backup and pruning of their transaction logs. As all the new databases are...
November 7, 2012 5:52 PM
Posted by: Denny Cherry
AlwaysOn,
Availability Groups,
SQL PASS,
SQL PASS 2012,
SQL Server,
SQL Server 2012Today was the 1st day of the SQL PASS Summit and the keynote was full of some great announcements and demos. The keynotes are a massive with almost all of the 3894 conference attendees from 57 different countries.
All of the keynotes from this years conference not only are the...
November 7, 2012 2:00 PM
Posted by: Denny Cherry
AlwaysOn,
Availability Groups,
Clustering,
Database,
Microsoft Cluster Service,
MSCS,
SQL Licensing,
SQL Server,
SQL Server 2012With the release of SQL Server 2012 and specifically the AlwaysOn feature we need to rethink the way that we handle the licensing for servers that will be passive servers. In the past it's been assumed that passive servers didn't need to be licensed, and that was true, for the most part. The...
October 16, 2012 5:56 PM
Posted by: Denny Cherry
AlwaysOn,
SQL PASS,
SQL PASS 2012,
SQL Server,
SQL Server 2012This year the PASS Summit has 14 fantastic PreCons which are available for attendees to sign up for at an additional cost of just
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
