Technical Article

How to retrieve roles from a Database

If you have environment where you restrict access to database objects based on user roles and if you have a lot of databases on different servers in the same domain.  The following script can generate roles from a given database in a format that can be used to create roles on different servers where the […]

2003-05-14

174 reads

Technical Article

How to get Foreign keys

If you ever have been put in a situation where your database has a lot of objects and some of those do not have primary keys, trying to find feels like needle in the haystack.  I have modified the script contributed by Mr.Tandrei and Mr.Rahul sharma.  The following script gives all the tables that do […]

2003-04-17

138 reads

Blogs

Encrypting Your SQL Data Should be Your Default Option

By

Cyber-attacks and data breaches seem to be perpetually on the rise. Every week we...

Power BI Embedded: Using Row-Level Security for Multilingual Reports

By

Making multilingual reports in Power BI requires a lot of different elements. Translations can...

Daily Coping 29 Nov 2022

By

Today’s coping tip is to make a meal using a recipe or ingredient you’ve...

Read the latest Blogs

Forums

Sql table join help

By SQL Bee

I have 2 tables . tblStudentMarksOriginal - StudID, Subject, Marks 101, english, 91 101,...

Why do Sql Server In operator behaves differently and return nothing?

By mehmood

I am using sql server 2017. I am trying to use the in operator,...

Basic Checks on a New AWS RDS SQL Server

By Br. Kenneth Igiri

Comments posted to this topic are about the item Basic Checks on a New...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers