giveaway

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

Tutorials DBA Dev BI Categories Webcasts

DBA Dev BI Categories

Tim Cullen

google plus

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

Application Development

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

Cloud Computing

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

Dates

Add and Subtract Dates using DATEADD in SQL Server (9/30/2011)
Daylight Savings Time Functions in SQL Server (11/13/2007)
Determine SQL Server Date and Time with DATEPART and DATENAME Functions (10/17/2011)
SQL Server DateDiff Example (10/10/2011)
TSQL Function to Determine Holidays in SQL Server (7/10/2008)

Encryption

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

Functions - System

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

Import and Export

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

Install and Uninstall

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

Integration Services Configuration Options

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

Master Data Services

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

Microsoft Excel Integration

Import Excel 2007 data with SQL Server Integration Services (5/11/2010)

Performance Tuning

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

Reporting Services Filtering

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

Reporting Services Parameters

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

Security

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

Spatial Data Storage

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

SQL Server Configurations

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

StreamInsight

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

XML

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

More SQL Server Solutions