Home /


Indiana Wesleyan University – Indianapolis 2016 – SQL Saturday #530

RT @GreatTechPros : @WylieBlanchard1 of @GreatTechPros at #SQLSatIndy session "PowerPivot Excel Analyze SQL Data http://lnkd.in/dE2VYzj Session Description: Using PowerPivot in MS Excel to analyze SQL Server Data Speaker(s):  Wylie Blanchard Duration: 60 minutes Track: BI Information Delivery Your end users want to analyze data in your data warehouse. Th...
Read More

SQLSaturday #523 & University of Iowa – Iowa City 2016

  Session Description: Capture Changes with SQL Server's Change Data Capture Speaker(s):  Wylie Blanchard Duration: 75 minutes Track: Application & Database Development Learn how to easily capture information about data changes – inserts, deletes and updates using SQL Server's Change Data Capture feature. Change Data Capture tracks INSERTs, UPDATEs, and DELETEs applie...
Read More

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

Support Desk Ticket Dashboard: @SpiceWorks

Heat Call Logging Dashboard - Support Ticket System A dashboard showing support tickets, top 5 queues, sla acknowledge rate, monthly/weekly inventory and monthly/weekly average days to resolve for heat call logging using pie charts, bullet/column graphs and spark line indicators. Originally posted on spiceworks.
Read 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...
Read More

Devry University – Chicago Suburban SQL Server User Group 2016

Capture Changes with SQL Server’s Change Data Capture Presented by the Chicago Suburban SQL Server User Group and Great Tech Pros presents:     Tuesday, February 16, 2016 6:00 PM DeVry University Downers Grove Center, 3005 Highland Parkway #100, Downers Grove, IL 60515       Subject: Learn how to easily capture information about data ch...
Read More

Find A Doctor – Mobile App: @SpiceWorks

Medical Provider Listing - Mobile Application Created back-end development to transform and import provider data in to SQL Server Database. Create backend process using SSIS, C#, T-SQL and FTP, Phynd Unified Provider Management (UPM) Platform. This was a team project combining the web development team and database development Team. I lead the effort for the database development team to create ...
Read 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 @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...
Read More

Thoughts on Technology from Martin Luther King: @Google+

In his 1964 Nobel Lecture at Oslo, Norway, Martin Luther King Jr reminded us to not let our "moral progress" fall behind our progress in science and technology. He said: "Yet, in spite of these spectacular strides in science and technology, and still unlimited ones to come, something basic is missing. There is a sort of poverty of the spirit which stands in glaring contrast to our scientific...
Read More