Category: Projects
-
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.
-
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…
-
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 UniversityDowners Grove Center,3005 Highland Parkway #100,Downers Grove, IL 60515 Learn more about the Chicago Suburban SQL Server User Group Subject:Learn how to easily capture information about data changes…
-
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…
-
SQL Server Enhancements for Developers: @SlideShare
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,…
-
Mobile SQL Server Lab: @SpiceWorks
Mobile build of a SQL Server Lab that I run on any computer/laptop. Recently saw a presentation on creating a Mobile SQL Lab on a LapTop. I already have one but it’s not great at running too many virtual machines, so I decided I’ll create a new lab with more power and that’s a little…
-
Implementing Failover Clustering and AlwaysOn Availability Groups: @Google+
In this webinar, Wylie introduces us to Implementing Failover Clustering and AlwaysOn Availability GroupsAlwaysOn… Availability Groups is a new feature that enhances and combines database mirroring and log shipping capabilities. Click here to register now Present by: Wylie Blanchard When: Friday, December 6th – 06:00pm Speaker Bio: Wylie Blanchard, MCSE is an IT consultant, SQL…
-
Database Backup Encryption: @Google+
Encrypting your database backup is an excellent method to protect database backups from unauthorized access. In this class: Wylie walks you through how you can implement database backup encryption directly from the database engine utilizing SQL Server 2014 (Third Party tools not needed). Click here to register now Presented by: Wylie Blanchard When: Friday, October…
