In the last several articles on Database Trends & Applications, I've been describing the benefits of reading and analyzing the benchmarking case studies released by the Transaction Processing Council. I've given you from a broad overview of the TPC benchmarks and shown ways that the vendor-published TPC benchmarks can help you save money and how the vendor-published TPC benchmarks must explain in disclaimers how they tweak their workloads. I have described how to run your own benchmarks and explained how to properly prepare your environment for a benchmark test. Pictured (L-R): Scott … [Read more...]
New on DBTA.com: Database Benchmarking Tools, the final article in the database benchmarking series
Filed Under: Administration, Architecture, Cool Technologies, Databases, DBTA, Hardware, IO, Opinion, Performance, Professional Development, SQL Server, SQLMag, SQLServerPedia Syndication, Strategies Tagged With: Benchmarking, Best Practices, Career, DBA, Performance, Tools, Tools & Scripts
Microsoft Document Watch for Operational Excellence
Back when my day-to-day duties included database administration work and enterprise architecture, I became rather obsessed with the idea of operational excellence. I read everything I could on the topic. I made a list of favorites, which became somewhat shabby over time, as I dog-eared important pages and scribbled notes in the margins. (Perhaps that list of favorites might, in and of itself, make a good blog post). Fast-forward a decade and I'm still mightily interested in operational excellence for IT organizations. It's just that so much good material is available for free on the … [Read more...]
Filed Under: Administration, Architecture, Compliance, Cool Technologies, Hardware, On-Line Resources, Security, SQL Server, SQLMag, SQLServerPedia Syndication, Strategies, TCD blog post, Tips & Tricks, Virtualization Tagged With: Architecture, Best Practices, Compliance, DBA, Enterprise Architecture, Management, Operations, Performance, Security, SQL Server 2008 R2, Tools, Troubleshooting
Leadership, Management, and SQLRally
Transparency - A Great Leadership Quality I've always appreciated how Andy Warren (blog| twitter) operates in the most transparent manner, especially as it relates to his role as a director for the Professional Association for SQL Server. For example, Andy's latest blog post about prepping for the SQLRally, to kick off in less than 30 days, is insightful and gives you a good idea of the sort of work a strong director for PASS needs to put in. I also enjoy how Andy more or less thinks out loud and offers you the chance to provide your input. In that latest blog post, he was mulling different … [Read more...]
Filed Under: Conferences, Governance, Interviews, PASS, Professional Development, SQL Server, SQLMag, SQLServerPedia Syndication, Strategies, Video Tagged With: Career, Goals, Plays Well With Others, Professional Development, SQLPASS, Training
Adventures in the Land of CloudDB/NoSQL/NoAcid
Last year, some of my friends from Quest Software attended Hadoop World in New York. In 2009, I never would've guessed that Quest would be there with products, community initiatives, as a major sponsor and with presenters? There were just under 1,000 attendees who weren’t the typical devheads and geekasaurs you'd normally see at very techie events like Code Camps, SQL Saturdays, Cloud Camps and or even other NoSQL events such as the Cassandra Summit. We're talkin' enterprise customers with active Hadoop projects underway. Some observations from the show that may be of interest to … [Read more...]
Filed Under: BigData, Cloud, Conferences, Cool Technologies, Databases, NoSQL, Opinion, SQL Server, SQLMag, SQLServerPedia Syndication, Strategies, TCD blog post, Trends Tagged With: Hadoop, news analysis, NoSQL, Oracle, Quest Software
Video: Interview – Part 3 Cross-Platform Issues
Heather Eichman interviews Kevin Kline, the former President of PASS and systems specialist for the SQL Server Business Unit at Quest Software. Posted January 31, 2008. … [Read more...]
Filed Under: Challenges, Cool Technologies, Databases, Interviews, Opinion, SQL Server, SQLServerPedia Syndication, Strategies, Video Tagged With: DBA, Oracle, SQL Server 2005, Video
DBTA: Compliance – A Key Element of a Data Management Strategy
Compliance is one of the most interesting elements of any data management plan - it's a microcosm of evolution in action. When many of the laws that impacted data retention were first enacted, business wasn't collecting a lot of information. Now, data collection happens everywhere. And, as citizens have come to realize that more and more of the information about their daily lives is recorded, they demand their governments provide privacy and protection from misuse of that data. [READ MORE] Originally published Jul 12, 2010 … [Read more...]
Filed Under: DBTA, Opinion, SQL Server, SQLMag, SQLServerPedia Syndication, Strategies, TCD blog post, Trends Tagged With: Best Practices, DBTA, SQL Server 2008 R2
Video: SQL Server Memory Troubleshooting
Need to troubleshoot SQL Server 2005 memory settings? Not sure where to look to measure SQL 2000 memory pressure? Kevin lays out your options in today's podcast. You can view this video in higher quality or your favorite portable formats at: http://sqlserverpedia.com/blog/sql-se... Video published December 24, 2008. … [Read more...]
Filed Under: Challenges, Opinion, Performance, Professional Development, SQLServerPedia Syndication, Strategies, Video Tagged With: DBA, DMV, Internals, Performance, SQL Server 2000, SQL Server 2005, Video
TN Summit 2010 – Surviving the Data Avalanche
Here's the link to my revamped presentation on Surviving the Data Avalanche The Abstract for this presentation is here. The slides for this presentation are here. … [Read more...]
Filed Under: BigData, Challenges, Databases, IO, Performance, Presentations, SQL Server, SQLServerPedia Syndication, Strategies, Trends, Video Tagged With: Best Practices, DBA, Internals, Performance, SQL Server 2008 R2, Video
Plays Well With Others – Metrics to the Max!
November 2009 would have been the 100th birthday of famed management guru, Peter Drucker, were he alive today. Now for those of you who don’t know the name, Peter Drucker was no mere guru or simple pundit. He was in fact the father of management and universally acclaimed as the world’s greatest management thinker. Anyone who’s taken a business class, studied for an MBA, or had to deal with an IT project to build a management dashboard has been touched by Peter Drucker. If you have a spare moment, add Drucker’s Concept of the Corporation to your library. Drucker came upon the scene at a … [Read more...]
Filed Under: Challenges, Governance, On-Line Resources, Opinion, Professional Development, SQLServerPedia Syndication, Strategies Tagged With: Best Practices, Career, Management, Professional Development
DBTA: The Big Keep Getting Bigger
In this season of recession and financial meltdowns, a common question seems to be, "How big is ‘too big to fail'?" Titans of the financial industry made big bets with lots of risk and, when they didn't pan out, American society overall has to pay the price. But, that aside, the very scale of our financial system, by just about every metric, has reached amazing heights, be that number of financial transactions per second, number of traders, number of funds traded, amount of money changing hands—you name it. [READ MORE] … [Read more...]
Filed Under: BigData, Challenges, Databases, DBTA, Hardware, IO, Opinion, SQL Server, SQLServerPedia Syndication, Strategies, Trends Tagged With: Best Practices, DBA, DBTA, Developer, Internals, Monitoring, news analysis, SQL Server 2008 R2
