Monthly Archives: May 2014

unfortunate reality to CMS based web development

An unfortunate reality to CMS based web development is that in most cases developers are used to working alone.  When working with a CMS most of the programming involved is customization rather than from scratch development, so the need to … Continue reading

Posted in SQL Server | Tagged , , , | Comments Off on unfortunate reality to CMS based web development

Database industry is growing fifty percent faster than the software market

QUITE INTERESTING. DATABASES ARE GROWING FIFTY PERCENT FASTER THAN THE SOFTWARE MARKET AS A WHOLE Revenue from software for structured data management and data access, analysis and delivery grew 7.3 percent and 6 percent, respectively in 2013, according to IDC. Both … Continue reading

Posted in SQL Server | Tagged , , , , , | Comments Off on Database industry is growing fifty percent faster than the software market

DevCoin – cryptocurrency to support open source development

Devcoin is an open source project designed to support open source projects through the use of a dedicated crypto currency. Crypto currency is a new form of digital money which is decentralized and runs on a distributed network of computers. … Continue reading

Posted in SQL Server | Tagged , , , , | Comments Off on DevCoin – cryptocurrency to support open source development

Microsoft Tackles 'SQL Server Sprawl'

Hewlett-Packard has partnered with Microsoft to introduce a preconfigured system for companies that want to perform analytics on data spread across many SQL Server databases. The HP ConvergedSystem 300 for the Microsoft Analytics Platform can draw structured data from SQL Servers and unstructured data … Continue reading

Posted in SQL Server | Tagged , , , | Comments Off on Microsoft Tackles 'SQL Server Sprawl'

The Drawback to Web Frameworks

Web frameworks are great, don’t get me wrong here. They provide a structure and consistency across projects that will transcend developers over the life of a system while dramatically simplifying the code base amongst other wonderful side effects. But what’s … Continue reading

Posted in SQL Server | Tagged , | Comments Off on The Drawback to Web Frameworks

The Sonics are coming home??

It looks like Steve Ballmer is starting to purchase the LA Clippers. I would be SOOOOO excited to have the Seattle SuperSonics back in town.  How often does a team in the playoffs get sold?? More importantly.. What does BASKETBALL … Continue reading

Posted in SQL Server, Visual Basic | Tagged , | Comments Off on The Sonics are coming home??

mySQL Scalability on Amadon RDS

Today, I’d like to discuss getting better MySQL scalability on Amazon RDS. The question of the day: “What can you do when a MySQL database needs to scale write-intensive workloads beyond the capabilities of the largest available machine on Amazon RDS?” Let’s … Continue reading

Posted in SQL Server | Tagged , , | Comments Off on mySQL Scalability on Amadon RDS

Missing Indexes Script v2 – SQLServerCentral

One of the greatest scripts of all time.

Posted in SQL Server | Tagged , , , | Comments Off on Missing Indexes Script v2 – SQLServerCentral

SQL Server creates a histogram on the leading key but not on the other columns

the leading key should be the most selective column—number in our case. Allegedly (according to the recommendation), SQL Server creates a histogram on the leading key but not on the other columns; so if you follow the recommendation, the optimizer … Continue reading

Posted in SQL Server | Tagged , , , , , | Comments Off on SQL Server creates a histogram on the leading key but not on the other columns

Supratimas – analysis tool for Microsoft SQL Server query execution plans

I found the GREATEST tool ever.. for analyzing SQL Server Query Plans.  I can’t wait to spend some more time with this! http://supratimas.com/ FEATURES Color Coding Nodes with cost of more than one per cent are colored blue. That makes … Continue reading

Posted in SQL Server | Tagged , , , , , | Comments Off on Supratimas – analysis tool for Microsoft SQL Server query execution plans