Reputation
3,192
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
1 4 22
Newest
 Organizer
Impact
~281k people reached

Jul
2
comment Is there a cool way of performing CU updates for SQL Server on hundreds of machines?
Shawn's method is certainly a cool method to do it. WSUS is a lot less cool, but more supported. Both are good solutions.
Jul
2
comment SQL Server - Failover Cluster add node later
Anytime! The link at the end of my comment will take you to the search results I found. The first 3 were on point and the rest looked accurate but I didn't go through them. Good luck.
Jul
1
comment SQL Server - Failover Cluster add node later
Please use a search engine of your choice or google and look for: single node cluster 2012 sql. On google this brought up several links showing exactly how to do it. Since these types of questions get stale quickly and are duplicates, we'll vote to close this question. Feel free to let us know if you have a specific question about it later on. bit.ly/1NxL96I
Jun
30
comment Old Data on SFTP
Great, if you would like though, you can get clarity on data retention as well, then reiterate the decisions in a meeting back to the business. This way you're covered if they need a old backup and it doesn't exist. For example they might ask for data from a month ago and if it isn't available they might all of a sudden forget the prior discussions.
Jun
30
awarded  Organizer
Jun
30
reviewed Approve MySQL Freezes System Preferences then crashes mac
Jun
30
reviewed Edit Syntax error when creating SCHEMABINDING view
Jun
30
revised Syntax error when creating SCHEMABINDING view
Tags and title edited.
Jun
29
comment Mirror db from production to test and acceptance nightly or weekly
you only want to restore the data and not schema? How about if you restore the entire database and just mask the sensitive data? Will that work for you?
Jun
29
answered Old Data on SFTP
Jun
29
answered How to become MySQL trainer?
Jun
29
comment Updating data from one database to another
Please share the full error message and someone can help you out pretty quick.
Jun
29
reviewed Approve What is the best option to easily fix fragmented heap indexes?
Jun
19
comment Moving TempDB data and log files
Anytime bud, let us know if you have any more questions later on. If you feel this answer fully answered your question, give it a check stating answer so other's can see it worked for you and I get magic points. :P
Jun
19
comment Moving TempDB data and log files
Negative, TempDB will only utilize what is in sp_helpdb. Now the mystery of the 2nd file. I suspect it's a orphaned file left over from a prior test or DB. Sometimes removing the DB from SQL Server doesn't remove the data files I've noticed. If you don't have other SQL instances running (get-service sql from powershell), you can try moving that file elsewhere then deleting it later.
Jun
19
answered Moving TempDB data and log files
Jun
19
answered Adding second SQL Server to create 2 Node cluster
Jun
16
comment Optimal SQL Server 2012 Disk Configuration
How much data throughput are you expecting/estimating?
Jun
15
comment SQL Server database backup and saving at the same time
Yes, sql server will backup the portion of the transaction log required for recovery even if in SIMPLE mode. At this point when you restore it will have all the most recent data as the transaction log will hold it; and data must be hardened to the log first before updating in memory.
Jun
11
comment Does SA account need to be called “SA” or can I rename it safely?
Check to see if any jobs or DB's are owned by it too.