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)
32,165 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,232 reads
2016-02-05 (first published: 2014-05-15)
3,276 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,700 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,234 reads
Blogs
Build a C++ Pipeline with Docker, GitHub Actions, Azure ACR and Azure App Service
In today’s Software Development Life Cycle (SDLC), having a robust build pipeline is very...
Better Trigger Design: #SQLNewBlogger
By Steve Jones
I had someone ask me about using triggers to detect changes in their tables....
SQL Server in the Cloud – Are DBAs Still Needed?
By Kevin3NF
Things your cloud vendor may not tell you Here’s a common theme I...
Forums
Dropping a PK constraint.
I will have to test this next week, but will not have a chance...
SQL - Conditional merge join
I want to add a condition in the joining columns part of the merge...
Is there a way to implement ROWS between logic?
Hi everyone SUM function has the option to select ROWS BETWEEN parameter to allow...
Question of the Day
What is Between?
I have a table of products in SQL Server 2022. There are sequential items in the table with ProductIDs of 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. If I run this code, how many rows are returned?
SELECT * FROM dbo.Products WHERE ProductID BETWEEN 4 AND 7;See possible answers