SSDTBI for Visual Studio 2012 enables customers to use the Analysis Services, Integration Services, and Reporting Services project templates within the Visual Studio 2012 shell. The components are delivered as a web download on the Microsoft Download center and will be available through Web Platform Installer. This release is the equivalent functionality to SSDTBI (BIDS) for Visual Studio 2010 that shipped in the SQL Server 2012 box. The team adapted the UI to meet the new Visual Studio 2012 UI design. This release delivers on the SQL commitment to provide BI Project Templates supporting … [Read more...]
SQL Server Data Tools – Business Intelligence for Visual Studio 2012 Released!
Filed Under: Cool Technologies, Databases, SQLMag, SQLServerPedia Syndication, Tool Time Tagged With: Business Intelligence, Tools
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
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
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
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
Conquer Your Fear of Virtualization with a Free Day of Training at PASS!
Click the link above to register! Presented by my buddy, David Klee at House of Brick, one of the nations top VMWare consultancies specializing in Oracle and SQL Server deployments. David has a great write-up of this boot camp at http://www.davidklee.net/2012/10/01/virtualizing-your-business-critical-sql-servers-free-boot-camp-by-house-of-brick/. … [Read more...]
Filed Under: Administration, Architecture, Conferences, Cool Technologies, Databases, PASS, Presentations, SQL Server, SQLMag, SQLServerPedia Syndication, Virtualization Tagged With: DBA, SQL Server 2012, SQLPASS, Virtualization
Recap – SQL Saturday 151 in Orlando
It's always a feel-good experience for me to return to SQL Saturday in Orlando, the place where SQL Saturdays were started by Andy Warren (Twitter | Blog). On this trip, I delivered a full-day, pre-conference seminar on Troubleshooting and Performance Tuning SQL Server. I also delivered a session on SQL Server Internals and Architecture to a totally packed house. For those of you who emailed me directly, here's the link for the special SQL Sentry offer. I got to attend the extended events session by Jack Corbett (Twitter | Blog), middle in the photo above. Good stuff, Jack! Jack … [Read more...]
Filed Under: Conferences, Cool Technologies, PASS, Presentations, SQL Server, SQLMag, SQLServerPedia Syndication Tagged With: Best Practices, Career, DBA, Professional Development, SQLPASS, SQLSaturday
Help Me Update the History of SQL Server
I was chatting with my buddy, Buck Woody (Twitter | Blog), about a week ago and we were discussing that it's pretty hard to put together the entire history of SQL Server. Then the thought hit me that I'd already done this, to a degree, in my book Transact-SQL Programming. This was the first Transact-SQL programming book on the market way back in the SQL Server 7.0 days and even included full coverage of both Microsoft and Sybase variants of T-SQL. The thing is, I was never able to put out a second edition due to some legal and contractual issues. So, help me catch up on the history of … [Read more...]
Filed Under: Cool Technologies, Databases, Opinion, SQL Server, SQLMag, SQLServerPedia Syndication, Transact-SQL Programming Tagged With: Career, DBA, Developer
Timewarp: What Is a Relational Database?
Relational?!? Move On, Geezer! Maybe you're thinking that relational databases management systems (RDBMSs), like Microsoft SQL Server and Oracle, are going the way of punched cards and rotary phones. After all, there's been a lot of hype these days in the IT media about the rise of so-called NoSQL (Not Only SQL) databases. Many new and upcoming CS and MIS graduates who like working with data might think that relational databases are, at best, soon-to-be legacy systems and, at worst, are a career dead-end. Wrong!!! It's true that all the cool-cat computing services (Amazon, Facebook, … [Read more...]
Filed Under: Architecture, BigData, Cloud, Cool Technologies, Databases, NoSQL, Opinion, SQL Server, SQLMag, SQLServerPedia Syndication Tagged With: Azure, cloud computing, DBA, Developer, NoSQL, Oracle, SQL Server 2012
Secure Your Spot at the Nashville SQL Saturday!
PASS SQL Saturdays are free 1-day training events for IT professionals interested in Microsoft SQL Server, providing a variety of high-quality technical sessions, all happen through the efforts of local volunteers. The leadership team of the local chapter of PASS here in Nashville (Facebook | LinkedIn) have worked hard to make this year's SQL Saturday a day of great training and networking. The local NashSQL leadership team includes yours truly (blog | twitter), Joe Webb (Twitter | Blog), Louis "Dr SQL" Davidson (Twitter | Blog), Christina Leo (blog | twitter), and Shelton Dickson … [Read more...]
Filed Under: Conferences, Cool Technologies, Databases, Nashville SQL Server Users Group, PASS, Presentations, Professional Development, SQL Server, SQLMag, SQLServerPedia Syndication Tagged With: Best Practices, Career, DBA, Developer, Leadership, Professional Development, SQL Server 2012, Training
