381 reputation
210
bio website
location New York, United States
age
visits member for 2 years, 3 months
seen 7 hours ago

SQL Server DBA


Sep
24
asked Max Memory settings on Multi-Instance SQL Server 2008 R2 Cluster
Sep
20
awarded  Popular Question
Aug
24
awarded  Popular Question
Jul
3
awarded  Yearling
Jun
24
accepted Databases outside of AlwaysOn availability group stuck in RESTORING status
Jun
20
answered Databases outside of AlwaysOn availability group stuck in RESTORING status
Jun
19
comment Databases outside of AlwaysOn availability group stuck in RESTORING status
I have not attempted any backup/restore via T-SQL. I have been using the Availability Group Wizard only, and only select a handful of databases out of 30+. When the wizard is complete, the databases I did not select show "Restoring", and the databases I did select show "Synchronized" as expected.
Jun
19
asked Databases outside of AlwaysOn availability group stuck in RESTORING status
Jun
19
comment Can Availability Groups replace transactional replication?
Just thought I'd point out that Windows Server 2012 does not require Enterprise edition for Failover Clustering. This is now available in Standard.
May
9
comment What is the safest way to run SSIS on Multiple Named SQL Server Instances?
That's great article! Thanks for the link.
May
9
asked What is the safest way to run SSIS on Multiple Named SQL Server Instances?
May
7
awarded  Commentator
May
7
comment attach/detach v.s. backup/restore
When attaching/detaching, it's never a good idea to MOVE the files. You should always be COPYING them. I never trust Windows to move important files.
May
6
awarded  Teacher
Apr
2
comment Process attempted to unlock a resource it does not own
I will try to do some monitoring next time that package runs. In the mean time, should I be concerned that there is any corruption or problems in the database?
Apr
2
comment Process attempted to unlock a resource it does not own
The Windows logs have nothing else at that time. There was an SSIS package running at the time which finished after the error message with a SUCCESS. I'd have to do a lot of digging and work with developers to try to replicate this somewhere else, but I can do it if needed. I did see that connect item, but we're at SP4 already, so I don't think that will help.
Apr
2
asked Process attempted to unlock a resource it does not own
Mar
25
awarded  Nice Question
Mar
15
comment Efficency of stored procedures vs raw queries
There's a great related article here, including scripts to delete those single-use plans. sqlskills.com/blogs/kimberly/…
Mar
13
comment How do I get more details on a full text catalog error?
No luck with integrity checks, and no luck with the troubleshooting section unfortunately.