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)
11,183 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,580 reads
2016-02-05 (first published: 2014-05-15)
3,189 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,627 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,695 reads
Blogs
Using Google Chrome with SSRS
In this post, you will learn how to resolve the Kerberos Double-Hop issue and...
Friend of Redgate 2020
By Chris Yates
Last week I was excited to receive an email from Redgate notifying me that...
Azure Database for PostgreSQL
By Arun Sirpal
Having worked with Azure SQL Database and its many flavours for couple of years...
Forums
Question on restoring a backup
Hi, I am not that knowledgable on backups and the files that they create,...
Regular Expression help - Does (.) Mean new line?
Hi there I am re-writing some code which uses regular expressions Part of...
SQL AG Secondary Database Backup Throwing "not supported" error with COPY_ONLY
Hello. I am using SQL Server 2016 with 2 Node AG. There is no...
Ask SSC