Home / Posts tagged "Databases"

Databases

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

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

Developing Business-Driven Self-Service BI – New York

Continued from SQLSaturday #588 – New York City 2017.EVENT UPDATE: What an amazing audience at SQL Saturday NYC. Things started off shaky when we encountered technical issues with the video projector at the start of my presentation. After a few minutes of working with the AV staff we decided to cram into a nearby conference room with a working projector and after grabbing a few ...
More

SQL Saturday Chicago 2017

Analyzing SQL Server Data using PowerPivot in MS ExcelSpeaker(s): Wylie BlanchardDuration: 60 minutesTrack: BI Information DeliveryYour end users want to analyze data in your data warehouse. They could deal with the learning curve of SSAS but they'd prefer to utilize a familiar application like MS Excel. Welcome, PowerPivot, a tool that retrieves data from your data warehouse b...
More

Chicago SQL BI User Group March 2017 – @CNUG_

Upcoming event:  Self Service BI With a Tool End Users Already Know & LoveSpeaker(s): Wylie BlanchardDuration: 60 minutesTrack: BI Information DeliveryYour end users want to analyze data in your data warehouse. They want it yesterday and they want to do it themselves so that it’s done “right”. Welcome, PowerPivot, a tool that analyzes data from your data warehouse by combini...
More

PCP Member Eligibility Secure Email

Automated, Hippa Compliant, system to email member eligibility lists to Primary Care Physicians. Trizetto's QNXT™ Enterprise Core Administration System & ASM's MD-Staff - Credentialing. Created an automated, HIPAA compliant, process to securely batch and distribute member eligibility lists to PMG/non-Presence PCP's on a monthly basis via individual PCP email addresses.Utilizing SQL, SS...
More

Remote DBA – Database Administration: @ SpiceWorks

Remote SQL Server Administration Managing several versions of MS SQL Server 2005-2014Also managing Oracle 11gManaging 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...
More

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

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 @SlideShareYour 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...
More
Top