It’s been a while since I blogged (life got busy!), and am quite surprised to see that some of the posts I had are still getting traction. I guess some issues still persist – perhaps in slightly different forms, but the way we solve or tackle them remain the same.
Excited to share many things since I last blogged, but one of the biggest ones happened in the last couple of months. With the pandemic I had to switch to teaching exclusively online, and really re-think how I deliver my classes.
I’ve decided to try a new avenue to teach – YouTube! I’ve started my channel – sqlbelle’s data adventures – and hoping this can provide value and/or inspiration to those trying to learn data and technologies like Tableau and SQL Server. It’s been fun, but definitely requires commitment.
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.
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:
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.
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
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.
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. Continue reading →
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.
Many students who register for Part Time Studies are working professionals who are taking courses to complete additional certificates/diplomas, or for professional development, or just plain curious.
Students enrolled in the COMP 2256 class learn visual best practices, some data analysis, and visualization using Tableau Desktop. Part of this twelve (12) week course is a term project which requires data analysis and visualization around a topic of their choice. They will need to submit a series of dashboards and a final project report at the end of the term.
The project requires the students to either:
look for a sponsor (could be their employer, a non-profit organization, etc) for their visual analytics project, to be presented to their peers at the end of the term
look for a number of sizable public data sets that they’re interested in, and essentially create dashboards that will support their story
I encourage students to, as much as possible, choose #1. This is as “real world” as it gets. However, looking for a sponsor can become tricky and time consuming for already-working professionals, so I am hoping I can help match up my students to your projects.
I really liked the @Always #LikeAGirlSuperbowl XLIX halftime commercial. For me, it doesn’t really matter whether you’re male or female. But it is sad that there are still prejudices out there based on gender (among other things), but I hope it won’t stop anybody from trying – to live, to grow, to learn, to reach your dreams, and to do the best you can with anything that you do.