Reputation
631
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
4 14
Newest
 Yearling
Impact
~9k people reached

4h
answered When Should You Shrink Your Database
2d
reviewed Reviewed Find all tables that are related to a view recursively sql server
2d
reviewed Reviewed how to insert into tables in sql server?
2d
comment how to insert into tables in sql server?
Hi @user3159060, this question is getting down voted because you haven't stated what you've tried yourself to resolve this before asking a question. The error message is fairly simple and states the duplicate key DAMASCUS cannot be inserted into the governorate table. Have you checked to see if this row already exists? This is probably something you can resolve yourself pretty quickly.
2d
reviewed No Action Needed How can I setup a Login which can run an automated Database Refresh without giving away too much priv?
2d
reviewed Reviewed MS SQL Server 2014 has vulnerabilities
May
21
awarded  Yearling
May
21
reviewed Reviewed Ambiguity in Auto Create\Update Statistics
May
21
comment SQL self join with condition
The reason I used a table instead of a temporary table is MySQL's limitation which prevents you from accessing the same temporary table twice in one query. You might be able to achieve the same thing using a temporary table and creating one or more copies of that table.
May
20
comment What is the most effective way to discover all running instances of SQL Server using PowerShell?
That's usually because the service runs as a user which isn't a domain admin or local system (required to create SPN). The domain admin has probably added SPNs using the SetSPN utility and their domain admin account, so that domain auth works properly for these machines. So likely, yes.
May
20
reviewed No Action Needed Nested set model: retrieve sub-tree containing nodes that match condition
May
20
comment Backing up SQL Jobs for an Instance
@Kin perhaps this depends on your SSMS version, I'm pretty sure they're not in older versions at least.
May
20
comment Backing up SQL Jobs for an Instance
Note that when you script jobs from SSMS, this does not include schedules. You'll be able to recreate the jobs but will need to add schedules again.
May
20
answered migrate db's - best way to mirror or replicate a full database
May
20
reviewed No Action Needed PostgreSQL query - works locally but not on AWS RDS
May
20
comment Unable to restore database backup becouse it is accessed by other connection
@Kin, I don't understand, how does waiting for 5 seconds prevent other users from connecting to the database?
May
20
awarded  Custodian
May
20
revised Select Column value based on two values in another column
added 9 characters in body
May
20
reviewed No Action Needed Generate rows based on value in 2 columns. Bug?
May
20
revised Select Column value based on two values in another column
Added example.