Created by Camtasia 9

  • Configure SQL Server 2012 AlwaysOn Availability Groups Read-Only Routing using PowerShell
  • Configure SQL Server 2012 AlwaysOn Availability Groups Read-Only Routing using T-SQL
  • Configuring Transparent Data Encryption with SQL Server 2012 AlwaysOn Availability Groups
  • Enable SQL Server 2012 AlwaysOn Availability Groups Using Windows PowerShell
  • Analysis Services Administration
  • Clustering SQL Server Analysis Services Part 2
  • Troubleshooting Common SQL Server Analysis Services Connectivity Issues
  • Auditing and Compliance
  • SQL Server 2008 TSQL Auditing Commands for SELECT statements
  • Azure
  • Introduction to Azure PowerShell Modules for the SQL Server DBA Part 1
  • Introduction to Azure PowerShell Modules for the SQL Server DBA Part 2
  • Introduction to Azure PowerShell Modules for the SQL Server DBA Part 3
  • Introduction to Azure PowerShell Modules for the SQL Server DBA Part 4
  • Backup
  • Check for full SQL Server database backups before creating other backups
  • SQL Server backup and restore of the Resource database (7/21/2008)
  • Big Data
  • Introduction to PolyBase in SQL Server 2016 - Part 1 (11/2/2015)
  • Introduction to PolyBase in SQL Server 2016 - Part 2 (3/9/2017)
  • Clustering
  • Clustering SQL Server Analysis Services Part 1 (8/7/2015)
  • Configuring Volume Mountpoints on a SQL Server 2008 Failover Cluster running on Windows Server 2008
  • Fix SQL Server Agent on Windows Failover Cluster
  • Force Start a Windows Server Failover Cluster without a Quorum to bring a SQL Server Failover Clustered Instance Online
  • Install SQL Server 2008 on a Windows Server 2008 Cluster Part 1
  • Install SQL Server 2008 on a Windows Server 2008 Cluster Part 2
  • Install SQL Server 2008 on a Windows Server 2008 Cluster Part 3
  • Install SQL Server 2008 on a Windows Server 2008 Cluster Part 4
  • Installing, Configuring and Managing Windows Server Failover Cluster using PowerShell Part 1
  • Installing, Configuring and Managing Windows Server Failover Cluster using PowerShell Part 2 (9/4/2014)
  • Installing, Configuring and Managing Windows Server Failover Cluster using PowerShell Part 3
  • Installing, Configuring and Managing Windows Server Failover Cluster using PowerShell Part 4
  • SQL Server 2012 Multi-Subnet Cluster Part 1
  • SQL Server 2012 Multi-Subnet Cluster Part 2
  • SQL Server 2012 Multi-Subnet Cluster Part 3
  • SQL Server 2012 Multi-Subnet Cluster Part 4
  • Step-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster - Part 1
  • Step-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster - Part 2
  • Step-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster - Part 3
  • Step-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster - Part 4
  • Compression
  • Exploring Database Backup Compression in SQL Server 2008
  • Implementing Data Compression in SQL Server 2008
  • Database Administration
  • Configuring Windows Instant File Initialization for SQL Server 2005
  • Database Configurations
  • Check If a SQL Server Database Is In Pseudo-Simple Recovery Model Using Windows PowerShell
  • Database Consistency Checks DBCCs
  • Check DBCC CHECKDB Last Execution using PowerShell
  • Database Mail
  • An alternative to SQL Server email alerts
  • Database Mirroring
  • Automate SQL Server Database Mirroring Failover for Multiple Databases With No Witness
  • Implementing Database Mirroring in SQL Server 2005 across domains
  • Disaster Recovery
  • Disaster Recovery Procedures in SQL Server 2005
  • Isolating Critical Objects for SQL Server Disaster Recovery Procedures
  • SQL Server Partitioned Tables with Multiple Filegroups for High Availability
  • Using Page Level Restore as a Disaster Recovery Procedure in SQL Server 2005
  • Encryption
  • Implementing Transparent Data Encryption in SQL Server 2008
  • Express Edition
  • Automate SQL Server Express Backups and Deletion of Older Backup Files
  • High Availability
  • SQL Server Networking High Availability and Disaster Recovery Best Practices Webcast Q and A
  • Language Integrated Query LINQ
  • Creating LINQ to SQL Object Models using SqlMetal
  • Introduction to Language Integrated Query (LINQ)
  • Querying SQL Server databases using LINQ to SQL
  • Reading XML documents using LINQ to XML
  • Using Stored Procedures with LINQ to SQL
  • Log Shipping
  • Automate Restoration of Log Shipping Databases for Failover in SQL Server
  • Microsoft Excel Integration
  • Introduction to PowerPivot for Excel and SQL Server
  • Policy Based Management
  • Evaluate and Implement Policies in Multiple SQL Server Instances
  • PowerShell
  • Backup SQL Server Databases with a Windows PowerShell Script
  • Check SQL Server Virtual Log Files Using PowerShell
  • Check the Last SQL Server Backup Date using Windows PowerShell
  • Checking SQL Server Agent jobs using Windows PowerShell
  • Connect to SQL Server via Windows PowerShell with SQL Server authentication (
  • Determine Minimum Possible Size to Shrink the SQL Server Transaction Log File
  • Disable or Enable SQL Server Agent Jobs using PowerShell
  • Find SQL Server Instances Across Your Network Using Windows PowerShell
  • Generating SQL Scripts using Windows PowerShell
  • Introduction to Windows PowerShell for the SQL Server DBA Part 1
  • Introduction to Windows PowerShell for the SQL Server DBA Part 2
  • Retrieve a List of SQL Server Databases and their Properties using PowerShell
  • Retrieve Default SQL Server Backup Folder using PowerShell
  • Using PowerShell with SQL Server Management Objects (SMO) )
  • Reporting Services Configuration
  • Modify SQL Server Reporting Services Rendering Format In SharePoint-Integrated Mode
  • Reporting Services Installation
  • Install and Configure SQL Server Reporting Services 2012 SP1 and 2014 in SharePoint Integrated Mode Part 1
  • Install SQL Server Reporting Services 32 bit on a 64 bit Windows Server
  • Installing and Configuring Reporting Services 2012 SP1 or 2014 in SharePoint-Integrated Mode Part 2
  • Reporting Services Network Load Balancing
  • Build a Scale Out SQL 2008 R2 Reporting Services Farm using Windows NLB Part 3
  • Building a Scale Out SSRS 2008 R2 Farm using Windows NLB Part 4
  • Scale Out SQL Server 2008 R2 Reporting Services Farm using NLB Part 1
  • Scale Out SSRS R2 Farm using Windows Network Load Balancing Part 2
  • Reporting Services Performance
  • Highly Available, Scale-Out SQL Server 2008 R2 Reporting Services Farm
  • Scripts
  • Recursive Queries using Common Table Expressions (CTE) in SQL Server
  • Security
  • Extend the REVERT statement using the WITH COOKIE clause in SQL Server
  • Sharepoint
  • Installing SharePoint Foundation 2010 on a Single Server - Part 1
  • Installing SharePoint Foundation 2010 on a Single Server - Part 2
  • Rename SharePoint Content Database
  • Renaming the SharePoint Admin Content Database to Follow SQL Server Naming Conventions
  • Slipstream Office SharePoint Server 2007 Service Packs for Windows Server 2008 R2
  • SQL Server Configurations
  • Installing SQL Server 2012 on Windows Server Core Part 1
  • Installing SQL Server 2012 on Windows Server Core Part 3
  • Installing SQL Server 2012 on Windows Server Core Using PowerShell
  • Stored Procedures
  • Switching Stored Procedure Execution Context in SQL Server using the REVERT clause
  • Surface Area Configuration Manager
  • Using the SQL Server Surface Area Configuration Command Line Tool
  • Triggers
  • Using the EventData() Function with DDL triggers in SQL Server 2005
  • Upgrades and Migrations
  • Slipstream Service Packs and Cumulative Updates on a SQL Server 2008 Installation
  • Windows Internal Database
  • Administering your Windows Internal Database MICROSOFT##SSEE instance
  • Combining LDAP, SMO, DDE and CMS with PowerShell

    Restructuring your entire approach to SQL Server DatabaseMaintenance Practices, SQL Server Performance Tuning, SQL Log File Consolidation and Analysis as well as Auditing for Best Practices and Compliance Requirements will pay dividends now and in the future.

    Applying Consistent Design Principles

    Incorporating the various components of our solutions, including some or all of our 400 PowerShell Scripts and SQL Stored Procedures combined with SQL Management Objects (SMO) with all data extracts going directly into Excel Workbook Tabs in real time updated using Dynamic Data Exchange (DDE) is a winning combination that must be seen to be fully appreciated. Consistent, Predictable and Repeatable Results are what Auditors and Compliance Staff are striving for today.


    Benefits of Implementing Our PowerShell Based Consulting Services

    Creation of an Integrated and Consistent Solution to SQL Server Management

    • Adherence to Accepted Microsoft Best Practices for SQL Server
    • Consistently Addressing Data Governance, Compliance and Auditing Issues
    • Innovative Approaches to Automation of Database Maintenance Processes
    • Rigorous Consistency Applied to All SQL Server Properties and Settings
    • Usage of PowerShell with SQL Management Objects (SMO) and Excel Reporting
    • Optimization of the Viewing and Analysis of All SQL and Windows Logs
    • Adoption of the Central Management Server Tools, Methods and Techniques
    • Implement Single Click Sign-Ons for DBAs for Query Windows and RDP Access
    • Replacing Risks of SQL Server Exchange eMail with the SMTP Equivalents

    Research beyond the business plan

    Conveniently orchestrate goal-oriented collaboration and idea-sharing and visionary methodologies. Completely fabricate.

    Making a commitment to evaluating a PowerShell drive approach to SQL Server Maintenance Management will yield many benefits
    Investing the time to overcome the PowerShell Learning Curve will not take as much time as you might think. PowerShell techniques build on familiar scripting tools We provide the frameworks and templates to assist developers in converting legacy scripts into more powerful and dynamic PowerShell equivalents.

    Making a commitment to evaluating a PowerShell drive approach to SQL Server Maintenance Management will yield many benefits
    Investing the time to overcome the PowerShell Learning Curve will not take as much time as you might think. PowerShell techniques build on familiar scripting tools We provide the frameworks and templates to assist developers in converting legacy scripts into more powerful and dynamic PowerShell equivalents.

    Making a commitment to evaluating a PowerShell drive approach to SQL Server Maintenance Management will yield many benefits
    Investing the time to overcome the PowerShell Learning Curve will not take as much time as you might think. PowerShell techniques build on familiar scripting tools We provide the frameworks and templates to assist developers in converting legacy scripts into more powerful and dynamic PowerShell equivalents.