This is my fuel. This is why I teach. Sure, I won’t please everyone. Not everyone will appreciate or will be happy with the way I teach, but even if there’s one person in the class who thinks the time they spent in my class was worth it – that’s all the reason I need.
(All names removed from cards below)
This is what I got today from a student:
Windows 10 and Visual Studio 2015 have been released.
Microsoft claims Windows 10 as the best OS yet and Visual Studio 2015 has been enriched with ability to work on desktop, mobile (Windows, Android, and iOS), web and cloud applications and services. (It’s pretty sweet that there is a free Visual Studio Community version too!)
Here are some resources you’ll need to get started:
Once you have the tools and gears in place, have fun!
I feel quite lucky to be working where I work. One of the things I like about working at a university is having access to a number of learning opportunities, be it credit or not-for-credit courses, or even 1 or 2 hour sessions on anything. I love learning so it’s a field day for me when I get to attend these courses or events.
Conversations with Impact
One session I recently attended was “Conversations With Impact”. Ms. Joanna Piros,a senior consultant with Counterpoint Communications and also faculty at UBC Sauder School of Business’s Executive Education program, was the one who delivered the one hour session.
At the beginning of the session, Ms. Piros emphasized three (3) key statements about conversations:
1. All communication is strategic
2. You must frame others before you frame yourself (I didn’t know what media framing meant before I attended this session)
3. You must tell stories
This definitely struck a chord with me because one of the courses I teach, Visual Analytics with Tableau, also revolves around telling stories with data.
A couple of upcoming SQL Server events:
24HOP GOC 2015 (or 24 hours of PASS Growing Our Community 2015) is happening June 24-25, 2015. This event is a 24 hour event, with a session happening every hour delivered by SQL Server and Business Intelligence (BI) experts from around the world. The list of sessions are posted 24HOP 2015.
Application & Database Development
- Common Table Expressions – Advanced
- Database Design: Solving Problems Before they Start!
- Every Byte Counts: Why Your Data Type Choices Matter
- Introduction to Microsoft Azure DocumentDB
- Offline Database Development and Unit Testing with SSDT
- Protecting Your Data with Encryption
BI Information Delivery
- Introduction to the Power BI Designer
- Understanding and Visualizing Data Using R in SQL Server
BI Platform Architecture, Development & Administration
- Don’t Repeat Yourself – An Introduction to Agile SSIS Development
- Improving Data Analytics with Azure Machine Learning
- Optimizing your data warehouse for OLAP Processing
- Rethink your ETL with BIML
- SSAS Design and Performance Best Practices
- Cloud Application Development & Deployment
- Azure IOT: A Practical Introduction to Stream Analytics
Enterprise Database Administration & Deployment
- Common SQL Server Mistakes and How to Avoid Them
- Curious Cases of Availability Groups
- Data Pages, Allocation Units, IAM chains… Oh My!
- Overlord – tracking changes, real-time, in your environment
- SQL Server Agent: The life preserver for the drowning DBA
- The Art and the Science of Designing a Mission Critical SQL Server Solution
- The Data Loading Performance Presentation
- Trend Analysis of SQL Error Logs: Seeing Beyond the Error
- Turbo-Charged Transaction Logs
- Making the Leap from Developer to DBA
SQLSaturday #407 in Vancouver, BC
SQLSaturday #407 in Vancouver, BC is happening on June 27, 2015 at UBC Robson Square, 800 Robson Street, Vancouver. SQLSaturdays are one day free training events for SQL Server professionals. SQL Server professionals have developed a pretty tight knit community over the years, and this is one way of sharing information, learnings, experiences and best practices on the product. This event is also volunteer-driven – the organizers and presenters volunteer their time and effort to help foster the #SQLCommunity.
Sessions delivered range from SQL Server Administration, Development, Business Intelligence Application, Business Intelligence Delivery, and Professional Development.
Check out the schedules and sessions here: http://www.sqlsaturday.com/407/Sessions/Schedule.aspx
To back up your database to Azure BLOB storage, first you need to set up the BLOB storage in your Azure account. You will also need to create a container first.
You can back up the database to Azure by using either PowerShell or T-SQL.
We had to trace which among our hundreds of Blackbaud Enterprise CRM (BBEC) ad hoc queries were using Site from the Designation node. We also needed to figure out if they were being used as output or being used as filter.
Here’s the script that did the trick.
You’re a SQL Server DBA and you want to learn Windows Server Failover Clustering? On April 20, 2015 MSSQLTips is hosting an online training, and you can learn from SQL Server MVP and MCM (Microsoft Certified Master) Edwin Sarmiento. Check out the details here: