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)
30,701 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,168 reads
2016-02-05 (first published: 2014-05-15)
3,271 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,694 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,214 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
The Load of Real Time Data Warehouses
Comments posted to this topic are about the item The Load of Real Time...
Data Migration Assistant Targets
Comments posted to this topic are about the item Data Migration Assistant Targets
How to Delete Large Amounts of Data in Microsoft SQL Server
Comments posted to this topic are about the item How to Delete Large Amounts...
Question of the Day
Data Migration Assistant Targets
In the current (2024) version of the Data Migration Assistant, which on-premises targets are available?
See possible answers