Eugene Bereznuk


Technical Article

Grant permissions to a role

A very simple script that will first create a role (if it does not exist yet) and then grant full permissions on tables, views and stored procedures to the newly created role. Of course, you can add any filtering (i.e. grant permissions only for tables beginning with "abc") or grant partial permissions (SELECT or DELETE […]

You rated this post out of 5. Change rating

2002-09-26

1,070 reads

Technical Article

Random string and random number generators

The first part will create 2 stored procedures with self-explanatory names. The second is a standalone SQL that may be used in any stored procedure, script or DTS package.The generated string does not have any spaces and include only lower-case letters. To include anything else just change the boundaries for ASCII codes in the script.The […]

1 (1)

You rated this post out of 5. Change rating

2002-09-26

543 reads

Technical Article

Find circular references in single table

The objective is to find circular references in a single table related to itself. The script deals with a sample table Skills that have a SkilGUID (primary key) field and a SkilParentGUID field which is a foreign key to the record's parent from the same table. The number of levels in the hierarchy is not […]

3.67 (3)

You rated this post out of 5. Change rating

2002-09-24

1,012 reads

SQLServerCentral Article

Relational Database Without Relations

The strength and holy grail of relational databases lies in the very name: relations. Microsoft has put a good deal of intelligence and cunning into query optimizations, caching, indexing and execution plans to make the process of finding related records even smoother and faster. This small article, however, will try to shatter the very sacred notion of relational databases.

1 (2)

You rated this post out of 5. Change rating

2002-07-29

8,121 reads

Blogs

Blogging for the Tech Professional at Denver Dev Days

By

For those that attended my talk at Denver Dev Days, here are the slides:...

Getting AI Written Unit Tests

By

As a part of my AI experiments, I decided to ask CoPilot to write...

A New Word: Slipfast

By

slipfast adj. longing to disappear completely; to melt into a crowd and become invisible,...

Read the latest Blogs

Forums

Software Flexibility (Avoiding the next hack)

By Louis Davidson (@drsql)

Comments posted to this topic are about the item Software Flexibility (Avoiding the next...

Roles on tempdb

By cphite

A co-worker asked me a question today and I couldn't come up with an...

Delayed tcp acknowledgement registry setting

By Rasmus Remmer Bielidt

Our IT department contacted me recently and asked if they should change the default...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers