PowerShell to Pre-Create domain objects for SQL Server Cluster
Pre-Create Active Directory Virtual Computer objects to support a new SQL Cluster
2013-04-30 (first published: 2013-04-15)
580 reads
domain
RE: Calculate Last and First Day of the Month
Ain't date handling marvellous? All sorts of ways of "skinning the cat". My approach to getting the first day of the month and first of the next is as follows ... (I always use alpha for the month ... saves confusion).declare @today datetime select @today=getdate()select '01 '+substring(convert(char(11),@today,106),4,11), '01 '+substring(convert(char(11),dateadd(month,1,@today),106),4,11)01 Feb 2004 01 Mar 2004
2004-02-02
RE: SQL/Active Directory issue???
Maybe this would work: sp_grantlogin [@loginame =] 'login' sp_grantlogin sp_revokelogin Note that the SQL security account procedures and the NT security account procedures differ. If you got a snapshot of all of the logins/role membership/permissions for the NT accounts, and their NT account name has not changed, then you could scan through them and use […]
2003-12-01
Blogs
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...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers