nlsimmons.com site navigationSkip to content
  • Education
  • Experience
  • Professional Skills
  • Recommendations
Search

nlsimmons.com

Professional Blog & Online Resume

My first DBA gig was with a start-up web marketing firm in the People's Republic of Boulder. Managing several production databases in an HA environment, I quickly expanded my knowledge of both Microsoft SQL Server and MySQL.

Next, I joined a team of DBAs for a leader in eDiscovery software. My unique position at the company allowed me to work very closely with both technology experts and the consumers of that technology. My efforts were focused mainly in the SQL development and mentorship arena, though I was also heavily involved with production DBA work as well. "Keeping the lights on," as it were.

In August 2012 I joined International Data Science Corporation, a start-up group of DBAs for hire. We are a team of highly committed DBAs with expertise in Microsoft SQL Server administration, development, and architecture.

I am most interested in development work and performance tuning and I always enjoy working closely with senior database professionals.

Configure SSL for SQL Server Reporting Services 2012

In this brief post I will show you how I created a self-signed certificate to be used when configuring SSRS…

Continue reading "Configure SSL for SQL Server Reporting Services 2012"…
9 Aug 2013

MSDTC, Triggers, and Firewalls. Oh my!

One Experience Troubleshooting Transactions Over Linked Servers The Backstory This client had been plagued by poor table and index design,…

Continue reading "MSDTC, Triggers, and Firewalls. Oh my!"…
1 Aug 2013

Redundant Indexes Part 1: Identifying Redundant Indexes That Are Not Used To Service Queries

Overview Indexes are a powerful concept in any RDBMS. They can dramatically increase the performance of queries, but they can…

Continue reading "Redundant Indexes Part 1: Identifying Redundant Indexes That Are Not Used To Service Queries"…
25 Jul 2013

Altering Stored Procedure Families Programatically

Alter every stored procedure in a database that fits a given criteria Recently I had to search for, and update,…

Continue reading "Altering Stored Procedure Families Programatically"…
29 Mar 2012

Signing CLR Assemblies

So you want to load a CLR assembly into SQL Server.  What’s that you say?  You DONT want to set…

Continue reading "Signing CLR Assemblies"…
6 Dec 2010 Comments: 0

Linked Servers: SQL Server 2005 to SQL Server 7

Today I had the pleasure of creating a linked server on our main production SQL Server 2005 instance. The catch…

Continue reading "Linked Servers: SQL Server 2005 to SQL Server 7"…
24 Nov 2010 Comments: 0

A Non-Trivial SQL CLR Table Value Function Example

Overview In this post I would like to demonstrate how to create a simple yet non-trivial CLR table-valued function (TVF).…

Continue reading "A Non-Trivial SQL CLR Table Value Function Example"…
18 Oct 2010 Comments: 0

Msg 14274, Level 16, State 1, Procedure sp_add_job

Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server. Recently I…

Continue reading "Msg 14274, Level 16, State 1, Procedure sp_add_job"…
13 Oct 2010 Comments: 0

Scripting Stored Procedure Permissions

Overview When scripting stored procedure code for deployment to several servers, there are a few things to keep in mind. …

Continue reading "Scripting Stored Procedure Permissions"…
6 Oct 2010 Comments: 0

How to Kill a Profiler Trace

Using Profiler to run a trace can be an invaluable tool for troubleshooting performance problems with T-SQL code. Occasionally something…

Continue reading "How to Kill a Profiler Trace"…
1 Oct 2010 Comments: 0
© 2023 nlsimmons.com. Powered by WordPress. Theme by WebMan Design. Back to top ↑