121 reputation
2
bio website
location Arkansas
age 33
visits member for 3 years
seen Nov 26 '13 at 19:49

Database Administrator


Dec
3
answered Adding anonymous IURS IIS user fails into SQL SERVER 2008 R2
Nov
14
comment Is there a negative impact to using SQL Server with a lower compatibility level
+1 Justin Also don't forget that when running in compatibility mode 2000 (80), you'll have to use a slight hack to get some dmvs to work properly: sqlskills.com/blogs/paul/post/…
Oct
12
comment Differential backup of new sql database fails until full backup is made
@BenThul Diffs can be taken regardless of the recovery model. If there are bulk loads in the environment and the recovery model is not full, Diffs could offer a significant advantage over the full recovery/tran log backup scenario. Additionally, recovery is much simpler with diffs. All you need to restore is the last full and the last diff. Much simpler than trying to recover with a full and 40 tran backups. On a tier 2 or 3 database, the cost of point in time recovery may outweigh the benefits.
May
8
awarded  Supporter
Dec
14
awarded  Teacher
Dec
14
answered SQL Server cannot connect after reboot and locked
Jun
21
comment SQL 2008 and SQL 2008 R2 Server hangs on 'Welcome' screen while connecting using RDP
Was this ever resolved? We're having the same issue.