Category Archives: musings

More reasons why I teach

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:

card from studentcard content

Read more

Advertisements

Windows 10 and Visual Studio 2015 Jumpstart and Resources

Get Started. Design. Develop.Publish

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!

Conversations with Impact – the importance of stories

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

by Gareth Williams. Cuba - Havana Public Artwork. https://www.flickr.com/photos/gareth1953/15377856386/

by Gareth Williams. Cuba – Havana Public Artwork. https://www.flickr.com/photos/gareth1953/15377856386/

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.
Read more

Upcoming SQL Server Events – SQL Saturday #407 Vancouver and 24HOP

A couple of upcoming SQL Server events:

24HOP

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

Professional Development

  • 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.

Register now!

SQLSaturday #407

SQLSaturday #407

Check out the schedules and sessions here: http://www.sqlsaturday.com/407/Sessions/Schedule.aspx

Back up SQL Server database to Azure BLOB Storage

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.
azure blob storage and container
You can back up the database to Azure by using either PowerShell or T-SQL.
Read more

Determining Blackbaud Ad Hoc Queries that use Site in Designation

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.
Read more

MSSQLTips: Windows Server Failover Clustering for the SQL Server DBA

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:
http://www.mssqltips.com/sqlservertraining/3/windows-server-failover-clustering-for-the-sql-server-dba/

« Older Entries