2014-08-11 (first published: 2014-05-28)
1,665 reads
Mitesh Oswal
Get the defination of all table type in database
THis script will generate the Drop and create script for all user define table type
2014-04-18 (first published: 2014-03-25)
1,189 reads
Get the Column level difference for 2 database
The query will help to get the column level difference for 2 database(Like Prod and Dev database). This help us to verify what are the column changes has been done in dev environment after Prod deployment.
2014-04-10 (first published: 2014-03-11)
1,032 reads
Get the all user and their server role
The script give you the list of all users and their respective Server roles
2014-04-02 (first published: 2014-03-11)
1,541 reads
Using Seqence Container instead of Identity
This script is an example of how to use Sequence, similar to Identity.
2014-03-24 (first published: 2014-02-25)
1,334 reads
2014-02-27 (first published: 2014-02-11)
1,877 reads
Get the all the tables on the server which do not have Clustered index
Get the list of the tables on the server which dont have the clustered index.
2014-02-24 (first published: 2014-02-17)
1,359 reads
Blogs
Setting up SQL Server 2022 s3 Object Storage Integration using MinIO with Docker Compose
In this blog post, I’ve implemented two example environments for using SQL Server 2022’s...
Daily Coping 12 Aug 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
My Toolbox - Greenshot
By Zikato
Foreword A picture is worth a thousand words. I use screenshots daily, whether it’s to...
Forums
GENERATE_SERIES Permissions
Comments posted to this topic are about the item GENERATE_SERIES Permissions
How to Visualize Python Charts in Power BI
Comments posted to this topic are about the item How to Visualize Python Charts...
Reducing Debt and Increasing Security
Comments posted to this topic are about the item Reducing Debt and Increasing Security
Ask SSC