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)
8,105 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,547 reads
2016-02-05 (first published: 2014-05-15)
3,181 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,613 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,643 reads
Blogs
Accelerated Database Recovery in SQL Server 2019: Choose your own filegroup for the version store
An exciting new feature in SQL Server 2019 is Accelerated Database Recovery (ADR). Resulting...
Adding SQL Change Automation to Jenkins for Database CI
By Steve Jones
In a previous post, I explained how to get Jenkins running in a container...
DevOps for the DBA, Slide Deck
I have an all day seminar I give called “DevOps for the DBA”. If...
Forums
User datareader access problem
I went to give a user (via AD account) datareader access to a number...
Slower performance on SQL.
We are moving from one SQL server to newer SQL with better hardware. Both...
Different Execution plan and performance issues in SQL 2017 compare to SQL 2012
Hello All, We have recently migrated SQL2012 express edition to SQL 2017 express edition...
Ask SSC