@billinkc I can understand how a column name like EmployeeDataXML can be helpful in a query as an indication of the column type, but in the generated XML a tag with XML in the name looks funny.
Hi @ JamesZ thanks for reply, i am using Godday and it difficult to do as you mention at least i may don't have that experiences, but if it can be as a text then it can be easier one time before i do it but i couldn't remember how it was it just few click by mouse into ms sql — Alfred yesterday
Hello. I've heard that SSMS was about to be separate part from SQL server. but I heard from a colleague that they don't do it at the end and it will keep be a part of MSSQL server installation. Is it true ?
And for the record, the WITH syntax will work as well after removing the from dual. The VALUES syntax is just more concise. Would have been great if WITH data AS (VALUES ...) SELECT * FROM data worked, but alas, it doesn't.
If I have Get-EventLog -LogName Security -Newest 10 | select index,TimeGenerated,EntryType,Source,InstanceID is there a way to add in some static values there?
I have a PS script I'll be running from SQL Agent. It requires functions defined in a second set of scripts. Is there a well known place one installs PS scripts so you can reference/use them without having to do the explicit path import thing?
@billinkc yes you can use PSModulePath environment variable
if you wanna import it as a module
otherwise Path env. variable
if it's me though and it's gonna get run from SQL Server I would pick a set path on the machine like c:\PSScripts and you can make sure it's on all the servers for DR purposes
@JNK Ah, yes, that helps me at least figure out what the default search space would be. Challenge is this would be something we're delivering to clients so I think working within the existing PS locations would be easier.
I suppose I could just cheat and make a monolithic script too
If you are running full backups as well as transaction log backups (and you should if you consider this data important) you could just copy over the backups and transaction log backups to the test system and perform a point in time restore to restore the databases to +- the same time.
Depending ...
my solution is messy and Kin's would be better, but the requirements keep changing and magic is expected
@swasheck I only have experience with an insanely rich customer but it's for tempdb and buffer pool extensions and we didn't run into failure (yet) so no
If I use the original table definition (pointed at tempdb for an instances called localhost\dev2014) it works fine. I can see the ServerName column in my datatable yet when it writes to the table, it blows chunks
@TomV that's fine. it's a large gun that the BAs use to blow our feet off. clickanddrag clickanddrag ... no training needed! why is the database so slow??
@TomV ah. but corporate politics say that we must :).
so in a roundabout way, politics allow me to keep drawing a paycheck for doing the exact same thing. it's become habitual enough that i'm able to do the habit while learning new things on the side :)
@swasheck I had a few cards fail suddenly but they were replaced quickly and not had an issue since. Bad batch of hardware I think. Was three years ago as well.
@swasheck None of the Fusion-io cards at my current gig (purchased 2013+) have failed. Lots at my previous gig (purchased around 2010 I think) did according to the datacenter engineering group.
WHy?
For what it's worth the performance difference between Pure and Fusion-io hasn't been huge. We get lower latency out of the Fusion-io cards until we top out on throughput, but the latency difference might not be big enough to matter.
Of course we probably have them installed in the wrong PCI slot and smart stuff like that.
@JamesLupolt just disaster planning. our pure numbers are generally better for everything except large, sequential reads (as expected). consultant said to put tempdb on fusionio and so we did, in spite of my evidence pointing to the contrary.
