SQL Server with Mr. Denny:

Database


January 29, 2014  2:00 PM

Log Shipping Databases and Permissions Problems



Posted by: Denny Cherry
Attaching Database, Data Security, Database, Database Administration, Error 3013, Error 3119, Error 4319, Full Recovery Model, Log Shipping, Recovery Model, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014

Recently I was doing log shipping for a client in preparation to move their databases from one data center to another, when I was asked to change the drive that one of the target databases was being restored to. No problem, I'll just use ALTER DATABASE ... MODIFY FILE (name='xxx',...

January 15, 2014  2:00 PM

Fixing TempDB database problems when starting SQL using a minimum config



Posted by: Denny Cherry
Data Loss, Database, Database Administration, SQL, SQL Server, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, T/SQL, TempDB

So the other day I typo'ed something. Usually this isn't that big a deal, but in this case when fixing tempdb for a customer I told SQL to put two logical files into the same physical file. I was able to get it to let me do this because I first added the files, then realized that I had put them...


January 7, 2014  8:46 AM

SQL 2012 Cluster, Windows 2012 R2 OS, Windows 2008 R2 Domains



Posted by: Denny Cherry
Allan Hirt, AlwaysOn, Clustering, Database, Database Administration, DataCenter, Error 1069, Error 1194, High Availability, Microsoft Cluster Service, Microsoft Windows, MSCS, SQL Server, SQL Server 2012, SQL Server 2014, Windows 2008 R2, Windows 2012 R2

Recently I was installing SQL Server 2012 on a new Windows 2012 R2 cluster for a client and ran across a bit of a problem. When the SQL Installer was attempting to start SQL Server for the first time SQL Server was throwing Windows errors 1069 and 1194 which basically say...

Cluster...


December 18, 2013  2:00 PM

Encryption and Compression



Posted by: Denny Cherry
Backup & recovery, BACKUP DATABASE, Data Loss, Data Security, Database, Database Administration, Database security, Indexing, Security, SQL Server, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, Storage, Tables

We have a variety of options when it comes to compression and encryption in SQL Server. When using both compression and encryption you...


December 11, 2013  2:00 PM

Clustering in Amazon EC2 – Tomorrow!



Posted by: Denny Cherry
Clustering, Database, Database Administration, DataCenter, High Availability, Microsoft Cluster Service, Microsoft Windows, MSCS, Recovery, Server Hardware, SIOS Technologies, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014

Tomorrow (December 12th) at noon Pacific Time I'm presenting a session with SIOS Technologies on using their SANLess Clustering Technology to build a clustered SQL Server for High Availability within Amazon's EC2 cloud. This session is...


December 3, 2013  6:15 PM

Upcoming SQL Saturday Precon in Albuquerque



Posted by: Denny Cherry
Clustered Index, Database, Database Administration, Database Design, Execution Plans, Indexing, Nonclustered Index, Recovery Model, SQL PASS, SQL Saturday, SQL Saturday 271, SQL Server

I'm very pleased to announce that I will be presenting a precon at the Albuquerque SQL Saturday at SQL Saturday 271 on...


November 13, 2013  2:00 PM

Old Versions of SQL Server On New Hardware Can Be Interesting



Posted by: Denny Cherry
Database, Database Administration, DataCenter, Microsoft Windows, Server Hardware, SQL Licensing, SQL Server 2008, Windows 2008 R2

Recently a friend was working on one of his clients SQL Servers and he ran into an interesting problem. The hardware in question was a HP DL 580...


October 27, 2013  2:00 PM

If you could give an aspiring DBA just one piece of advice what would it be?



Posted by: Denny Cherry
Database, Database Administration, ITKE grandparent, SQL PASS, SQL Saturday, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014

Probably the best advise that I could someone entering the field of Database Administration would be to keep learning. If you think that you know...


October 16, 2013  2:00 PM

Replication and VLFs



Posted by: Denny Cherry
Database, Replication, SQL Server, SQL Server 2008 R2, Storage, System Objects, Transaction Log

Every once in a while you run across a problem that shouldn't be causing people as much problems as it is, yet there it is causing all sorts of problems for long...


August 27, 2013  6:46 PM

SQL Connections Post-Con Coming Next Month



Posted by: Denny Cherry
AlwaysOn, Availability Groups, Clustering, Database, Database Administration, Dev Connections, High Availability, Microsoft Cluster Service, MSCS, Server Hardware, SQL Server

That's right, next month I'm giving a post con at the SQL/Dev Connections conference.  The post con is titled


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: