Script DB Level Permissions v4.6
Script database and object level permissions for all database users
2021-06-21 (first published: 2021-06-11)
20,537 reads
Script database and object level permissions for all database users
2021-06-21 (first published: 2021-06-11)
20,537 reads
Script database and object level permissions for all database users
2017-07-25 (first published: 2016-02-26)
15,717 reads
Use SSIS to pull data from multiple instances. Combine with powershell to run multiple instances simultaneously.
2015-02-23
8,649 reads
Easily register SQL Servers in your inventory to your CMS for easy multi-server queries.
2014-08-18
5,787 reads
2014-01-24 (first published: 2010-11-02)
27,368 reads
Automate patch installations using the task scheduler and command line hotfix options for SQL.
2011-05-03
4,765 reads
Simple script formatting the date and naming a backup file path for a t-log and restoring those logs.
2010-12-29 (first published: 2010-12-15)
1,534 reads
A way to handle application releases involving multiple scripts and/or multiple databases.
2010-08-23
6,829 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers