Generate Login Script(2008R2 And Older)
Generate Script from Logins of Sql Server to recreate in another instance
2015-08-25 (first published: 2015-08-10)
1,781 reads
Generate Script from Logins of Sql Server to recreate in another instance
2015-08-25 (first published: 2015-08-10)
1,781 reads
Using Powershell, Cleanup Older than 30 days of Files & Folder through SQL Job
2015-08-24 (first published: 2015-08-04)
2,663 reads
A script to help you cleanup Files/Folders & Sub-folders.
2015-08-20 (first published: 2015-07-30)
89 reads
In this article, I would like to demonstrate about Filestream and FileTable implementation in SQL Server 2012.
2015-08-19 (first published: 2015-07-24)
1,633 reads
This script was designed to help make importing data from any SQL2008+ database to an APS much easier.
2015-08-12 (first published: 2015-07-14)
1,155 reads
2015-08-10 (first published: 2015-07-16)
1,613 reads
List Out All User Defined Triggers, along with the database where the triggers are disabled. is_ms_shipped = 1 denotes that its an user written trigger.
2015-08-06 (first published: 2015-07-07)
867 reads
If you have a requirement to Kill all USer Sessions before starting to restore a Database, you may use this script
2015-08-05 (first published: 2015-07-08)
2,168 reads
2015-08-04 (first published: 2015-07-08)
732 reads
2015-08-03 (first published: 2015-07-12)
1,389 reads
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