LessThanDot Site Logo

LessThanDot

A decade of helpful technical content

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary.

Browsing "aws"

Streaming Alerts using AWS Lambda, Kinesis, and DynamoDB

Recently I was talking to some friends about alerting on complex streaming data. Between some past event processing work we had done and earlier experience aggregating real-time manufacturing data, I was thinking a lot about projecting and evaluating results as we go versus querying the for results on some frequency. It seemed like a realistic […]

Read More...

Bring SQL Server databases Online or Offline when running on Amazon RDS

To bring a SQL Server database online or offline you can use a command like the following if your database is named test.

ALTER DATABASE test SET OFFLINE;

ALTER DATABASE test SET ONLINE;

When running SQL Server on Amazon’s Relational Database S…

Read More...

Turning on Optimize for Ad hoc Workloads, Ad Hoc Distributed Queries and more on a AWS RDS SQL Server Instance

There are several advanced options that you can modify in SQL Server.If you want to turn on optimize for ad hoc workloads in SQL Server, one way is to run the following scripts

EXEC sys.sp_configure N’optimize for ad hoc workloads’, N’1′
RECONFIGURE…

Read More...

How to read the error log on an Amazon RDS SQL Server instance

Earlier today, i created an Amazon RDS SQL Server instance, you can check out that post here: Trying out Amazon Relational Database Service
I decided to take a closer look, the first thing I wanted to know is if I could see the error log. There are two…

Read More...

Trying out Amazon Relational Database Service

Since it is a day off for me today, I decided to give Amazon Relational Database Service a try. Amazon RDS has SQL Server, Oracle and MySQL as databases available.

You can try it out for free if you are a new AWS customer
Amazon RDS for SQL Server…

Read More...