Good grief, there's a lot of travel in my immediate future. <sigh ... deep breath> It'll be exhausting and it'll be hard to lose so much time with the family. But if I'm able to avoid travel mishaps, it'll be fun. Meet Me In St. Louis I'll be speaking in St. Louis, MO on Tuesday, September 14th for their mid-day meeting. The details, as I have them, are: Tuesday, September 14, 2010 1-4pm Location: Microsoft St. Louis Office, Three City Place Drive, Suite 1100, St. Louis, MO … [Read more...]
See You in St Louis, and then London, Amsterdam, Copenhagen, Stockholm, and York, UK
Filed Under: Conferences, Databases, Presentations, Professional Development, SQL Server, SQLServerPedia Syndication Tagged With: DBA, Developer, Events, SQL Server 2008 R2, Training
Free Poster – SQL Server PerfMon Counters
You Needs It! You Wants It! We all know how hard troubleshooting SQL Server can be. There are tools and techniques that can make troubleshooting much easier, such as the Windows System Monitor. The only problem with SysMon, or more commonly "PerfMon", is that it takes a lot of knowledge and experience to know which objects and counters to examine. I've put together a nice poster for you covering all of the important PerfMon counters for SQL Server troubleshooting, with a little help from some of my friends: Brent Ozar, Bob Ward, Christian Bolton, and Raoul Illyes. You Can Has It Fer … [Read more...]
Filed Under: On-Line Resources, Presentations, SQL Server, SQLServerPedia Syndication, Tips & Tricks Tagged With: DBA, SQL Server 2008 R2, Tools, Training, Troubleshooting
Join O’Reilly on Facebook
O'Reilly Media on Facebook is a place for for anyone who is a fan of O'Reilly, whether you've been following their books, conferences, webcasts, and more since the very beginning or you recently jumped onto the bandwagon. I really enjoy the newsletters and blogs from O'Reilly's various channels, especially Tim O'Reilly's commentary. And, of course, there's my book - SQL in a Nutshell - published by O'Reilly for your consideration. This book provides a complete reference of the latest release of the ANSI SQL standard, as well as full coverage of support for the ANSI standard from the … [Read more...]
Filed Under: On-Line Resources, SQLServerPedia Syndication Tagged With: ANSI SQL, DBA, Developer, MySQL, Oracle, PostgreSQL, SQL Server 2008, Transact-SQL Programming
Video: Worth Upgrading to SQL Server 2005
Why companies should upgrade their databases to SQL Server 2005. Please forgive posting this old video. Many of the tips are still worth paying attention to since SQL Server 2005 features and technologies are the foundation of subsequent releases. Posted December 19, 2006. … [Read more...]
Filed Under: Opinion, Presentations, Professional Development, SQLServerPedia Syndication, Video Tagged With: DBA, Developer, SQL Server 2005
Presentation: SQL Server for Oracle DBAs
Back in late May, my pal Buck Woody (blog | twitter) and I presented SQL Server for the Oracle DBA. Buck played Jerry Lewis' role, while I played the straight man a la Dean Martin. You can see the recording and slide deck here. Since both Buck and I spent a considerable number of years working on Oracle, we felt like we had pretty good legs to stand on doing this presentation. Here's the abstract: In enterprise IT, database professionals face a mixed-bag of platforms within their environments -- and the overlapping duties that go along with them. Whether you like it or not, you get … [Read more...]
Filed Under: Administration, Databases, On-Line Resources, Presentations, SQL Server, SQLServerPedia Syndication, Tips & Tricks Tagged With: DBA, Oracle, Quest Software, Training
Video: Disk Tuning and Optimization for SQL Server
This video focuses on accelerated Disk Optimization and improved productivity with SQL Query Tuning. Video created Dec. 18, 2006. … [Read more...]
Filed Under: IO, Performance, Presentations, SQLServerPedia Syndication, Video Tagged With: DBA, SQL Server 2005
New Fast Features Video – Toad for SQL Server
Fast Features for Quest Tools. Someday soon, I promise. I've been trying hard to get more videos out the door about the SQL Server tools from Quest Software (my employer). I'd sent a new one over to the program marketing team a while back, but it's not showing up in the Coffee Break Bytes section like it should. These little videos show a single feature in detail, usually taking no more than 5 minutes to watch in their entirety. In the meanwhile, check out the excellent video series here. And the blogs are really good too, available on the interwebs here. Thinking about cloud … [Read more...]
Filed Under: NoSQL, On-Line Resources, SQLServerPedia Syndication, TCD blog post, Transact-SQL Programming Tagged With: DBA, Developer, Quest Software, Toad for SQL Server, Tools
It’s the Atlanta Attendance Contest!
I'm speaking tonight on Top 10 Mistakes DBAs Make at the Atlanta SQL Server User Group meeting in Alpharetta, GA. You can find all of the details here. I thought I'd liven things up a bit with a little contest. The rules are simple: A. If you don't follow me on Twitter, then follow me by clicking here. B. If you already follow me on Twitter, then tweet the details for tonight's event. C. Every new follower or current follower who retweeted the details and then attends the event tonight will get a free ebook for Professional SQL Server 2008 Design and Implementation by my … [Read more...]
Filed Under: PASS, Presentations, SQLServerPedia Syndication Tagged With: Best Practices, DBA, SQLPASS
In-Memory Databases (IMDBs)
Moore's Law tells us that CPU's get a LOT faster over time. Unfortunately for the database professional, all of the secondary elements of our databases DO NOT get a lot faster over time. Overall, the main methods of storing data since the 1960's, magnetic tape and hard disks, have improved only in the single percentiles year over year. Even those of us who were never good at math can tell that the CPU is outpacing the other system components. Two recent developments are helping to change that equation. First, solid state drives (SSDs) are having a dramatic impact many IT scenarios. … [Read more...]
Filed Under: Administration, Cool Technologies, SQLServerPedia Syndication, Trends Tagged With: DBA, FutureWatch, IMDB, Performance
Live! TechNet Radio: Microsoft Cloud Services – SQL Azure
Just wanted to let you know that a TechNet Radio episode and interview I did about cloud computing is now live on TechNet Edge. It was the featured spot on Thursday, June 3rd and is also featured on the TechNet homepage. I've been trying to wear more of an analyst's hat these days, so this webcast has a lot of my "deep thinking" on issues related to cloud computing - hopefully at a higher level of quality that Jack Handy. A salient point that I think many analysts are overlooking is the changing nature of data as it exists in the cloud. For decades, data has primarily been about people … [Read more...]
Filed Under: Administration, On-Line Resources, Opinion, SQLServerPedia Syndication, Trends Tagged With: cloud computing, DBA, FutureWatch, news analysis, SQL Azure, SQL Server 2008 R2, TechNet
