Tim Cullen

Tim has been working in the IT industry since 2003. After spending a few years as an "IT Generalist", his career focus turned to SQL Server and application development. He currently works as a SQL Server Reports Developer for an application team in Atlanta, GA. Prior to entering the IT workforce Tim worked in the healthcare industry.

2013 Awards
MSSQLTips award

Amazon AWS

Introduction to the Amazon Relational Database Service (last update: 4/8/2013)

Application Development

Data Access Object (DAO) and Visual Basic.NET to create an Access database interrogation tool (last update: 10/8/2010)

Dates

Add and Subtract Dates using DATEADD in SQL Server (last update: 3/31/2018)
Daylight Savings Time Functions in SQL Server (last update: 11/13/2007)
Determine SQL Server Date and Time Parts with DATEPART and DATENAME Functions (last update: 5/24/2019)
SQL Server DateDiff Example (last update: 10/10/2011)
TSQL Function to Determine Holidays in SQL Server (last update: 7/10/2008)

Encryption

Managing SQL Server Master Keys for Encryption (last update: 8/20/2007)
Natively Encrypting Social Security Numbers in SQL Server 2005 (last update: 11/30/2007)
SQL Server 2005 Encryption Certificates Overview (last update: 8/29/2007)
SQL Server Encryption Key Management between Dev, Test and Prod (last update: 2/17/2009)

Functions - System

Using SOUNDEX and DIFFERENCE to Standardize Data in SQL Server (last update: 11/16/2010)

Import and Export

Importing DBF files into SQL Server (last update: 8/3/2011)

Install and Uninstall

SQL Server 2008 Installation Process (Part 1 of 3) (last update: 2/2/2009)
SQL Server 2008 Installation Process (Part 2 of 3) (last update: 4/13/2009)
SQL Server 2008 Installation Process (Part 3 of 3) (last update: 5/1/2009)

Integration Services Configuration Options

Getting the SSIS package store to work with a SQL Server named instance (last update: 4/9/2009)

Master Data Services

Configure web application permissions for SQL Server Master Data Services (last update: 7/23/2010)
Introduction to Master Data Services in SQL Server 2008 (last update: 6/4/2010)
SQL Server Master Data Services Installation and Database Creation (last update: 6/25/2010)

Microsoft Excel Integration

Import Excel data with SQL Server Integration Services (last update: 5/11/2010)

Performance Tuning

Getting IO and time statistics for SQL Server queries (last update: 5/31/2007)

Reporting Services Filtering

Dataset and tablix filtering in SQL Server Reporting Services (last update: 1/27/2012)

Reporting Services Parameters

Custom control and setup of SSRS report parameters from a web page (last update: 5/14/2009)

Security

Extended Protection available in SQL Server 2008 R2 (last update: 9/1/2010)

Spatial Data Storage

Data storage and retrieval for geospatial data in SQL Server 2008 (last update: 1/22/2010)
Geography Markup Language for Geospatial Data in SQL Server (last update: 12/20/2010)
SQL Server 2008 Geography and Geometry Data Types (last update: 9/29/2009)
SQL Server 2008 Spatial Index Performance (last update: 4/2/2010)
SQL Server Geography Data Type (last update: 3/18/2010)

SQL Server Configurations

Configure MaxTokenSize for SQL Server Authentication (last update: 8/8/2008)
SQL Server Name Resolution Troubleshooting (last update: 1/28/2008)
Windows Integrated Authentication Failures to SQL Server (last update: 8/21/2008)

StreamInsight

Microsoft SQL Server 2008 R2 StreamInsight Installation (last update: 8/26/2011)
Microsoft SQL Server 2008 R2 StreamInsight Overview (last update: 8/19/2011)

XML

SQL Server XML Bulk Loading Example (last update: 3/5/2010)

Tutorials DBA Dev BI Career Categories Webcasts Scripts Today's Tip Join

Tutorials DBA Dev BI Categories Webcasts

DBA Dev BI Categories

Tim Cullen

More SQL Server Solutions