Pedro Sr


Technical Article

Synchronize the DB user SID with the Login SID

If you attach a DB on an SQL Server different from the SQL Server where the DB was initially created, you will usually come up with a situation where a login will be a DB user however, you cannot see this through the login properties screen. That happens because the name of the login exists […]

2005-04-21 (first published: )

1,366 reads

Technical Article

Change the probability of the pseudo-random values

The usual practice, when we need some test data, is to employ the pseudo-random built-in function RAND(). We usually use it to produce a random value in some range and it produces these values with the same probabilities. Sometimes we need more "realistic" data when some values are more probable than others are. In this […]

5 (1)

2002-10-04

256 reads

Blogs

Speaking at SQLSaturday MN 2022

By

Thanks all for joining me for two sessions at SQLSaturday Minnesota 2023, and for...

Goal Progress for Nov 2022

By

I set goals at the beginning of the year, and I’m tracking my progress...

PGSQL PHRIDAY #3: What is the PostgreSQL Community To You?

By

Very excited to take part in my third #PGSQLPhriday blogging event, even more so...

Read the latest Blogs

Forums

Table has no data but query takes 20 secs to complete

By vsamantha35

Hi All, I have come across one issue today and I am looking for...

The DAX Text Contatenation

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The DAX Text Contatenation

Amazon EC2 | Creating a Connection to an Amazon RDS Instance

By Br. Kenneth Igiri

Comments posted to this topic are about the item Amazon EC2 | Creating a...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers