Category: News
-
Analyze & Visualize SQL Server Data w/ Power Pivot & Power View in Excel
Last updated 05-13-2017 In this tutorial we’ll use Microsoft Excel to retrieve data from our SQL Server database. We’ll then model, analyze and visualize the data using Excel’s Power Pivot and Power View features. Activate the Power Pivot & Power View add-ins Open MS Excel 2013\2016 Go to File > Options > Add-Ins In the Manage box, click COM Add-ins> Go…
-
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 applied to your SQL Server tables, and…
-
Building Your Web Presence – Makes Sense w/ Menelek Shah
In this episode of Makes Sense Radio Show, host Menelek Shah speaks with technology expert and IT consultant Wylie Blanchard who explains how and why you should have a professional web persona that helps you shine above the competition. This article was originally posted on MenelekShah.com. Makes Sense Radio Show “Makes Sense” is an audio podcast show…
-
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, SSIS, & C#,: Trizetto’s…
-
Become a Tech Pro who’s in High Demand: @GreatTechPros
Title: “Get a World Class Web Presence that Wows” Summary: Become a Tech Pro who’s in High Demand. Learn how to use the internet, social media and websites to market your technical expertise so that world knows that you’re a World Class Technology Leader. Abstract: It seems that almost anyone these days can build a…
-
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 migrations,…
-
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.
-
Interview with Edwin Ukpaby – Healthcare IT Professional: @Youtube
Edwin Ukpaby, Healthcare I T Professional and CEO of Medix Systems Consultants, met with us to discuss how technology in the healthcare industry has evolved with healthcare business processes. Originally posted at www.greattechpros.com. Excerpt from the Interview: Wylie Blanchard: I T is at a point where we have to be more than “you tell me the problem and…
-
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…
