"Databases are the heart and soul of many enterprise applications, and it is very essential to pay special attention to database programming. I’ve seen in many occasions where database programming is overlooked, thinking that it’s something easy that be d
Web usage mining attempts to discover useful knowledge from the secondary data obtained from the interactions of the users with the Web. Web usage mining has become very critical for effective Web site management, creating adaptive Web sites, business and
This paper provides an overview of Web Analytics. It describes how Internet communications occur and how those communications are logged. It explains how data from a web server's log can be harvested to generate useful and actionable business intelligen
"ustin Silverton at Jaslabs has a supposed list of 10 tips for optimizing MySQL queries. I couldn't read this and let it stand because this list is really, really bad. Some guy named Mike noted this, too. So in this entry I'll do two things: first, I'll e
It is always more efficient to maintain referential integrity by using constraints rather than triggers. Sometimes it isn't obvious how to do this. Until a recent idea by Alex Kuznetsov, the history table presented problems for checking data that were dif
The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting, educating, and promoting the Microsoft SQL Server community. From local user groups and special interest groups (Virtual Chapters) t
SQL Server 2005 Performance Tuning using the Waits and Queues is a proven methodology that allows one to identify the best opportunities to improve performance, the so called “biggest bang for the buck”. These performance improvements are likely to have a
MSSQLTips.com was started and is run by Edgewood Solutions, SQL Server industry experts that saw the need for a different approach to learning about SQL Server. There is plenty of content on the web, but finding content or learning something new about SQ
"The purpose of this blog will be to walk through the book “SQL Server MVP Deep Dives” chapter by chapter and provide perspectives from the three contributors to the blog plus one guest blogger, on a weekly basis."
"The server collation acts as the default collation for all system databases that are installed with the instance of SQL Server, and also any newly created user databases. The server collation is specified during SQL Server installation"
"I'm continually trying to track down what service packs are installed on various SQL Servers I support. I can never find the right support page on Microsoft's site. So here's an article with all the SQL Server version information I can track down. If you
"In this workbench, we'll show you some fairly simple string User-Functions. Rather than invent the ones we like, we're going to take a different angle and implement the Python string functions, as much as we can. Plenty of examples, and some programming
"The Return of the Killer Tuples This workbench finishes of what has been a three-part series of string functions. In it, we introduce the idea of using XML to provide a very simple array for doing string handling. This allows us to use functions for sea
"Any project involving Microsoft BI stack technologies, i.e. SSIS / SSAS / SSRS, starts with the installation of SQL Server and BIDS and then as the project progresses and the spectrum of requirements starts getting broader, developers and DBAs starts hun
One of the most important things to measure, monitor, and “get right” for good overall SQL Server OLTP performance is the number and composition of your SQL Server relational indexes. It is extremely important to have neither too many or too few relationa
Most of the time, you do not have to worry about implicit conversion in SQL expressions, or when assigning a value to a column. Just occasionally, though, you'll find that data gets truncated, queries run slowly, or comparisons just seem plain wrong. Robe
"To generate a complex password, we should not only get random value from the set of the characters but also guarantee the combination of upper case, lower case, numbers and special characters. In the procedure below, the password generated will include a
"SARGable is an adjective in SQL that means that an item can be found using an index (assuming one exists). Understanding SARGability can really impact your ability to have well-performing queries. Incidentally – SARGable is short for Search ARGument Able
"SQLinForm is an automatic SQL code formatter for all major databases including ORACLE, SQL Server, DB2 / UDB, Sybase, Informix, PostgreSQL, Teradata, MySQL, MS Access etc. with over 50 formatting options."