Blog : What’s On Our Mind?

Sharing Our Point of View
By Eric Russo | On October 17th 2014
Using Twitter as a SQL Resource
Have you found yourself thrust into new responsibilities within your IT department as a manager overseeing database operations? You may be what’s called an “Accidental DBA.” As we explained in a prior post, it’s tough when you’re a professional new to this job to get up and running when you’re unsure where to start and what to do. We provided some basics for the Accidental DBA, but what happens when you reach an impasse? Kirsten Benzel, a database developer at SurveyMonkey who began her…
By Eric Russo | On October 8th 2014
“The number of transistors incorporated in a chip will approximately double every 24 months.” – Gordon Moore When Gordon Moore, co-founder of Intel, made this observation in 1965, he sought to a simple measure for the growth in integrated circuits, not the exponential growth in data. Moore’s Law — which has since been refined to hold that chip density doubles approximately every 18 months — can…
By Andy McDermid | On October 7th 2014
The Long Road
You can easily resolve some issues related to SQL Server performance, but there are others that require more time and resources. Implementing these performance solutions may require some planning or perhaps a service outage. Once configurations are adjusted, they may need long-term monitoring or ongoing adjustments to succeed. That’s why we call these solutions “The Long Road.” There are four issues under this umbrella: file locations, virtual log files, tempdb files, and missing index DMVs. File Location File location is an important aspect of good database architecture….
By Andy McDermid | On October 6th 2014
Best Bang
There are many issues that can affect the health and stability of your SQL Server performance. Most can be easily resolved without extreme technical intervention. Some issues require a bit of evaluation and analysis to resolve. Some configurations have measurable effects on performance – these may be specific to the operating system, SQL instance, or the database. Because these adjustments result in a significant return on investment, providing stability and performance through simple tuning, we think these solutions give you the Best Bang for the Buck. First Steps Some…