March 27, 2013 2:00 PM
Posted by: Denny Cherry
BIDS,
SQL,
SQL Server,
SQL Server 2005,
SQL Server 2008,
SQL Server 2008 R2,
SQL Server 2012,
SSISSo while working with a client recently I was going some performance tuning on SSIS for them. While SSIS isn't exactly my normal workload, the problem wasn't really in SSIS, but just normal SQL Statements being called from SSIS.
While attacking this problem, the first thing that I did was look...
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...
February 20, 2013 2:00 PM
Posted by: Denny Cherry
Reporting Services,
SQL Server,
SQL Server 2008 R2If 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...
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...
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...
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...
July 12, 2012 2:00 PM
Posted by: Denny Cherry
Replication,
SQL Server,
SQL Server 2008 R2,
SQL Server 2012,
System ObjectsOne of the things that Policy Based management is really good at is making sure that people don't create stored procedures that start with "sp_". However when the server that you are deploying the policies to is also being used for SQL Server replication this can get a little more complex seeing...
