Home / Posts tagged "Database Administration"

Database Administration

UIUC Gies Business highlights Wylie Blanchard

Photo by Erin Randle: Wylie Blanchard, Gies College of Business - University of Illinois
I was recently featured in an article by the University of Illinois, Gies College of Business, highlighting what I learned as a student in the school's Master of Business Administration (MBA) degree program and while attending global immersions in Germany and Brazil with my fellow MBA students. Here's an excerpt from the article titled "Blanchard Uses MBA Experience to Explore near-Shore Tech...

Discussion with Chris Hyde: Making a Difference with Data Analytics

Making Difference Data Analytics Full Episode: Chris Hyde
I met with Chris Hyde, SQL Server BI and Data Science Consultant to learn about his career as a data professional and his journey into data science. In this interview Chris shares how data can make a difference in people's lives, how there has been an increase use of statistics in data science and advice on how others can begin their career into data analytics. Here's the full interview: ...

Become a SQL Pro who’s in High Demand – Chicago IL 2018

EVENT UPDATE: The SQL Chicago community is always the best. I had a full house for this session and the audience participation was amazing. Feedback from the audience was that they enjoyed the discussion portion on scaling degrees and certifications to maximize the return on their investment. I didn't originally plan to share my views on scalability but I'll definitely include it in my next sess...

Remote DBA – Database Administration: @ SpiceWorks

Remote SQL Server Administration Managing several versions of MS SQL Server 2005-2014 Also managing Oracle 11g Managing and maintaining databases and servers for multiple clients - backups, log shipping, replication, mirroring, Always On availability groups, and clustering. Configuring and troubleshooting multiple versions of MS SQL Server – 2005, 2008, 2008 R2, 2012, 2014. Performing migratio...

Simple Audit of SQL Server Agent: @SpiceWorks

Who Changed My SQL Server Agent Job? Created process and ssrs report to audit changes to SQL Server Agent Jobs on SQL Server 2008 R2. Created process using SSRS, SSMS, T-SQL, SQL Triggers. Created and implemented process to audit changes to SQL Server Agent Jobs on SQL Server 2008 R2. Created a new schema and table structure to capture audit data for agent jobs. Created triggers on the sysjobs, sy...

SQL Server Enhancements for Developers: @SlideShare

Presence Health Partners - SQL Server Technology Enhancements for Developers - Wylie Blanchard
SQL Server Technology Enhancements for Developers – 2008 to 2012/2014 @SlideShare Your team is planning to upgrade from your SQL Server 2008 environment. Learn what’s new in SQL 2012/2014. Which features and enhancements are really important to the work life of a SQL Server Developer. In this presentation we’ll explore SQL Server 2012/2014 new possibilities, showing you how to use new T...

Managing OLAP Databases for DBA’s: @Google+

With the growing demand for Business Intelligence solutions it's important that DBA learn how to manage these (not so new) analytical engines to ensure that data is efficient and secure. In this session, we'll review Microsoft's SQL Server Analysis Servies Multidimensional (OLAP) engine. We'll review OLAP cube design, security, access permissions and other SSAS functionalty important to a da...

SpiceWorks Deployment: @SpiceWorks

Deployed SpiceWorks on Non Profit business server for network monitoring and help desk ticket management. Working with a new client with 150 employees and limited IT resources. Current IT team consists of just one engineer (knowledgeable engineer but overwhelmed with requests and fixes). Leadership asked if there was something that we can do about improving the management of help desk requests. R...