Reputation
8,022
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
2 17 51
Impact
~449k people reached

2d
comment SSIS or msSQL way of sectioning a flat file
Can you provide a sample data, the definition of the tables you are going to use?
May
22
comment Which method is better to drop all user connections before a restore Change to single user mode or Take offline the database?
No they would need to get involved, but if you are restoring the applications database why wouldn't they be? Regarding blocking access to the instance you would end up blocking all access with most methods so if it is shared instance it would not be an option. However, most methods are to block the port from incoming traffic, or simply disable the protocols for the instance. This is why I tend to just opt to have the application folks shut their stuff off.
May
22
comment sharepoint DBA.
You are not allowed to make any modification to any database involved in SharePoint or other Office Server products: support.microsoft.com/en-us/kb/841057
May
21
revised Which method is better to drop all user connections before a restore Change to single user mode or Take offline the database?
added 244 characters in body
May
21
answered Which method is better to drop all user connections before a restore Change to single user mode or Take offline the database?
May
20
comment Moving TDE database to a new database but having problems with the cert
Might check this post from Steve Jones: voiceofthedba.wordpress.com/2013/08/19/… it appears it is the private key that he adds to his create cert statement.
May
19
comment backup to NAS using sqlcmd
Then have you tried just creating a Proxy account?
May
19
answered backup to NAS using sqlcmd
May
14
awarded  Notable Question
May
14
awarded  Revival
May
5
comment How do I reduce SharePoint 2010 SQL server log files?
Please read through this question and answers: dba.stackexchange.com/q/29829/507
May
5
revised How do I reduce SharePoint 2010 SQL server log files?
added 5 characters in body
May
1
comment View locks acquired during query execution (SQL Server)
What version of SQL Server?
Apr
29
answered I need the reason why we should not install SQL server on the domain controller
Apr
29
revised I need the reason why we should not install SQL server on the domain controller
format
Apr
27
comment Is Service Pack 2 completely installed on Passive Node of SQL Server 2012 Instance?
To make the answer a bit more complete can you put in how you determined it was the 3rd party product?
Apr
27
revised how can i connect from yahoo small business webhosting domain to remote mysql server
format
Apr
27
comment What happens with statistics when reverting to a database snapshot
As stated in BOL: any updates to the database since the snapshot's creation are lost. msdn.microsoft.com/en-us/library/ms179557(v=sql.100).aspx
Apr
26
comment The SQL Server Network Interface library could not deregister the Service Principal Name
One does not have anything to do with the other. The error regarding SPN has nothing to do with the service not starting. Error 1067 just means the service did not start, it is not sufficient information to determine why.
Apr
25
comment Is Service Pack 2 completely installed on Passive Node of SQL Server 2012 Instance?
Have you looked at the installation log to see what it says?