Redgate invite you to participate in their survey on database modeling. In order to inform their future product decisions, they'd like to better understand the needs and motivations behind the use of such tools.
2019-04-08
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
2009-05-19
12,792 reads
Entity-Attribute-Value model (EAV) is used interchangeably with name for name value pair. This article will try to address advantages and disadvantages of EAV modelling
2008-03-24
6,590 reads
Hi Sushila,suser_sname() prints the same user as user_name().Here is my trigger:CREATE TRIGGER [track_time] ON dbo.ATTENDEES FOR UPDATE AS UPDATE ATTENDEES SET timestamp1=GETDATE(), User_name1 =suser_sname() FROM ATTENDEES JOIN deleted ON ATTENDEES.FTKey=deleted.FTkey AND ATTENDEES.Day1<>deleted.Day1
2005-05-30
I think there is a problem with SQL Server Provider on your machine first install MDAC 2.7 and its SP1 then install SQL Server SP3a I hope this help u
2004-04-19
Does anyone knows how to execute a exe file from SqlServer ( Stored Procedure / Dts / Job ) ?ThanksHM
2004-01-20
3 reads
Thanks for your reply, Darren. Before you replied, i opted for decimal. Is there much (if at all any) difference between numeric and decimal that you know of? I have tried to read BOL, but can't seem to see a major difference between them.
2003-07-01
I agree that security is getting tougher (wait, it was always tough!). I'm hoping that the tool vendors will fill in the gaps. Locking down the enviroment is fairly mechanical, it's just there are so many different places. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-06-23
1 reads
This is a file being uploaded by a user. I co not know what the field names are going to be. A more complete solution for me actually would be to somehow grab the first table (non-system) in the Access database, but I am not sure how I can do that. Any guidance would be […]
2003-05-14
In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential...
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers