Roy Carlson


SQLServerCentral Article

Running a Query Using a Text File for Input

When automating administrative actions for SQL Server, there are a number of ways to handle the workflow. Longtime SQL Server DBA Roy Carlson brings us a technique for using a text file as input to the standard SQL Server tools.

4.5 (2)

You rated this post out of 5. Change rating

2008-01-14 (first published: )

20,296 reads

Technical Article

Monitoring File Sizes in SQL Server Part 3

Trending the size data for your databases can be crucial when ordering new hardware or just ensuring that you can handle the load. In Part 3, Roy Carlson looks at how you get the sizes needed for your instances into Excel and generate a chart for trending of this important piece of performance data.

You rated this post out of 5. Change rating

2006-11-08

5,932 reads

Technical Article

Monitoring File Sizes in SQL Server Part 1

Monitoring the file sizes and free space on your SQL Server can be done in a number of ways, but it needs to be done or you will get a phone call when you least expect it. In an interesting read, Roy Carlson brings us a great way with code and reporting to setup your own monitoring system.

You rated this post out of 5. Change rating

2006-11-06

11,880 reads

SQLServerCentral Article

No Outlook for Alerts!

SQL Server 2000 has a fantastic subsystem for alerting the DBA and keeping him or her informed as to the state of the server. However the email subsystem introduces a dependency on Outlook for alerts that can be a problem for some environments. Author Roy Carlson brings us an ingenious method for reading logs and sending alerts without Exchange or Outlook.

You rated this post out of 5. Change rating

2005-09-12

12,487 reads

SQLServerCentral Article

Scripted Server Snapshot

Users call and complain and by the time you get to the server, everything looks fine. Even running Profiler sometimes doesn't capture the information. Author Roy Carlson found a solution, a script that you can give to users to dump whatever information you need to an Excel file.

You rated this post out of 5. Change rating

2005-07-12

8,678 reads

SQLServerCentral Article

You Want To Do What, with MY Database?

SQL Server 2000 is an extremely powerful and flexible development platform, but if the users mess up the data, there's nothing you can do. Protecting the integrity sometimes means severely limiting access to users. Roy Carlson brings us a technique using sp_makewebtask that you can easily use to provide users with some data without giving them query access.

5 (2)

You rated this post out of 5. Change rating

2005-05-17

15,048 reads

SQLServerCentral Article

Know Your Data

Or at least the types of your data. New author Roy Carlson was working in SQL Server 2000 to calculate some values based on row counts, sales amounts, etc. and discovered some interesting results. Without his sharp eye, a number of individuals would have been upset by the resulting lack of commissions, as may some of your clients. Read about some potential problems in your calculations if you are not careful with your data types.

You rated this post out of 5. Change rating

2005-04-04

6,656 reads

Blogs

MVP No more, But It’s OK

By

Embracing Limitations: Finding Strength and Purpose in Hard Times For four years, I was...

A New Word: Fitching

By

fitching – v. intr. compulsively turning away from works of art you find frustratingly,...

Copilot in Microsoft Fabric

By

Microsoft Copilot is an app that uses AI to help you find information, create content,...

Read the latest Blogs

Forums

needing to insert 2 sets of numbers to a table to use as ranges for another quer

By roy.tollison

the ranges (a lot) need to have a preset spacing between each set of...

log shipping switchover and switchback

By coolchaitu

I have log shipping in my environment. Could you please let me know steps...

TSQL Help, Possible a recursive CTE

By erics44

Hi I have 2 tables Table A JoiningID, MainID 1010619, 646703 991840, 238649 991840,...

Visit the forum

Question of the Day

What's Wrong with this Table?

What's wrong with this code and causes an error?

CREATE TABLE Customer
(
    CustomerID INT NULL,
    FirstName NVARCHAR(50) NOT NULL,
    LastName NVARCHAR(50) NULL,
    Email NVARCHAR(100) NOT NULL,
CONSTRAINT CustomerPK PRIMARY KEY (CustomerID, LastName)
);


See possible answers