Microsoft Upgrade Exams 11 March 2006 (0) I am taking one of the upgrade exams in a few days time and this study reference guide is a great help. http://blog.denoncourtassociates.com/CategoryView,category,Certifications.aspx SHARE:
Writing an xml file from sql server 2000 19 February 2006 (0) sp_makewebtask @outputfile = ‘c:\sqlserveroutput\myxmlfile.xml’, @query = ’select top 1 * from myTable for xml auto’, @templatefile = ‘c:\temp\mytemplate.tpl’ myTemplate.tpl = SHARE:
To XSLT a large file (.NET1.1) 19 February 2006 (0) To XSLT a large file use XPathDocument rather than XmlDocument, e.g. Slower: Me.m_oldStream.Position = 0Dim xsl As New Xml.Xsl.XslTransformxsl.Load(Me.m_xsltFilePath)Dim xDoc As New Xml.XmlDocumentxDoc.Load(Me.m_oldStream)xsl.Transform(xDoc, Nothing, Me.m_newStream, Nothing)Me.m_newStream.Flush() Faster: Me.m_oldStream.Position = 0Dim xslt As XslTransform = New XslTransformxslt.Load(Me.m_xsltFilePath)Dim doc As XPathDocument = New XPathDocument(Me.m_oldStream)xslt.Transform(doc, Nothing, Me.m_newStream, Nothing)Me.m_newStream.Flush() http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag/html/ScaleNetChapt09.asp claims 20-30% faster processing.In one extreme example of a project I have worked on, [...] SHARE:
Comparing SQL dates without the time part 13 November 2005 (0) SELECT CAST(FLOOR(CAST( AS float))AS datetime)e.g. to get all rows where an product as been ordered today:SELECT *FROM Orders AS aWHERECAST(FLOOR(CAST( a.OrderDateTime AS float)) AS datetime) = CAST(FLOOR(CAST( GETDATE() AS float)) AS datetime) SHARE:
Accessing web service from behind proxy 06 November 2005 (0) If you are going to (via a proxy server) connect to a web service on the Internet you may need to do the following (VB.NET): Dim s As Service1 s = New Service1 s.Credentials = System.Net.CredentialCache.DefaultCredentials s.Proxy = New System.Net.WebProxy(”internal proxy server address”, 80) s.Proxy.Credentials = System.Net.CredentialCache.DefaultCredentials SHARE:
Generating truly random numbers with multiple simultaneous request 04 November 2005 (0) The Random Class, given a constant seed will always generate the samesequence of numbers.Creating a Random object using the default constructor uses the current timeas the seed, so if you have multiple simultaneous requests and need to getdifferent numbers this approach will not work.A slightly cumbersome “fix” to generate a seed is shown below. Thisessential [...] SHARE:
The request failed with HTTP status 401: Unauthorized 01 September 2005 (0) If you are using IIS 6.0 and your application is using an Application Pool with an Identity set to a domain account you may get: The request failed with HTTP status 401: Unauthorized Check out this msdn article for a workaround. SHARE:
ASP.NET CustomValidator doesn’t fire ServerValidate event w hen input box is empty 01 September 2005 (0) ASP.NET valuator controls don’t validate empty input by default, this iswhat the RequiredFieldValidator is for… sometimes for customised inputvalidation you might not want this behaviour (e.g. if one of two input boxesmust be non-blank)… /// /// Overrides the default behaviour of CustomValidator to allow /// ServerValidate event to fire even if the input is blank./// public [...] SHARE:
Using network load balancing (NLB) with transactional MSMQ message 01 September 2005 (0) Want to send transactional messages using DIRECT format TCP to multiple server through a network load balancer? You can’t. Simple as that. See MSDN article ID 899611 Essentially you could have a single message delivered to more than one server which could be very bad news if they contain something like a “transfer money” message… From [...] SHARE:
location.replace doesn’t work when the following page is a PDF 25 August 2005 (0) Applies to:IE 6.0 (+others?), ASP.NET 1.1, JavaScript, PDF, Adobe Acrobat For some reason (at least in IE 6.0) if you use location.replace (to’disable’ back button by changing browser history) doesn’t work when thenext page is a dynamically displayed PDF, e.g. Response.ContentType=”application/pdf”;Response.BinaryWrite( (byte[]) Session[myPDF]);Response.Flush(); The history still displays the prior page in the history list. I’m not sure if [...] SHARE: