Reputation
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
7 34 71
Impact
~522k people reached

Aug
29
answered Allocation strategy where tables regularly grow and shrink by large amounts
Aug
27
comment How to backup the current code of a stored procedure and its permissions as well?
See my answer here for a way to automatically capture all changes my to the structure of your database dba.stackexchange.com/a/25052/10832
Aug
27
comment SQL server on VMWare restart loses five days of data
One other thing... Always ensure you have a tested backup strategy in place. Test backups by restoring them to another instance. Until you do that, you should have no trust in the system.
Aug
27
comment SQL server on VMWare restart loses five days of data
Perhaps the VM had a snapshot in place that was reverted automatically when the VM was restarted. SQL Server did ensure data was written to disk, what happened to that data at the VM level is anyone's guess.
Aug
25
awarded  Nice Question
Aug
24
reviewed Close Several Data Importation Illogical Latency in MySQL
Aug
24
reviewed Close create a trigger to alter table add column based on inserted row
Aug
23
comment Which to store: miles or kilometers?
I don't agree, obviously. Storing the UoM makes sense for a ton of real-world scenarios, and no matter how the OP decides to store the measurements, it will necessitate some kind of conversion.
Aug
21
reviewed Close Which to store: miles or kilometers?
Aug
21
answered Which to store: miles or kilometers?
Aug
21
reviewed No Action Needed How to make sqlcmd return an ERRORLEVEL other than 0 when the .sql script fails?
Aug
21
reviewed Looks OK How to convert a MySQL database from utf8mb4 to utf8?
Aug
20
reviewed Reviewed Expdp error UDE-22303
Aug
20
revised Expdp error UDE-22303
improved formatting
Aug
18
reviewed No Action Needed Converting a VARCHAR to VARBINARY
Aug
18
comment Speed of Split Database vs ODBC with SQL Server vs ODBC with Azure Cloud
Is your backend database on the same machine as the front-end?
Aug
18
reviewed Close How to increment field value count using MySQL
Aug
18
reviewed Close MySQL slave server getting stopped after each replication request from Master
Aug
18
reviewed Close Detect if two time periods overlap
Aug
18
reviewed Close Connecting to SQL Server using PHP, ODBC, and Windows authentication