i use this to enumerate all the members that belong to groups that have been granted access from AD:

i've found that some groups cannot be enumerated int he cases where...

excuse the neophyte question,...

as far as i know, filezilla, specifically, cannot be called from a command line or automated; it's a GUI tool;

i've used winscp.exe and psftp.exe (putty sftp) with script taskes/command executes;

i...

I've seen something similar, where a csv file was renamed to have an xls extension...so the file was not truely xls, so it could not be opened.

find the original file,...

a maintenance plan tends to use a shot gun approach: rebuild all indexes, regardless of whether they need to be rebuilt or not.

you are probably at that tipping point where...

there are a bunch of settings you can do in MySQL to improve the loading of flat files; back when i loaded that huge Ashley Madison dump for fun, i...

Steve i know you can easily get the data with the reserved characters escaped out wiht ampersand amp semicolon, would that be an alternative?

it depends on your data, but this...

I have this old snippet form a post from years ago.

both this and your example are non-sargable, meaning it's going to table scan for the values, which is what full...

I've used the answer below to get the Active Directory password policy via powershell:

https://blogs.technet.microsoft.com/heyscriptingguy/2014/01/09/use-powershell-to-get-account-lockout-and-password-policy/

import-module ActiveDirectory

Get-ADDefaultDomainPasswordPolicy

PS H:\> Get-ADDefaultDomainPasswordPolicy

ComplexityEnabled : True

DistinguishedName ...

also, does the table inside follow some sort of naming convention, but is dynamic?

for example a table named [Invoices_2016-02_14] from yesterday, but it's [Invoices_2016-02_15] from today?

if you can determine...

it's in...

I went deep, deep down this rabbit hole, and built a procedure that i can call from tsql .

tin the long run, you have to use the sys. schemas and...

not suspicious; it sounds like a missing GO statement between drop create procedure and drop/create function in someones script.

it happens to us all at some point

IF OBJECT_ID('[dbo].[sp_Bad]') IS NOT NULL...

if not too much time has passed, the default trace would have the DROP FUNCTION event, complete with whodunnit information; you might have an automated process, or someone may just...

easy fix.

if the function has no parameters, you still need the parenthesis for the parameter list.

alter FUNCTION [dbo].[fnPressGaneyDownload] ()

your function could easily be converted to an inline table value function,...