629 reputation
36
bio website patrickkeisler.com
location Charlotte, NC
age 40
visits member for 2 years, 2 months
seen Oct 9 at 10:56

I'm a husband, a father, an Atlanta Braves fan, and oh yeah...I'm also a Microsoft SQL Server database administrator for a major investment bank, Wells Fargo Securities. I have over 13 years of DBA experience and have gained considerable knowledge in SQL Server by supporting hundreds of applications ranging from high-volume trading applications to massive data warehouses. I currently hold an MCITP certification with aspirations of becoming a certified master in SQL Server.


Oct
2
awarded  Yearling
Jul
8
awarded  Critic
Jul
8
awarded  Commentator
Jul
6
comment Problems during installation with Database Engine Service
Yes SQL Server 2014 can be installed on Windows 7 Home Premium. msdn.microsoft.com/en-us/library/ms143506.aspx. Can you also post the Errorlog?
May
13
comment TSQL command to delete backup files older than N hours
If you want to do this through T-SQL, the xp_delete_file is your best option. As @JamesAnderson says, it's undocumented, but I have not seen any issues with it since the early releases of SQL Server 2005. Review my article if you would like to see the details. patrickkeisler.com/2012/11/…
Oct
3
answered Single disk for Data, System, User, Temp and Backup when installing Fail Over Cluster?
Oct
2
awarded  Yearling
Oct
1
answered Is MSDTC required for SQL Server 2012 Fail Over Cluster?
Sep
25
comment SQL Server backup fails on disk space error
How large is an uncompressed backup for the database?
Apr
2
comment IO Frozen in error SQL error log
Can you please post the exact errors from the errorlog?
Mar
26
awarded  Autobiographer
Mar
20
comment Optimal drive configuration for SQL Server 2008R2
Remember SQL Server needs to physically write all transactions to the log as part of the commit, so you want the fastest write performance possible within your config. RAID 10 offers better write performance than RAID 1, so I would leave the logs on the faster volume.
Mar
20
comment Optimal drive configuration for SQL Server 2008R2
Tempdb is used for many things, but don't treat it as a throwaway database and place it on a RAID 0. Keep in mind if that RAID 0 volume fails, SQL Server will not be able to start up.
Mar
20
answered Optimal drive configuration for SQL Server 2008R2
Mar
17
answered How to restore a filegroup from its backup in SQL Server
Feb
12
answered Can we minimise the risk of using xp_cmdshell?
Nov
13
awarded  Supporter
Nov
10
answered Implications of Changing to a Static Port
Nov
2
answered SQL Server 2008 upgrade advisor tool
Oct
29
answered Select from linked server to local server causing waits on both sides