Game

External Article

My month with Release!

  • Article

Alex and his team are developing a game about software and some of the people who make it. He looks at how games affected his office culture, what he’s learned about designing games to do more than just be fun, and how his team are hoping to share their passion with the developer community.

2014-06-20

3,352 reads

External Article

The SQL of The Game of Life

  • Article

Joe Celko finds a reference to Conway's Game of Life while clearing out his desk, and is suddenly gripped with nostalgia. It wasn't just flares, mullets and disco, but simple computer games in interpreted basic. Somehow, Conway's Game of Life was too intriguing to be abandoned in the attic. Can it be implemented in SQL? Joe sets up a challenge.

2014-06-16

2,958 reads

Technical Article

RE: Restore Log in SQL Server 2000

  • Reply

Paul,While in the Restore database dialog, click on the options tab, and select"Leave database nonoperational but able to restore additional transaction logs."for all but your last restore.  When you restore your last transaction log backup (the one with the "point in time" that you are restoring to), then select "Leave database operational.  No addtional transaction […]

You rated this post out of 5. Change rating

2004-09-08

Technical Article

RE: How to export Resultset from cursor to excel

  • Reply

Interesting problem. I think what you want to do is loop through a series of departments and call a DTS package to email the results. At least that's what I'd do. Here's a looping example: http://www.sqldts.com/?246 Or my choice, use one package to loop and call another inside it: http://www.sqldts.com/default.aspx?215.

You rated this post out of 5. Change rating

2004-09-07

Technical Article

RE: Sending Mail without Outlook or MAPI

  • Reply

I was having the same problem until someone told me that they were using a trigger on the msdb..sysjobhistory table to accomplish the failure notifications, I implemented it myself and it works great...it give the job name in the subject and the error message in the body of the email. The script below is the trigger, […]

You rated this post out of 5. Change rating

2004-05-12

Technical Article

RE: Error inserting records into Sybase from SqlServer via Linked Server

  • Reply

Ok, solution found !,We needed to call 'openquery' to do the insert, the following code is an example of how it was done;insert openquery(SERVERNAME, 'select field_1,field_2, field_3 from tablename') values (getdate(),'FINISHED', 'sql')This appears to work ok, with Sybase generating the Identity value as per any normal insert into the Sybase Db, returning no errors to SqlServer.Regards.j

You rated this post out of 5. Change rating

2004-05-12

2 reads

Blogs

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers