Below are the environments we use for the last 2 GA releases plus the version under development of our software product. The Test, Performance, and QA environments for the...

It's amazing what one can do with SQL Server on bare-metal commodity hardware with a well architected system and attention to detail. I've been a staunch advocate of the...

The QA databases as well as databases used for automated unit and performance testing are upgraded nightly with the latest check-in...

Yes, I sometimes rename objects and columns. Our development process is Agile with Continuous Integration. Database changes checked into source control are deployed to QA every night. ...

IMHO, Express Edition is fine for a production environment as long as meets performance and availability SLAs. 4 cores is more than enough for many workloads. The 10GB...

For starters, check the execution log in the MDW database for the problem collection set to see if any issues are logged:

SELECT *

FROM syscollector_execution_log

WHERE collection_set_id = <specify-collection_set_id-here>

ORDER BY finish_time;

You...

File tables don't allow local memory-mapped file access, which may explain the "request is not supported" error with BULK INSERT. I would expect a technique that performs the bulk...

How much did the choppy video and connection errors really cost Apple in terms of lost revenue or reputation? Testing their CDN performance using a world-wide bot network...

Directory permissions are not inherited for SQL trace files. SQL Server sets permissions such that only the service account, local administrators, and the owner can access the file because...

Any thoughts to using PowerShell instead of VBScript?

The trace scripts included in this Stairway are compatible with SQL Server 2005 through 2012. However, note that the GroupID event column (returned as the last column by fn_trace_gettable)...

majinbao (11/7/2013)

---

Thank you very much for the post. great articles.

the only information I can get is object:alert, but it doesn't tell me the TextData is null. I can not tell...

I've become a fan of agile (sic lower-case) development methodologies for this exact reason. It is up to the team to decide how good is good enough by balancing...

A properly filtered Profiler trace...

Indianrock (7/24/2013)

---

I'd like to hear some feedback on how to handle it when you trace your production box, say main database is called Production, then try to replay those trace...