This post could become a living being all by itself…. SQL Server has seemingly endless possibilities.
I had a need to determine the size of all the tables in a certain database, and this post floated to the top.
Archive for Web and Database Development – Page 2
I feel this is a topic to watch – that of web tracking opt-in / opt-out. Many in the web industry are watching this closely. Optincookie.com is one site which will help you keep apprised of developments and how they can affect the web analytics community.
Don’t let the fact that this link will take you to a page written in Brazilian Portuguese (my second language) hold you back: all the links are to content written in English. The IdealMind blog contains many valuable tips and discussions about web development, web analytics and more. But this list of conversion rate tips all in one place is a great find. What’s more, there’s a link to the post which originally inspired IdealMind’s author: a link to more than 600 (at the present time) links to help you improve your site’s conversion rate. Enjoy!
Google Insights for Search is quite an interesting tool. Even though its been around since 2008, it is still in beta as is most of Google. There is a lot of intelligence that can be gathered by using this tool along your web analytics package of choice. The only drawback to me is that the search data doesn’t go back farther than 2004. With this tool you can gauge interest and demand for the search terms you specify and you can compare multiple search terms in the same ‘report’. There is even a bit of forecasting so can test out Google’s trending and forecasting prowess over time. Try it out and compare the data you see with that from your web analytics package and other tools such as Quantcast. Enjoy!
…. sounds like something you’ve heard when searching for a new home, doesn’t it? I’m borrowing from the real estate buzz phrase ‘location, location, location’ which helps explain real estate demand and property values.
Getting to the point related to web analytics, it is so important to validate reports, when possible, against another data source. This topic is addressed from an Omniture SiteCatalyst perspective in this excellent blog post at The Omni Man blog. Enjoy the read; let me know your reaction, or if I can help you better understand your web analytics results.
Big time DBAs, don’t laugh! But honestly, couldn’t it have been easier to format a numeric value as an amount with decimals? Maybe it will help others trying to format dollar amounts which are stored like 1234.1861 in SQL Server to look like 1234.19, for example. So deceivingly simple…
Here is how I searched BigG and found little:
TSQL display dollar amount
TSQL format dollar amount
TSQL format currency no dollar sign
Just pop this around the field name you need to format and you’re in business!
CONVERT(VARCHAR(10), CONVERT(MONEY, fieldname)) AS PRICE
Cheers!