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)
27,196 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)
4,014 reads
2016-02-05 (first published: 2014-05-15)
3,259 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,681 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)
2,111 reads
Blogs
FDD 2023 – Session Materials
You can find the slides for my session at Future Data Driven summit at...
Quick Filtering in SSMS–#SQLNewBlogger
By Steve Jones
I saw someone limit the databases they see in SSMS, which isn’t something I...
Penetration Testing your SQL Server, Part 1 – The Recon Mission
Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking...
Forums
Convert Binary or Hex field to show text information
Hi all, I have an SQL database table with events, and within it a...
Write https request to azure blobstorage
Hi All, I have been trying to download a csv file which is produced...
High tempdb usage alternatives
Hi We have an stored procedure which runs frequently and it contain logic in...
Ask SSC