One of the types of question you get after speaking at a conference about virtualization, like I did at the 2012 PASS Summit with my buddy David Klee (Twitter | Blog), might go down like this: "Is SQL Server version X supported on hypervisor platform Q?" or something even more specific like "Is SQL Server 2012 supported on VMWare vSphere ESX 4.1 Update 2? Or do I have to upgrade to ESX 5.0?". Now, when I'm asked a question like this, I usually drool and act like an ape, hoping the the questioner will flee in terror. If they insist on hanging around to hear a real answer, I now refer them to … [Read more...]
Is Microsoft SQL Server Supported By …?
Filed Under: Administration, Compliance, Cool Technologies, Databases, On-Line Resources, SQL Server, SQLMag Tagged With: Best Practices, cloud computing, DBA, Developer
Demo Mastery for the Technology Evangelist
In the same way that the finest presentations involve much more than the simple relaying of information, the finest software demos are much more than just presenting features. REMEMBER: The goal of a demo is to INSPIRE the audience to use the software/technology, not to teach them every nuance of software/technology. I've spent the last 10 years learning how to give good presentations and to give good software demonstrations. Here are several tips to take your software demonstration from informative to masterful: 1. Know your audience Whenever you start a demo, make sure you have a good … [Read more...]
Filed Under: Challenges, Cool Technologies, Databases, Opinion, Presentations, Professional Development, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post Tagged With: Best Practices, Career, DBA, Developer, Presentations, Professional Development, Training
What’s It Like on a SQLCruise?
I always seem to get a question or two along the lines of "What's it like on a SQLCruise?" as I present at various conferences, SQL Saturdays, and user group meetings. Since we just finished up the 2013 Miami SQLCruise, I thought it'd be a good time to recap so that you can judge for yourself if you'd ever want to do it yourself. Personally, I think that Tim Ford (Twitter | Blog), together with his wife Amy, are doing better than ever in making the cruise both a top-quality learning experience and fantastic social experience. I've heard from many attendees that they learned enough in the … [Read more...]
Filed Under: Conferences, Databases, Presentations, Professional Development, SQL Server, SQLMag, SQLServerPedia Syndication Tagged With: Career, DBA, Developer, Professional Development, SQL Server 2012, Training
The Year That Was – 2012
2012 was, simply stated, a year that kicked my butt. When I wasn't struggling professionally, I was struggling personally. Health issues, culminating in a diagnosis of Type II diabetes, and the passing of my father soon after Thanksgiving marked my biggest struggles. I apologize to those of you who are normally on my Christmas card list for not sending any this year. The wind was not in my sails. On the positive side of the ledger, I made a scary but exciting leap to SQL Sentry midyear. This was a huge shake-up after 10 years with my previous employer, but one which has been met with … [Read more...]
Filed Under: Administration, Conferences, Cool Technologies, Databases, DBTA, On-Line Resources, Presentations, Professional Development, SQL Server, SQLMag, SQLServerPedia Syndication, Tool Time Tagged With: Best Practices, Career, DBA, DBTA, Developer, Professional Development, SQL Server 2012, SQLMag, Writing
Learn More About SQL Server IO and Query Tuning in These Webcasts
I'm doing two new webcasts next week on Wednesday, December 19th, one in the morning and the other after lunch. SSDs are a Game Changer for SQL Server Storage No, don't let the title mislead you. This session is not exclusively about SSDs. But this is my first session on IO and storage tuning that emphasizes SSDs over hard disks. As Bob Dylan said "Times, they are a'changin'". This session on Wednesday, December 19th at 11:30 AM EST, sponsored by Astute Networks, takes you through all of the basics of storage and IO tuning, regardless of the underlying storage technology. I'll … [Read more...]
Filed Under: Administration, Databases, IO, Performance, Presentations, SQL Server, SQLMag, SQLServerPedia Syndication, Transact-SQL Programming, Video Tagged With: Best Practices, DBA, Developer, Internals, IO, SAN, SQL Server 2012, SSD, Storage, Training, Transact-SQL Programming, Video
Let’s Talk Licensing and Virtualization for SQL Server
I have two new articles up on Database Trends & Applications magazine. I'd love to get your thoughts and feedback! Welcome to the Weird, Wild World of SQL Server Licensing Not long in the past, SQL Server licensing was an easy and straightforward process. You used to take one of a few paths to get your SQL Server licenses. The first and easiest path was to buy your SQL Server license with your hardware. Want to buy a HP Proliant DL380 for a SQL Server application? Why not get your SQL Server Enterprise Edition license with it at the same time? Just pay the hardware vendor for the … [Read more...]
Filed Under: Administration, Architecture, Cool Technologies, Databases, DBTA, On-Line Resources, Performance, SQL Server, SQLMag, SQLServerPedia Syndication, Trends, Virtualization Tagged With: Best Practices, DBA, DBTA, Developer, Internals, Licensing, Monitoring, SQL Server 2012, SQLMag, SQLPASS, Virtualization, VMware
How To Download Free Sessions From PASS
For all members of the Professional Association for Server (PASS), are you downloading slides and videos from all sorts of great PASS events? If not, what are you waiting for ... an invitation? Ok, here it is. I invite you to download like a madman! (How a madman downloads, an almost entirely virtual activity, is not the question here, ok?). For starters, there's the recent 24 Hours of PASS event. I hope you were able to attend all of the sessions you wanted. But even if you didn't get to see any, you can see them now as long as you're a (free) member of PASS. The session recordings … [Read more...]
Filed Under: Conferences, On-Line Resources, PASS, Professional Development, SQL Server, SQLMag, SQLServerPedia Syndication Tagged With: Best Practices, Career, DBA, Developer, Professional Development, SQLPASS, Training
Quick Tip – Speed a Slow Restore from the Transaction Log
Here's a quick tip for you: During some restore operations on Microsoft SQL Server, the transaction log redo step might be taking an unusually long time. Depending somewhat on the version and edition of SQL Server you've installed, you may be able to increase performance by tinkering with the readahead performance for the redo operations. To do this, you should use the MAXTRANSFERSIZE parameter of the RESTORE statement. For example, if you set MAXTRANSFERSIZE=1048576, it'll use 1MB buffers. If you change the MAXTRANSFERSIZE, keep an eye on the PerfMon objects for Buffer Manager and … [Read more...]
Filed Under: Databases, IO, Performance, SQLMag, SQLServerPedia Syndication, Tips & Tricks Tagged With: Backup & Recovery, DBA, Internals, SQL Server 2012
PASS Summit 2012, Slide Decks
Ok, I have to admit the painful truth. I'm reliably slow to the finish line. This year, I got my slides into PASS HQ by the skin of my teeth, the weekend before the event was to begin. Although I could say with a straight face "I uploaded my slides!". I have to be honest that I wasn't surprised when many of my attendees said that they weren't available for download by the time my session started. OTOH, I also have to say that I really do prefer for attendees to focus on the presentation while it's being presented and that they should grab the slides afterwards. But that's just my personal … [Read more...]
Filed Under: Administration, Conferences, Cool Technologies, Databases, PASS, Performance, Presentations, Professional Development, SQL Server, SQLMag, SQLServerPedia Syndication, Virtualization Tagged With: Career, DBA, Developer, Leadership, Plays Well With Others, Professional Development, SQL Server 2012, SQLPASS, Virtualization, VMware
PASS Summit 2012, Day 1
One of the most positive experiences I can have, as a former leader of the PASS organization, is when I see a neophyte become a passionate support and champion for the community. On my first day in Seattle, before the event had even begun, I was stopped several by people who'd attended their first PASS Summit last year. But this year, they were excited to tell me that they'd started user groups in their own community, spoken for the first time at a PASS event, or even helped launch a SQL Saturday event. Wow! To go from a complete newcomer in the PASS community to an active and engaged … [Read more...]
Filed Under: Conferences, PASS, Professional Development, SQLMag, SQLServerPedia Syndication Tagged With: DBA, Leadership, SQL Server 2012, SQLPASS
