James

Age: 36

DBA/developer. Mostly SQL Server. Ex-sysadmin.

Apr
6
awarded Popular Question
Mar
27
comment Permissions for executing subscription in SSRS
I've considered it but am not sure how practical it is. They'd need to write a query that checks whether the ETL is completed, but guarantee that the subscription only fires once per day right after the ETL completes.
Mar
27
revised Permissions for executing subscription in SSRS
added 122 characters in body
Mar
27
asked Permissions for executing subscription in SSRS
Mar
22
comment ggplot graphing of proportions of observations within categories
Thanks, this is a very good but also very simple answer that should help a lot of people who are confusing themselves and overcomplicating things (like me just now).
Mar
18
comment How to interpret values of Perfmon counter Hyper-V Hypervisor Virtual processor\CPU Wait time per dispatch
Thanks David. I was thinking I could do something like this but got thrown off by the 'per dispatch' part. Does this imply I need to know how many dispatches there are before I can convert this to a percentage of time?
Mar
17
comment any advantage or disadvantage to have mysql 5.6 on a linux server over on a window server
The innodb_flush_method documentation doesn't explain, but I'd guess async_unbuffered means InnoDB on Windows is opening the files with the flags FILE_FLAG_NO_BUFFERING (for unbuffered) and FILE_FLAG_OVERLAPPED (for async I/O). That is how Windows-oriented RDBMSs do I/O and should avoid any double-buffering of the I/Os in Windows. Personally I'd avoid MySQL on Windows because it's developed, tested, and run largely on UNIX & Linux and MySQL experts are in the UNIX/Linux space. So I agree that you should definitely NOT USE WINDOWS for MySQL, though I'm not sure if your reasons are correct.
Mar
17
revised How to interpret values of Perfmon counter Hyper-V Hypervisor Virtual processor\CPU Wait time per dispatch
Removed sentence with bad reasoning
Mar
17
asked How to interpret values of Perfmon counter Hyper-V Hypervisor Virtual processor\CPU Wait time per dispatch
Mar
15
awarded Supporter
Mar
6
revised Is sys.stats_columns incorrect?
added 1 character in body
Mar
6
revised Is sys.stats_columns incorrect?
added 1 character in body
Mar
5
comment Is sys.stats_columns incorrect?
@MaxVernon, swashesk has filed one here
Mar
5
revised Is sys.stats_columns incorrect?
added 418 characters in body
Mar
5
revised Is sys.stats_columns incorrect?
added 1475 characters in body
Mar
5
asked Is sys.stats_columns incorrect?
Mar
3
comment Using SSIS to move a SQL Server table to a specific MySQL folder
Is it possible that you have multiple MySQL installs running and SSIS is connecting to the wrong one?
Mar
3
awarded Yearling
Mar
3
awarded Yearling
Feb
27
revised How to debug why WAN TCP/IP throughput is lower than expected?
deleted 5 characters in body
1 2 3 4 5