SQLBITS One of the top highlights of my year is when I get to visit the great cities of Europe and meet with the great IT professionals there. Last October, I was able to visit several cities in Europe, including my first ever stop in Stockholm and Malmo, Sweden. Last year's SQLBits event was in the lovely city of York, England. This spring, in fact the next two weeks, I'll be on a whirlwind junket. In just a few hours, I fly out to London and then drive down to Brighton for a couple days of SQLBits. SQLBits has a great lineup of speakers and content this spring. I'm looking … [Read more...]
SQLBits and Events in Dublin, Koln, and Malmo
Filed Under: Conferences, PASS, SQL Server, SQLMag, SQLServerPedia Syndication Tagged With: cloud computing, DBA, Developer, SQL Server 2008 R2, Training
SQLServerPedia Has a New Editor-in-Chief. Oh no, it’s Me!
Attrition has taken its toll once again as a few good friends move from being colleagues to being former colleagues. As a result of the folks moving on to bigger and better things, I'm now stepping up in to the roll of editor-in-chief of SQLServerPedia. This roll is mostly about checking on the quality of content produced by our syndicating bloggers to make sure that they're not trying to sell products or services and that their posts are of high quality. That's about where the official duties end, save for things like acting as a judge in big SSP contests. One new aspect that I want … [Read more...]
Filed Under: On-Line Resources, Professional Development, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post Tagged With: Oracle, Plays Well With Others, SQL Server 2008 R2, SQLMag, Writing
How Do You SKU?
I’d like your opinion here. Follow my logic here for a moment as I walk through a couple rhetorical questions. Have you ever had a friend developed an application entirely on SQL Server Developer Edition? (Not that YOU would ever do such a thing, but maybe you know someone who has. Right?) And has your friend’s IT department actually deployed said application only to discover that they’re only licensed for Standard Edition in their production environment? And then was your friend’s IT management team is horrified to learn that they’ve either got to go through the very expensive process … [Read more...]
Filed Under: Databases, Opinion, SQL Server, SQLMag, SQLServerPedia Syndication Tagged With: Best Practices, DBA, SQL Server 2005, SQL Server 2008 R2
Come Aboard. We’re Expecting You
Those of us over a certain age (read - old as dirt) can remember the theme songs to certain TV shows better than we can the National Anthem. Try these lines out and see if you don't immediately remember the tune that goes along with them: Come and knock on our door | We've been waiting for you ... Makin' your way in the world today | Takes everything you've got ... Just some good ol' boys | Never meaning no harm ... Thank you for being a friend | Travel down the road and back again ... So when I got the news that my employer, Quest Software, wanted to send one of the team to an … [Read more...]
Filed Under: IO, SQL Server, SQLMag, SQLServerPedia Syndication Tagged With: Best Practices, Professional Development, SQL Server 2008 R2, Training
Database Maintenance Scripting Done Right
I first wrote about useful database maintenance scripts on my SQLBlog account way back in 2008. Hmmm - now that I think about it, I first wrote about my own useful database maintenance scripts in a journal called SQL Server Professional back in the mid-1990's on SQL Server v6.5 or some such. But I digress... Anyway, I pointed out a couple useful sites where you could get some good scripts that would take care of preventative maintenance on your SQL Server, such as index defragmentation, updating statistics, and so forth. One of the script kits came directly from Microsoft's internal … [Read more...]
Filed Under: Administration, Challenges, Databases, On-Line Resources, Performance, SQL Server, SQLMag, SQLServerPedia Syndication, Tool Time Tagged With: Best Practices, DBA, Performance, SQL Server 2008 R2, Tools & Scripts
Have You Heard About Project Lucy?
Quest Software's latest community initiative, Windows Azure-based Project Lucy, has debuted! Project Lucy is part infrastructure analytics, part social media experiment, and part performance data warehouse. The best things about Project Lucy include: It’s Free - just like our SQLServerPedia website, Project Lucy is free to anyone who wants to upload a trace file It’s 1oo% web-based - you don’t have to download or maintain anything and updates roll out seamlessly, all the time It really helps - just generate a SQL Trace on a SQL Server 2000, 2005 or 2008 instance, upload it on … [Read more...]
Filed Under: Cloud, Cool Technologies, Databases, On-Line Resources, Performance, SQL Server, Tips & Tricks, Tool Time Tagged With: cloud computing, Performance, Quest Software, SQL Server 2005, SQL Server 2008 R2, Tools, Troubleshooting
Cloud Evolving, SQL Server Responding
Brent Ozar (blog | twitter) and I did an interview with TechTarget’s Brendan Cournoyer at last summer's Tech-Ed, which as turned into a podcast titled “Cloud efforts advance, SQL Server evolves.” The podcast covers all the major trends at the conference (like BI), virtualization features in Quest’s products (like Spotlight), Brent’s new book and MCM certification, and more. Here’s a link to hear it, appearing on 6/11/10: http://searchsqlserver.techtarget.com/podcast/Cloud-efforts-advance-SQL-Server-evolves … [Read more...]
Filed Under: Cloud, Databases, Interviews, Professional Development, SQLMag, SQLServerPedia Syndication, TCD blog post Tagged With: Azure, Career, cloud computing, DBA, Professional Development, SQL Server 2008 R2, Writing
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
What’s Your Data Management and Retention Policy? [DBTA]
If managing your corporate data for the long term isn't currently on your mind, it should be, and in several different ways: cost, performance, business continuity, and compliance. [READ MORE] Originally posted on Jun 7, 2010 … [Read more...]
Filed Under: Databases, DBTA, Opinion, SQLServerPedia Syndication, TCD blog post, Trends Tagged With: Backup & Recovery, Best Practices, DBA, DBTA, SQL Server 2008 R2
DBTA: Forecasting SQL Server in 2010
After the misery that was 2009, most of the SQL Server users I talk to are happy that 2010 started in languid fashion. Not that there isn't a lot of work to do; on the contrary, there's more work than ever. However, the long hours and multiple projects of 2009, compounded by freezes in all levels of spending, raised the general stress level to unhealthy heights. With the new year, stress levels dropped significantly, and many IT leaders see signs of improving prospects. What does that bode for 2010? I have a couple of predictions, though I doubt they'll surprise many people. [READ … [Read more...]
Filed Under: Challenges, Cloud, Databases, DBTA, Opinion, SQLServerPedia Syndication, TCD blog post, Trends Tagged With: Azure, DBA, DBTA, Developer, news analysis, SQL Server 2008 R2
