Avatar of Jennifer McCown, MidnightDBA Guru

Follow Jennifer

Jennifer McCown, MidnightDBA Guru

Petri Contributor

LATEST

Cloud Computing

String Data Types in SQL Server: VARCHAR vs. CHAR

Last Update: Mar 11, 2024

Your database is made of data; data is defined by data types. Data types are so fundamental yet they’re often overlooked. In this article, Jennifer McCown answers a few of the most common questions on VARCHAR, CHAR and choosing string data types for your database.

View Article

Beginning SSIS: How to Create a Basic Data Load Package in SQL Server Integration Services

Step-by-step guide by Jennifer McCown on creating a basic data load package in SQL Server Integration Services. SSIS is used to extract data from sources such as SQL Server databases, flat files, Excel files, Oracle and DB2 databases, perform data manipulation and transformation, and deliver it to one or more data destinations.

View Article

Introduction to Indexes in SQL Server

Jennifer McCown covers the basics of indexing in SQL Server, one of the most effective and essential elements to an efficient database system.

View Article

How to Create and Edit a Report in SQL Server Reporting Services

In this installment of this SQL Server Reporting Services series, Jennifer McCown covers creating, formatting, and exporting SSRS reports.

View Article

SQL Server Reporting Services: An Introduction

An introduction to SQL Server Reporting Services (SSRS) by Jennifer McCown. With SSRS, an enterprise-level reporting solution, you can create, schedule, publish and manage a multitude of reports using a variety of data sources.

View Article

Introduction to the SQL Server Integration Services (SSIS) Development Environment

Jennifer McCown provides an introduction to SQL Server Integration Services (SSIS), with an emphasis on the SSIS development environment. SSIS is Microsoft’s full feature extract-transform-load (ETL) tool in SQL Server 2005, 2008, and R2.

View Article

Monitoring Your Database with SQL Profiler

SQL Server Profiler is a flexible profiling tool that comes with SQL Server. In this article, Jennifer McCown introduces the tool and details how to begin tracing database activity in your environment.

View Article