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,358 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

253 reads

Blogs

Daily Coping 27 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Daily Coping 26 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Seeding an Availability Group Replica from Snapshot

By

Background If you’ve been using Availability Groups, you’re familiar with the replica seeding (sometimes...

Read the latest Blogs

Forums

Upgrading SQL Server 2008 R2 to 2017

By stinger27

Do you guys recommend upgrading SQL Server 2008 R2 to 2017 by just running...

why I cannot see memory related waits while server is under pressure?

By radekg

Hi, It may be trivial question but I am really confused at this moment....

SSC "Points" ?

By homebrew01

What generates the "Points" we have in our profile ? I just reported a...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers