Jon Smithson @AskSQL

WSFC for SQL AG - one node in another subnet fails validation for network comm. but passes all FW validations. Ideas? #SQLHELP

In Profiler, I saw an SP suddenly take 30s to finish (normally 200ms range) but it also shows CPU, Reads and Writes as 0. Clue? #SQLHELP

In SQL AG: Datacenter D1 has 2 nodes + 1 FSW. Datacenter D2 has 1 node on diff subnet. Would this setup work? Or D2 needs 2 nodes? #SQLHELP

What is the best way to consume XML provided by REST service in #SSIS? Should entire XML file be downloaded first then parsed? #SQLHELP

Any reason the same SP would run a lot slower as an RPC called vs a SQL Batch (as it appears in Profiler)? #SQLHELP

Stuck trying to move out a Cluster Core Resource (Name/IP) from inside a Role. Accidentally Assigned it to a Role #SQLHELP

I accidentally moved the Cluster Name/IP from Cluster Core Resource to a particular role's. Can you move that back? #SQLHELP #Win2012R2

Win2008R2. Can I force start cluster on my 1 offsite DR node? All other nodes are in HQ (simulated as gone) incl FSW. #sqlhelp

When connecting to listener in an AG, should @@servername show the listener name rather than the actual node SQL instance name? #SQLHELP

Anyone seen sp_executesql throw a FK conflict but if I run the query outside of sp_executesql with same params then it works? #SQLHELP

A 3rd party app is using dynamic SQL and open to SQL injection. Cannot change the app unfortunately, any suggestions? #SQLHELP

#SSIS 2012 deployed as project.Runs fine if executed from catalog.If as agent job, it says "no column info returned by SQL command" #sqlhelp

Need to encrypt string using AES256 with key & IV provided by another party.Can I do this straight in #sqlserver ? Without CLR? #SQLHELP

Changing SQL Service & Agent to use new AD account. Agent failed to initialze SQL Agent log and won't start. Any way to sync perms? #SQLHELP

10 PROD servers + 10 more for TEST. For service account, do you use AD Account for each indv server? Or per env? Common practice? #SQLHELP

Permissions on folder look same but somehow SQL cannot write to folder. Anyway to sort of resync permission on folder for SQL? #SQLHELP 2/2

Data drive had issues so I stopped SQL & moved folder somewhere then new drive added (same drive letter). SQL is not starting #SQLHELP 1/2

Anyone using Win2012R2 getting the SCSI VPD error when validating for WSFC? support2.microsoft.com/kb/2531907 Says I "don't have inquiry data" #SQLHELP

In #SSRS RB3, I'm trying to select a shared data source. Default will show the http://realservername/...Is there a way to use FQDN? #SQLHELP

Is there a way to rename an AG listener name? Same IP and all, but just wanted to rename. #SQLHELP