Tags » Databases

Don't Use PubMed as a Journal Whitelist

PubMed is not MEDLINE. I recommend against using PubMed as a list of quality journals for the purposes of finding a journal to publish in, evaluating academic performance, awarding grants and degrees, and assessing job candidates. 538 more words

Scholarly Open-Access Publishers

Christian Velten reblogged this on TrapperPhD's Outpost and commented:

I frequently met colleagues in pharma industries, which did not even knew that PubMed is a limited source for bio-medical publications. What a pity ... and what a risk for the departments those colleagues are working in. This post by "Scholarly Open Access", a quite proficient blog on scientific literature sources, points out the tiny little (but quite important) difference between free PubMed and its professional sibling Medline.

PowerShell: Export-CmReports.ps1

Another I glued together today for a lab project.  No error trapping, weeeee!

 Export-CmReports exports SCCM SQL RSP reports to RDL files in
 a specified location

 3-character site code

 NetBios hostname of SCCM RSP host

.PARAMETER ReportFolder
 Name of logical SSRS report folder, or "ALL" to export all folders
 Default is "/" which is not recursive

.PARAMETER OutputFolder
 Path location where RDL files will be exported
 Default is $USERPROFILE\Documents

 Written by: David Stein
 Date Create: 10/19/2016

 Export-CmReports -SiteCode "ABC" -HostName "CM1"
 Export-CmReports -SiteCode "ABC" -HostName "CM1" -ReportFolder "My Custom Reports" -OutputFolder "C:\Temp"
 Export-CmReports -SiteCode "ABC" -HostName "CM1" -ReportFolder "ALL" -OutputFolder "C:\Temp"

function Export-CmReports {
  param (
      $ReportFolder = "/",
      $OutputFolder = "$($env:USERPROFILE)\Documents"
  $url = "http://$HostName/ReportServer/ReportService2010.asmx?WSDL"
  Write-Host "connecting to SSRS web service..." -ForegroundColor Cyan
  $ssrs = New-WebServiceProxy -Uri $url -UseDefaultCredential -Namespace "ReportingWebService"
  if ($ReportFolder -eq "ALL") {
    $folders = $ssrs.ListChildren("/ConfigMgr_$SiteCode", $False) | ?{$_.TypeName -eq 'Folder'}
  else {
    $folders = $ssrs.ListChildren("/ConfigMgr_$SiteCode", $False) | ?{$_.Name -eq "$ReportFolder"}

  if ($folders.Length -gt 0) {
    foreach ($folder in $folders) {
      $fname = $folder.Name
      $fpath = $folder.Path
      $reports = $ssrs.ListChildren("$fPath" , $False)
      if ($reports.Length -gt 0) {
        Write-Host "Folder: $fName : $($reports.Length) reports" -ForegroundColor Cyan
        $OutPath = "$OutputFolder\$fName"

        if (!(Test-Path $OutPath)) {
          md $OutPath -Force
        foreach ($r in $reports) {
          $reportName = $r.Name 
          if ($r.Hidden -eq $True) {
            Write-Host "skipping hidden report: $reportName" -ForegroundColor Gray
          else {
            Write-Host "reading: $reportName..." -ForegroundColor Green
            $def = $ssrs.GetItemDefinition($r.Path)
            $stream = ::OpenWrite("$OutPath\$reportName.rdl")
            $stream.Write($def, 0, $def.Length)
            Write-Host "exported: $reportName successfully!" -ForegroundColor Green
      else {
        Write-Host "no reports were found" -ForegroundColor Cyan
    } # foreach
  Write-Host "done!"
} 20 more words

The Blockchain by a Quant

Yesterday by the night I was still busy at work and thinking about future projects. And so one of my tasks was to check the video I present here today of an interesting Webinar. 385 more words

List of Databases on an Instance of SQL Server

To find how many databases in SQL Server.

There are ways to identify databases in any version SQL Server.

Solution 1:

Using SQL Server Management Studio. 96 more words


Making Users into Agents (A Persistence Layer Takes Shape)

This is mainly a post about Domain Objects, specifically World, Agent, and User, and how they interrelate in Merchants and Traders of Splorr!!

The users come from the ASP.NET Identity stuff, and so their definition is quite typical. 816 more words