Tags » Databases

Parse Sql Extended event for Login Audits

SELECT
CONVERT(VARCHAR(19),DATEADD(mi, DATEDIFF(mi, GETUTCDATE(), CURRENT_TIMESTAMP),
xevents.event_data.value(‘(event/@timestamp)[1]’,’datetime2′)),120) AS ,
–xevents.event_data.value(‘(event/action[@name=”session_id”]/value)[1]’, ‘int’) AS ,
DB_NAME(xevents.event_data.value(‘(event/action[@name=”database_id”]/value)[1]’, ‘int’)) AS ,
–xevents.event_data.value(‘(event/action[@name=”server_principal_name”]/value)[1]’, ‘nvarchar(max)’) AS ,
xevents.event_data.value(‘(event/action[@name=”client_app_name”]/value)[1]’, ‘nvarchar(128)’) AS ,
xevents.event_data.value(‘(event/action[@name=”client_hostname”]/value)[1]’, ‘nvarchar(max)’) AS , 124 more words

Databases

American Chemical Society announces intention to establish “ChemRxiv” preprint server to promote early research sharing

WASHINGTON, Aug. 10, 2016 — The American Chemical Society (ACS) today announced its intention to form ChemRxiv, a chemistry preprint server for the global chemistry community, proposed as a collaborative undertaking that will facilitate the open dissemination of important scientific findings. 553 more words

chemlibrarian reblogged this on Chemistry Library blog and commented:

What do chemists think about this? Let me know!

Dawsonera maintenance - Thursday 25th August

Dawsonera will be unavailable for up to half an hour between 07:30 and 08:00 on Thursday 25th August due to essential maintenance work.

Dawsonera will be offline during this time and… 59 more words

Databases

Databases to Help Jumpstart Your Legal Research Quest

Welcome back!  This is one of the most exciting times of the semester.  All possibilities are open and everything is new.  Soon, you will need to start researching; whether it’s for class, papers, or journal comments, the search for information will begin.  468 more words

Legalresearch

Turn SCCM SQL Queries into Web Reports

The goal of this exercise is to add custom reports to your Configuration Manager site so you can dazzle executives while you sneak out the door.   1,473 more words

Technology

PlumX Now Available on Health Information @ Himmelfarb!

PlumX is now available via Health Information @ Himmelfarb.  Health Information at Himmelfarb is the search tool that appears on the library’s homepage, and PlumX provides metrics so users can track different types of usage for individual articles. 61 more words

Databases

Creating lifelong information seekers

On a library instruction email list I read, there was a recent discussion that included an interesting point: when we teach the use of databases to college students, it’s both worthwhile and in line with our mission of producing lifelong information seekers and users to note that once students graduate, they can often access databases through their public libraries. 257 more words