Reputation
3,103
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
1 4 21
Impact
~262k people reached

1d
comment How can I determine which tables are causing the database to grow over time?
How far back do you have backups for? You can restore the older ones and look at the tables, record the info and compare that way after restoring each.
2d
revised Big Size Database and increasing number of users
added 427 characters in body
2d
comment Big Size Database and increasing number of users
Note there is a HUGE difference between "Database Snapshots" and "Snapshot Isolation". Snapshot Isolation works on a ROW level and is done to let you read the old value while the new one is being updated. "Database Snapshots" work by making a copy of the old data page when it changes and referencing that, and it will stay until you drop it. Note neither of these will help you if the issue is memory or disk IO.
2d
comment Big Size Database and increasing number of users
Snapshots work the other way. They are a static representation of the data at the time it was taken. Any new changes will require a new snapshot. Be careful having too many snapshots as they all need to be updated when data pages on the source database are updated.
May
27
answered Big Size Database and increasing number of users
May
20
comment Executing a script via Powershell possibility
SQLHound you can pass in a file with a different switch, I think you found it but it's -i "C:\MyFilePath\MyFile.whatever"
May
20
answered Executing a script via Powershell possibility
May
19
reviewed Reject Options for structuring multiple associations to a record
May
18
answered Database Engine vs. Database location
May
14
comment Is It Needed to Normalize of Date Columns
Anytime, let us know if you have any other questions. Have fun.
May
14
answered Is It Needed to Normalize of Date Columns
May
14
answered is it a good practice to ip block dev/test app servers from production database server?
May
13
answered dbcc shrinkfile not reducing size of log file in sql server 2008
May
12
comment secure way to connect with remote Mysql database
@Vérace just note that it's using filtering on DynamicDNS hostname and using a non default port. This would fit many compliance requirements if a DB engine has a valid reason for being publicly accessible; and not going through some web/abstraction layer which is always the best case. If the DB engine has to be publicly accessible, and it's not a heavily used machine, then a 'database firewall' will really give you the trifecta you need to be really tight.
May
11
comment secure way to connect with remote Mysql database
heya bud, check out: cyberciti.biz/faq/change-default-mysql-port-under-linuxunix That should do it for you. Any of the DynamicDNS providers will work for you, heck, you can even put it in your own local host file and reverse DNS. That should work but I never tested it.
May
11
comment Retrieve Column name as Data
Can you please edit the question and list a sample output you'd like?
May
11
answered Get MS SQL Server to release disk space
May
11
answered secure way to connect with remote Mysql database
May
11
comment Failed installation of SQL 2012 on Windows Server Core
well done. TY for posting the answer.
May
8
comment SQL Server 2012 Security Best Practices
1- I rejected your edited text as it was belligerent cursing at the community, and that is neither appropriate or professional. 2- Your question can be typed right into Google. I literally typed in sql 2012 security best practices, and the first link is great. It takes you right to Kin's comment. You can find that and others here: lmgtfy.com/?q=sql+2012+security+best+practices 3- If 3 senior members reject the question, please consider that perhaps you did something wrong instead of lashing out at the community.