Captain LoadTest: "Question number two asks the candidate to list the types of testing with which s/he has experience. This reply included integration testing (also stated in his resume, correctly spelled). My follow-up asked him to define integration testing; a common ploy to make sure I�m not just being fed buzz-words. It was a definition he could not supply, or even attempt.
A candidate should be able to define every �word� he claims experience with. If you can not define it you obviously do not have enough experience in it to make it applicable. If you can not define �integration testing�, I will not hold it against you providing you do not list experience in it. Similarly, if you do not list it, and I ask you what you know about it, be straight; tell me straight-up that you cannot define it. You will rate higher in my book than someone who stumbles through an obviously concocted and blatantly incorrect response."
Wednesday, September 14, 2005
Tom Hollander's blog : Instrumentation in Enterprise Library
a href="http://blogs.msdn.com/tomholl/archive/2005/02/18/376187.aspx">Turning off event logging & perf counters in App Blocks.<
Monday, September 12, 2005
Thursday, September 08, 2005
Friday, September 02, 2005
Monday, August 29, 2005
Friday, August 26, 2005
MSSQL Server Reporting Services : Black Belt Components: Manage Nulls in OLAP Reports
http://www.databasejournal.com/features/mssql/article.php/3436441
This article is a member of the series MSSQL Server 2000 Reporting Services. The series is designed to introduce MSSQL Server 2000 Reporting Services ("Reporting Services"), with the objective of presenting an overview of its features, together with many tips and techniques for real-world use. For more information on the series, as well as the hardware / software requirements to prepare for the exercises we will undertake, please see my initial Database Journal article, A New Paradigm for Enterprise Reporting.
Basic assumptions underlying the series are that...
This article is a member of the series MSSQL Server 2000 Reporting Services. The series is designed to introduce MSSQL Server 2000 Reporting Services ("Reporting Services"), with the objective of presenting an overview of its features, together with many tips and techniques for real-world use. For more information on the series, as well as the hardware / software requirements to prepare for the exercises we will undertake, please see my initial Database Journal article, A New Paradigm for Enterprise Reporting.
Basic assumptions underlying the series are that...
Thursday, August 18, 2005
Sample asp page for OLAP
<% set rsProject = nothing
set comPS = nothing
set prmPS = nothing
set conPS = nothing %>
Sunday, August 14, 2005
Friday, August 05, 2005
Thursday, August 04, 2005
Wednesday, July 20, 2005
Monday, July 18, 2005
Friday, July 15, 2005
ASP.NET: Remote Scripting,Yes. AJAX, "NOT"
ASP.NET: Remote Scripting,Yes. AJAX, "NOT" Zip code database & lookup with ajax.
Thursday, July 14, 2005
Wednesday, July 13, 2005
Tuesday, July 12, 2005
Monday, July 11, 2005
Tuesday, July 05, 2005
Web Q&A: ASP.NET Performance, Notification, Keeping Sort Order, and More -- MSDN Magazine, May 2005
Web Q&A: ASP.NET Performance, Notification, Keeping Sort Order, and More -- MSDN Magazine, May 2005
Great information about authentication for OLAP via web site, and other q/a items.
Great information about authentication for OLAP via web site, and other q/a items.
Thursday, June 30, 2005
Tuesday, June 28, 2005
Friday, June 24, 2005
script.aculo.us - web 2.0 javascript
script.aculo.us - web 2.0 javascript I'll have to try implementing some more of this stuff... drag & drop, Ajax, etc...
Saturday, June 18, 2005
Friday, June 17, 2005
Tuesday, April 26, 2005
Service Pack 2 is out
Service Pack 2 is out. Be sure to do the obscure 'backup your encryption keys' procedure, or else!
http://www.microsoft.com/downloads/details.aspx?FamilyId=502C0D89-1308-4662-8F58-CEC55EF1235B&displaylang=en
http://www.microsoft.com/downloads/details.aspx?FamilyId=502C0D89-1308-4662-8F58-CEC55EF1235B&displaylang=en
Tuesday, April 19, 2005
cool stuff - stored proc resultset queries
This command allows you to link to the local SQL Server & select individual columns from a stored procedure
sp_addlinkedserver @server = 'LOCALSERVER', @srvproduct = '', @provider = 'SQLOLEDB', @datasrc = @@servername
GO
select * from openquery(localserver,'exec mystoredproc')
GO
Great for comparing the results of 2 stored procedures, or doing union queries against multiple stored procedures without temp tables.
http://www.sommarskog.se/share_data.html
sp_addlinkedserver @server = 'LOCALSERVER', @srvproduct = '', @provider = 'SQLOLEDB', @datasrc = @@servername
GO
select * from openquery(localserver,'exec mystoredproc')
GO
Great for comparing the results of 2 stored procedures, or doing union queries against multiple stored procedures without temp tables.
http://www.sommarskog.se/share_data.html
Thursday, April 14, 2005
Tuesday, March 29, 2005
Reporting Services Scripter
This tool seems great for creating batch scripts against SQL RS.
http://www.sqldbatips.com/samples/code/RSScripter/readme.htm#_installing_rss
http://www.sqldbatips.com/samples/code/RSScripter/readme.htm#_installing_rss
Wednesday, March 09, 2005
Reporting Services companies
One of the things the company I work for specializes in is Reporting Services deployments.
Here's a list of some companies with add-ons for RS.
Cizer
Capricorn Software, LTD
Central Information Systems
Groeneveld Management Services BV
The Henson Group
JM Consulting
Microsoft
Northwest Training Systems, Inc.">
NxTrend
ReportsTrader.com
Tridec
ZAPTECH
Other
Here's a list of some companies with add-ons for RS.
Cizer
Capricorn Software, LTD
Central Information Systems
Groeneveld Management Services BV
The Henson Group
JM Consulting
Microsoft
Northwest Training Systems, Inc.">
NxTrend
ReportsTrader.com
Tridec
ZAPTECH
Other
Saturday, January 29, 2005
Wednesday, January 05, 2005
Changing the Process Buffer Size to Improve OLAP Cube Processing
http://solidqualitylearning.com/blogs/Dejan/archive/2004/10/15/194.aspxChanging the Process Buffer Size to Improve OLAP Cube Processing
Last few days I played with the Process Buffer size (in Analysis Manager, check the server properties, Processing Tab). This option, besides many other performance tips, is described in excellent article Microsoft SQL Server 2000 Analysis Services Performance Guide by Carl Rabeler, Len Wyatt and Dave Wickert. After few tests, I got the best performance when I changed the default value of 32 MB to 256 MB. I was really surprised by the processing time improvement. Amazingly, the processing time (full process) for a quite large cube went down from 3 hours 58 minutes to 1 hour 14 minutes! Really amazing – processing is now more than three times faster by just adjusting a single option. After this experience, I would suggest to everyone who is using OLAP cubes in production to start testing the process buffer size, especially if you are close to the limit of the time window available for processing. The best actual size might vary depending on your HW and cubes, but you sure want to increase the default value.
Last few days I played with the Process Buffer size (in Analysis Manager, check the server properties, Processing Tab). This option, besides many other performance tips, is described in excellent article Microsoft SQL Server 2000 Analysis Services Performance Guide by Carl Rabeler, Len Wyatt and Dave Wickert. After few tests, I got the best performance when I changed the default value of 32 MB to 256 MB. I was really surprised by the processing time improvement. Amazingly, the processing time (full process) for a quite large cube went down from 3 hours 58 minutes to 1 hour 14 minutes! Really amazing – processing is now more than three times faster by just adjusting a single option. After this experience, I would suggest to everyone who is using OLAP cubes in production to start testing the process buffer size, especially if you are close to the limit of the time window available for processing. The best actual size might vary depending on your HW and cubes, but you sure want to increase the default value.
Monday, January 03, 2005
Profiling .NET Apps
http://dotnetjunkies.com/WebLog/darrell.norton/archive/2004/12/22/38226.aspx
Interesting .net profiler for performance tuning.
Interesting .net profiler for performance tuning.
Subscribe to:
Posts (Atom)
