Jan Potgieter

Jan has years of experience in Information Technology which ranges from Unix Administration through System Administration and development, Web and Database Development and Administration and applying Agile methodologies.  Jan has been working with databases since 1996 when he had his first exposure to Sybase databases. He got involved with SQL Server in the early 2000’s and had exposure to SQL Server 2000, 2005, 2008 and all the rest.  Jan likes to find easy and secure ways to host data and has been using Sybase, SQL Server, and MySQL.  He has a great passion for working with data and believe the best way to become an expert in a field is by teaching the subject.
  • MSSQLTips Awards: Rookie of the Year Contender - 2022
Title Category Date
Enable TDE for Databases in a SQL Server AlwaysOn Availability Group Availability Groups2026-06-02
Download and Install Visual Studio 2022 for Data Professionals Reporting Services Development2026-05-10
Install SQL Server 2022 Standard Edition Install and Uninstall2026-04-09
SQL Server Database Security – Logins and Users Security2025-06-17
QR Code Reading Application using SQL Server and Web-Based Application Application Development2024-01-30
Utilize QR Codes from SQL Server Data and a Web App Application Development2024-01-22
Troubleshoot SQL Server Blocking and Resolving with NOLOCK Locking and Blocking2023-09-05
QR Code Generator Web Based App that uses SQL Server Application Development2023-07-19
QR Code Generator with SQL Server and Web App Application Development2023-05-31
How To Transfer Data from MySQL to SQL Server Other Database Platforms2023-01-24
How to add a Report Server Project to a Visual Studio Solution Reporting Services Development2023-01-04
Database Projects in Visual Studio Solution Application Development2022-12-13
Developing a Web Application with ASP.NET and SQL Server Application Development2022-11-15
SQL Stored Procedures, Views and Functions Examples Stored Procedures2022-10-18
Indexing in SQL Server with Clustered and Non-Clustered Indexes Indexing2022-10-12
SQL Server CRUD Operation Examples TSQL2022-09-15
Create SQL Server Database Tables, Foreign Keys and Data Database Design2022-08-18
Create Table SQL Server with Foreign Key Constraints Database Design2022-08-09
Create Table SQL Server Step by Step Database Design2022-07-28
Large SQL Server Error Log using Excessive Disk Space Error Logs2022-07-19
Create Database SQL Server with SSMS or T-SQL Database Design2022-07-05
Encrypt and Decrypt Data Files with an SSIS Package using GnuPG Integration Services Development2022-06-09
Encrypt and Decrypt a CSV file with SSIS Integration Services Development2022-05-11
Export Data to Excel from SQL Server Integration Services Package Integration Services Development2022-04-15