meta user
network profile
| bio | website | meltondba.wordpress.com |
|---|---|---|
| location | Montgomery, AL | |
| age | 34 | |
| visits | member for | 2 years, 4 months |
| seen | 53 mins ago | |
| stats | profile views | 170 |
|
1h |
comment |
When should tables NOT be compressed Had to research the same thing at a previous employer...came in very handy |
|
2h |
answered | When should tables NOT be compressed |
|
2h |
answered | Backup SQL Server To NAS |
|
1d |
comment |
SQLYzer experience Welcome to DBA.SE. Your question itself does not fall into the guidance of acceptable questions in the FAQ (dba.stackexchange.com/faq). I think you may find more information by just Boogling for "reviews Precise SQLYzer". |
|
May 20 |
awarded | Constituent |
|
May 20 |
comment |
Auditing specific database events Seems SQL 2012 limits Database level auditing to Enterprise only: msdn.microsoft.com/en-us/library/cc280386%28v=sql.110%29.aspx Going by the features supported page for SQL 2008 R2, SQL Server Audit is not even available in Standard: msdn.microsoft.com/en-us/library/cc645993%28v=sql.105%29.aspx |
|
May 17 |
comment |
Auditing specific database events The OP is wanting to capture DML activity. I read your answer to say this tool only captures DDL activity? |
|
May 15 |
answered | Auditing specific database events |
|
May 15 |
revised |
Auditing specific database events added version tag |
|
May 14 |
awarded | Caucus |
|
May 10 |
revised |
How to add additional tables/fields into a query with multiple inner joins? edited tags |
|
May 10 |
comment |
Use a condition to limit the databases a policy checks Guess that is what I get for not reading your blog more often :) Thanks. |
|
May 10 |
comment |
Use a condition to limit the databases a policy checks Sorry I would ask this in chat but can't seem to get logged in; but Free? You are not referring to Express Edition correct? Do you have a link for this announcement or download? |
|
May 10 |
answered | sysjobhistory “sql_severity” codes |
|
May 9 |
comment |
Can I recover CDC tables from transaction logs? The only way to get the data is going to be restoring the database, maybe to a second server, with the correct options so you can pull the data out. That way you at least have it for historical purposes. |
|
May 8 |
comment |
Can I recover CDC tables from transaction logs? Are you looking for the data CDC had captured or the settings (which tables, etc. you had CDC configured for)? |
|
May 2 |
comment |
Auto-generate scripts to create tables, indexes, etc I go for the simple route: petri.co.il/scripting-database-objects-in-powershell.htm |
|
Apr 29 |
comment |
Why does CREATE INDEX … WITH ONLINE=ON block access to the table over a period of minutes? Are you using a BEGIN TRANSACTION...COMMIT block on the command? According to this link that would cause a lock to be held until the end: msdn.microsoft.com/en-us/library/ms190981.aspx. |
|
Apr 28 |
awarded | Notable Question |
|
Apr 26 |
comment |
How can service pack rollback file end up on non-system volume? I found something similar to this applying SP2 for SQL 2008 R2 desktop tools on my laptop. I found the unpacking of the MSI was occurring on the USB drive I had plugged in and not a local drive. I could not figure out why it was choosing to use that drive. |
