Timothy A Wiseman

Timothy A Wiseman is a Database Administrator for SAIC with a focus on efficiency and readability of the database and its surrounding ecosystem. In addition to administering the core SQL Server system, he has experience working with Python and Microsoft Access in conjunction with SQL Server. He holds a Bachelor's of Science in Mathematics as well as an MCDBA and MCITP.

Interests: SQL Server, Python, Go, Mathematics, Legal Issues

Variable Scope in SQL Server

by Timothy A Wiseman

SQLWise

The way variable scoping works in SQL Server has been well documented on MSDN, but I have seen related issues...

2013-01-18

2,804 reads

A really simple Multiprocessing Python Example

by Timothy A Wiseman

SQLWise

Purpose and introduction A Python program will not be able to take advantage of more than one core or more...

2012-12-21

4,719 reads

Playing with Cython

by Timothy A Wiseman

SQLWise

Intro Recently, I came over Cython and started experimenting with it. After some basic testing, I found several things of...

2012-11-23

1,158 reads

Class and instance variables in Python 2.7

by Timothy A Wiseman

SQLWise

The differences and interactions between class variables and instance variables are well described in the Python 2.x documentation, but they...

2012-10-06

2,338 reads

Some Jargon from the SQL Server World

by Timothy A Wiseman

SQLWise

Not long ago I wrote about how to write well about SQL Server, and one major point was that jargon...

2012-09-04

1,118 reads

The effects of an SSD on SQL Server Performance

by Timothy A Wiseman

SQLWise

I. Introduction A little while ago, my wonderful wife Renee got a Solid State Drive (SSD) for me. Being a...

2012-07-29

5,675 reads

New articles posted.

by Timothy A Wiseman

SQLWise

My article Plotting SQL Server Data for Data Visualization is up on MSSQLTips now and discusses using PyQt and Matplotlib...

2012-07-21

813 reads

Writing About SQL Server

by Timothy A Wiseman

SQLWise

I. Introduction I recently submitted my entry for a writing competition as part of my continuing education. While I was...

2012-07-09

1,412 reads

Blogs

Migrate datetime data to datetimeoffset with AT TIME ZONE

I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...

The Comprehensive Guide to Mastering Your SQL DBA Skills

By Tracy McKibben

Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...

Friday Basics: Authentication vs. Authorization

By Brian Kelley

Another security fundamentals topic is authentication versus authorization. For those who have a clear...

Read the latest Blogs

Forums

The OS returned the error '(null)' while attempting 'DeleteFile' filestream.hdr

I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...

Take Care

By Grant Fritchey

Comments posted to this topic are about the item Take Care

Performance

Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...

Visit the forum

Question of the Day

Two Table Hints

What happens when I run this code:

SELECT
  p.ProductName
, p.ProductCategory
FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);

See possible answers