Search this site

Who's this guy?

Paul Olson

I work with a SAAS provider as the SQL Server Database Administrator (DBA) and I provide SQL Server consulting services to small business and fortune 200 companies. I've been working with database technologies in a variety of flavors for over ten years.


 SQL Distractions

 Smart Sheets

239days since
SQL Saturday KALAMAZOO

Sprawl Blog

  • SSIS hates varchar(max) While attempting to populate a SSIS string variable with the result set from a stored procedure that returns a varchar(max) value, you will get this error:   Error: 0xC002F309 at ...
    Posted Sep 4, 2012, 1:20 PM by Paul Olson
  • Change Owner of an Object in SQL Server So I have this custom app that was built by an unknown a few years ago and it is mission critical! Oh and great news; it assigns ownership to db ...
    Posted Aug 30, 2012, 7:25 AM by Site Admin
  • How To Create A Logfile Viewer in 15 minutes This is what I have been looking for...Sweet!
    Posted Aug 29, 2012, 10:44 AM by Site Admin
  • SQL Saturday 160 Kalamazoo 2012 SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Sep 22 2012 at Kalamazoo Valley Community College ...
    Posted Aug 24, 2012, 9:02 AM by Paul Olson
Showing posts 1 - 4 of 7. View more »
 
 

My T-SQL Stuff

  • CREATE SP - Exchange Object Owner IF exists (select * from sysobjects where id = object_id(N'[dbo].[sp_ExchangeOwner]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[sp_ExchangeOwner] GO   SET QUOTED_IDENTIFIER  OFF    SET ...
    Posted Aug 30, 2012, 7:13 AM by Site Admin
  • Create default user accounts USE masterGODECLARE      @ExitCode varchar(255)                          -- return code      ,@WindowsUser varchar(55)      ,@MSSQLUser varchar(55)      ,@MSSQLPass varchar(55)      ,@JobAction nvarchar(255)           SET @WindowsUser ='<username>'      SET @MSSQLUser ='<username>'      SET @MSSQLPass  ...
    Posted Aug 24, 2012, 1:05 PM by Paul Olson
  • SELECT Backup History Details /************************************************************************************************* Purpose:    Simple: Most Recent Database Backup for Each Database in HistoryDetails: db name|Backup Start and end|Backup size|Physical location|Hours since last BackupWritten by: Paul Olson ...
    Posted Aug 24, 2012, 6:51 AM by Paul Olson
  • SP: List the row count of all tables in the database in descending order /************************************************************************************************* Purpose: To list the row count of all tables in the database in descending order. Output can be restricted to top n tables. That is you can pass the value ...
    Posted May 12, 2011, 9:31 AM by Paul Olson
Showing posts 1 - 4 of 4. View more »


PASS Chicago SQL Server User Group
Empower the global Microsoft SQL Server and Business Intelligence community to connect, share, learn and be inspired through networking, knowledge sharing, peer-based learning, and the ability to influence the direction of Microsoft SQL Server data platform.
PASS is an independent, user-led, not-for-profit organization co-founded by Microsoft and CA in 1999. It was created to build a body of individuals that would provide expertise to help educate millions of SQL Server users around the world. PASS is run by volunteers and operates globally through its websites, sponsored events, yearly Summits, and localized Chapter activities.
  
 
SQL Stuff
A collection for MSSQL DBA's including Scripting, Smart Sheets and Solutions.

Documents
A collection of useful documents concerning SQL Server and collateral targets.
 

Help Desk
If you have any questions at all about SQL Server just let me know!
I really enjoy working with SQL Server technology and supporting our awesome community.
I can’t promise you that I’ll always be able to answer all of your questions myself
but I can certainly get you heading in the right direction.



Subpages (3): Calendar Contact Sprawl Info