Script All Logins / Users / and Roles
This Script Generates A script to Create all Logins, Server Roles, DB Users and DB roles on a SQL Server.
2016-11-02 (first published: 2013-10-31)
14,754 reads
Script move of DB files from one location to another
Generates Scripts to move DB files from one location to another SQL and powershell scripts
2016-04-11 (first published: 2014-03-19)
2,921 reads
2016-02-05 (first published: 2014-05-15)
3,207 reads
Paginating a SQL query result set
How to Paginate a query result set to keep from pulling the whole result set to the client side
2015-11-02 (first published: 2014-05-05)
3,638 reads
Caching and paging a SQL Result Set
This is an example of how to Cache Query results on the Server side
then page though the results
2014-06-06 (first published: 2014-05-05)
1,765 reads
Blogs
Daily Coping 30 Nov 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Building a Raspberry Pi cluster to run Azure SQL Edge on Kubernetes
A project I’ve been meaning to work on for a while has been to...
SQL Server login – default database and failed logins
This is one of them little options that I see which quite often gets...
Forums
How to use While Loop to Insert Book details where status is not null?
I work on SQL SERVER 2012 . I face issue I can't use While...
SQL server night cpu usage
Hi using MS SQL maintenance plan to update statistic with full scan. The plan...
Find matched records between two tables
Hi, I haven't been able to find anywhere how to do or which transformation...
Ask SSC