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,339 reads

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

249 reads

Blogs

A simple Machine Learning process example (supervised) – just to start with

By

I have just written the fifth article of the Machine Learning topic. !!! This...

Always On: Troubleshooting Consolidated

By

Working on Always On and configuration/setup of AG we have observed many errors. especially...

Changing Git Credentials in Windows

By

tl;dr For Windows when you need a different account. I had to work with...

Read the latest Blogs

Forums

SQL Server Version - Columnstore - Segment elimination

By etl2016

Hi From docs of MS, its not very evident, which SQL version (onwards) has...

How to set alert when AlwaysOn High Availabilty database stop synchronizing

By santosh.mane

Hi, We are having our production database on AlwaysOn High Availability, it sometime stopped...

SSRS page number by a certain column grouping

By Siten0308

Hello, I have been givin a task and not sure how to handle this,...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers