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 […]
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.
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…
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′
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…
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…