"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
This BI blog has a very simple motive. It’s just a BI guy’s enthusiasm to chronicle the exciting period of Business Intelligence technology, as it stands today. So hop on and let’s attempt to blog the next big stride of Business Intelligence.
"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
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
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
"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
Solid Quality Mentors is comprised of more than 100 of the world's top technical experts who specialize in assuring client success using integrated Microsoft technologies. Since being founded in 2002, we have become a trusted global provider of advanced
SQLBlogCasts is a free service to those folk who want SQL Server related blogs. It's there to support the online community especially in but not limited to the UK. The site is a partner of the UK SQL Server User Group a group of professionals with an int
We have regular meetings in Cambridge and London. Our aim is to build the SQL Server community in the UK through social meetings where anyone interested in SQL Server can come and share there experiences and learn from other peoples experiences with SQL S
"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 user group was started in November 1999 by Tony Rogerson to address the need for a UK based community and content site specifically addressing the needs, concerns and asperations of people based in the UK. We have grown ever since through online conte
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
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
"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"
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
"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
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
"Calculating Median and Mode with SQL Server can be frustrating for some developers, but it doesn't have to be. Often times, inexperienced developers will attempt to write this with procedural programming practices, but set based methods do exist."
"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."
"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
"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
"This site is about helping WordPress users take advantage of Microsoft technology. How, you ask? Yes, it runs WordPress on Windows and SQL Server. Stay tuned for articles about building WordPress plugins, content curation and a whole lot more."