How can you get the PageData object for a page when the current user doesn't have access. It took me a while to find out, but you can just read on...
Having added Flash content support to a website, I was getting this message in Internet Explorer 6. Internet Explorer 7 and FireFox both worked without any problems. I knew about the issue of Active Content and Internet Explorer 7, but I didn't know what was causing this problem in IE6. Read more...
I have configured a number of different Linux distributions on Virtual Server 2005, but SUSE Linux 10.3 was a non-starter...
When you are using the (very helpful) UpdatePanel, the browser doesn't keep track of the asynchronous postbacks. This means that when the user clicks the back button in the browser, they go to the navigation prior to the last full postback.
How can you resolve this?
On a Page Type, you can create a property for a web link to a page. This page might be part of the CMS, or it might be on a different site. How can you find out how to render it?
Another example of using the API to help with development. This time reordering many properties quickly.
The EPiServer administration tools are pretty good, but every now and then I find that I want a bit more functionality. In this case, I wanted to duplicate new properties across multiple page types, create new properties based on a template and also change existing properties to have unique values for each language. This would have been tedious by hand, but the EPiServer API has everything I needed.
This should be easy, but easy it is not. I'm using an EPiServer 4.6 site for this one, so things might've improved in more recent versions, but this caused me a lot of trial and error. I hope this post saves you the hassle...
Using EPiServer, you may use the FindPagesWithCriteria method to retrieve a list of pages based on certain properties, but the helpfully enumerated conditions may be confusing. After all, with a binary inequality operator it is quite important to know the order of the expressions...
I've been importing a live EPiServer site into a development environment for further work. Normally, this works without problem, but this time I've been getting a POST error, but nothing informative. What's happening?
Have you ever wondered how to view object permissions using a query? Read more...
Do you have problems searching for text in files using Windows XP, Windows Server 2003, Windows Vista or Windows Server 2008? This problem has been affecting us in our development environment, but how can you fix it?
Do you have lots of tables that reference each other using ID fields? Are they of different types, such as nvarchar(10) and int? Do you sometimes find that it can be hard to remember how many characters should be in the type? And what about when you decide that you need a bigger type, such as nvarchar(30)? How can you ensure that your database design remains consistent?
I'm in the process of reviewing a large number of SQL stored procedures, and occasionally I find that a table join isn't properly expressed. This can result in hard to find bugs, but how can you make your SQL code simpler? Isn't using a stored procedure best-practice anyway?
I've just found this by chance while in the process of reviewing around 100 stored procedures to check for performance efficiency. It doesn't help with badly written queries, but if the query is reasonable then it can help you find those elusive missing indices. Thought I'd have to find them myself, but thankfully help is at hand...
You may know that it is best practice to create FOREIGN KEY constraints on related tables in a database. Why is this?
Read more here...
I came across this problem when trying to help someone with multithreaded P/Invoke calls to an unmanaged DLL. This DLL had previously worked with unmanaged (Win32) applications.
Note that this post does not apply to consuming COM objects.
Read more here...
Following on from my previous post, here's a quick way to find out which data tables are using the most disk space...
I'm in the process of reviewing a database for performance analysis. One of the most important tasks to perform is reviewing of statistics. Because this database is currently live, I cannot get the locks to use the sys.dm_db_index_physical_stats built-in function. I have an Oracle background and didn't know how to get the row count quickly. Here's my solution...
Sometimes you have to manually refresh folders in Windows XP to see changes that have taken place on network servers.
Read more here...
Sometimes, old code doesn't seem to work with the new Data Execution Prevention feature in Microsoft Windows. It's easy to turn it off for non-system applications and services, but how do you do it for system components, and why would you? Read more here...
Excerpt
The above error was occurring on both staging and live environments for a Microsoft Commerce Server 2002 system. It took us a while to track down the cause, but eventually I fixed it.
References
Versions
Metadata
How can you make your Commerce Server reports easy to maintain, and how can you make it work with long SQL queries? Did you even know that long SQL queries won't always work?! Read more here...
The time service is a critical part of any Windows Active Directory infrastructure. Why? Because it is part of how Active Directory replicates correctly, because it supports the implementation of Kerberos and because all your networked computers will be synchronised using it, even if you don't configure it.
Quite often, a seemingly unrelated error message will be caused by time service configuration errors. Read more here...
What is a malicious trigger? What can it do? How can you protect yourself and your database server? Read more here...
Sometimes you need to use a temporary table within a SQL Server stored procedure. How can you make sure that this will work? Read more here...