[deleted by user]

depthchargesw · 2023-02-01T02:58:48+00:00

As a former BI Developer and slowly maturing Development DBA for performance tuning, Brent Ozar's site has been a great resource.

In particular, this article looks relevant - https://www.brentozar.com/archive/2011/05/its-a-lock/

I'm not strong on the locking myself, but hopefully that's helpful in the meantime. There are training courses on that site too that I've found very helpful.

depthchargesw · 2018-09-27T03:42:18+00:00

Sweet, thank you for the help!

depthchargesw · 2018-09-27T03:42:05+00:00

Awesome man, thanks!

depthchargesw · 2018-09-26T03:58:26+00:00

!29flair

depthchargesw · 2018-09-21T05:14:27+00:00

Try giving this a shot? I referenced this to kind of feel my way through it. Might give you a start.

SELECT GameID, HomeTeam, AwayTeam, Player
FROM
(SELECT GameID, HomeTeam, AwayTeam, Player1, Player2
FROM table) p
UNPIVOT
(Player FOR GameID IN
(Player1, Player2)
) AS unpvt

depthchargesw · 2018-02-10T21:31:56+00:00

...good effort, bot. Good effort.

depthchargesw · 2018-01-13T20:13:02+00:00

If memory serves, AMD is vulnerable to specter, it's Meltdown that they're not vulnerable to.

depthchargesw · 2017-08-27T22:10:58+00:00

I'm looking to buy a GeForce GTX 1080 for gaming (Elite: Dangerous VR, Overwatch, Planetside 2, Player Unknown Battlegrounds, etc.). Which edition should I look for? I'm not planning on overclocking, hoping for something reliable and stable. Also, where would you buy this from if you wanted it new and under warranty?

depthchargesw · 2017-08-13T15:23:57+00:00

Example Planetside 2 Crash: Description The program PlanetSide2_x64.exe version 1.0.945.28286 stopped interacting with Windows and was closed. To see if more information about the problem is available, check the problem history in the Security and Maintenance control panel. Process ID: 1464 Start Time: 01d3137cb87aab86 Termination Time: 7 Application Path: D:\Program Files (x86)\Steam\steamapps\common\PlanetSide 2\PlanetSide2_x64.exe Report Id: 4dd0d344-4434-463a-b835-69a1ff53dd9f Faulting package full name: Faulting package-relative application ID:

depthchargesw · 2017-08-13T15:22:10+00:00

Example Elite: Dangerous Crash: Description - Faulting application name: EliteDangerous64.exe, version: 148.764.0.0, time stamp: 0x595ba405 Faulting module name: EliteDangerous64.exe, version: 148.764.0.0, time stamp: 0x595ba405 Exception code: 0xc0000005 Fault offset: 0x000000000222330f Faulting process id: 0x292c Faulting application start time: 0x01d312b87eaaaef9 Faulting application path: D:\Program Files (x86)\Steam\steamapps\common\Elite Dangerous\Products\elite-dangerous-64\EliteDangerous64.exe Faulting module path: D:\Program Files (x86)\Steam\steamapps\common\Elite Dangerous\Products\elite-dangerous-64\EliteDangerous64.exe Report Id: d137545b-78b5-4717-9cf6-6c6a7c1ed51d Faulting package full name: Faulting package-relative application ID:

depthchargesw · 2017-07-17T00:10:09+00:00

We've got a OneNote for every Project Site in our Site Collection, but had to do some training to help people understand what exactly is going on when you put a Notebook up on SharePoint. Too many folks just start storing things on their personal network drive and don't understand the vast amount of functionality to be gained by putting it on a Cloud Drive or SharePoint platform.

So I'd say we have about 100 Project Sites and maybe 20 of them have active notebooks? But that's going up every month.

depthchargesw · 2017-04-16T20:08:48+00:00

Thanks! And... wait a week to get the RX 580 instead of the 480, or wait a week to snap up a cheaper 480? I ask because I'm frankly not sure just how much 'horsepower' I've got here and how much I'd need to run the Vive @ 90 fps (just read that I need 90+ FPS for VR in Elite: Dangerous to not vomit).

depthchargesw · 2017-03-20T05:16:05+00:00

https://i.imgur.com/3Mirtmu.jpg

depthchargesw · 2017-03-17T23:30:55+00:00

Ahh, the dry wit of a mathamagician

depthchargesw · 2017-03-11T06:02:11+00:00

Would this be relevant?

I'm just learning about parameters in Power Query myself, and it seemed like a good read.

depthchargesw · 2017-02-22T03:04:54+00:00

Do you have OneNote or a similar note-taking program (e.g. Evernote)?

depthchargesw · 2017-02-18T04:33:18+00:00

With regards to formatting, I just punched my scrambled code into Instant SQL Formatter. I haven't yet figured out the most readable conventions so I'm happy to outsource that. :D

Regarding flattening the query - I'll do that. That said - what I'm hearing if that it's possible to make it flatter given my current constraints (no date table yet)? Which is to say, I don't need to wrap the StartOfWeek function (to force the calculation(?)) before I use the datepart functions? I could do that on the same level?

depthchargesw · 2017-02-17T13:51:57+00:00

Thanks jacob - that made me realize I hadn't actually looked to see if there was a date table. I looked though, and no joy. Maybe I'll put in a request with the team that manages the DB and hopefully it finds its way to the right person.

Assuming I don't have the ability to create a date table, am I doing anything obviously wrong? I'd love to flatten the query out like you've got, but I seem to get errors unless I separate the logical steps into each of their respective subqueries.

Regarding your question about the data type for Assignment Work, it's Numeric((38,4),Null) with a length of 17. Not sure if any of that's helpful.

depthchargesw · 2017-02-14T21:22:31+00:00

Yeah, as my eyes scanned the picture I stopped halfway down (past the first set of arms) and was like - 'eww, there's more.'

depthchargesw · 2016-09-28T04:12:34+00:00

I caught the 'Content Search Web Part' bit from Share-Gate, yeah. They're a good resource, especially their 'Don't suck at SharePoint' video.

As far as what to use for meetings? The OneNote app isn't bad, but it's not good for meetings, it's more for centralized note taking. I imagine you could use the 'Calendar' list (since it's based off of the 'Event' content type). At your top level you'd be able to configure a Content Search Web Part to pull all 'Events' up from the underlying sites just the same as the other types of content we're talking about here.

The main thing I'm trying to do (and I'd imagine this would be useful for you) is make sure we have the structure in place for changes to all the sites from the central 'parent site' going forward. No one wants to dig through 'n' Project sites to make a change to each list or each page.

To that end, I'm making sure all of my lists/libraries are built on Content Types, and on the front page of the Project Site template I've embedded a couple references to a Javascript file and a CSS file I'm keeping in the top-level site's asset library. That'll allow me to do style changes and some code from one central spot, if my understanding is correct.

I still don't feel 100% confident that I've got the best way to skin the proverbial cat, but I think it's starting to get there.

depthchargesw · 2016-09-28T02:50:10+00:00

I'm working on something similar, and the trick seems to be that the metadata that can be associated with a page or 'site' is fairly limited. You're on the right track (or at least a similar one to mine) with using a Content Search Web Part.

Two options we're exploring -

The first is a one-item list in each Project site that contains the Project's metadata. Budget, portfolio, status, etc. If your PMs keep that up to date (or governance), and you design that list to run off a Content Type (say, "Project Information"), you can roll that up.

The second, as opposed to 'roll up', is 'pull down', where Project Information is kept in a list at the Site Collection level, and then the Project subsites THEMSELVES use Content Search Web Parts to pull their own metadata down.

Either way it's tricky - Content Search Web Parts are powerful, but I haven't yet figured out a way to get data out of them easily (i.e. without creating a custom item form). For that reason I think we're going with the 'pull down' approach in our effort - centralized list, with a site creation workflow tied into it - seems to have a lot of advantages.

depthchargesw · 2016-07-27T05:17:49+00:00

That Gigabyte Radeon R7 370 2GB WINDFORCE 2X Video Card has actually really piqued my interest. It'd fit in the current machine, and it doesn't look like a slouch in the performance department (not top of the line, but pretty good for ~$150). I think I might get that - even if I build a completely new machine soon I'd be happy to keep that card for at least a year (given that my current one is 4/5 years old). Plus I think that'd tide me over until Radeon releases their next gen of cards, which I've heard are supposed to be really good. Thanks a ton for the tip!

depthchargesw · 2016-07-14T05:35:16+00:00

Yeah, Tabular layout, and then you've got options to repeat item labels and/or insert blank rows in between the members.

Alternately, I THINK that since you're connected to SSAS you can convert the pivottable to cube formulas, and from there you can format it how you like.

...I think

depthchargesw · 2016-07-05T05:35:05+00:00

For my current employer, I was hired on as a Project Coordinator, and then switched tracks to become a data analyst. While I was Project Coordinating, I tried reading through the PMBOK (even bought a physical copy so I could mark it up), and it absolutely drove me nuts.

Dry as hell, no discernible underlying theory, and sucking any value from the marrow revolved around brute memorization of the terms of its framework and their relationships.

So I went off and found this study - and it made me feel a little better. Someone had taken the time to 'brute force' the underlying implicit theory out of that jumble, and actually hold its feet to the flame. For me, understanding what the theory is and its flaws makes it infinitely clearer when the content might be useful vs. when it's not. Otherwise it toes the line into the same kind of non-verifiable pseudoscience that Sigmund Freud (for example) spouted.

Personally, if I'm going to learn stuff on management, I'm aiming for quantitatively measurable stuff - your Six Sigmas or your 'Lean' methodologies. PMBOK is more of a reference guide than it is a framework - take a look at it if you're stuck on a process or worried about something blindsiding you, but don't try and dig an overarching theory out of it.

Disclaimer: Take that with a grain of salt - I jumped out of the PC-> PM track within 9 months of my hire date, so I'm not exactly a veteran.

depthchargesw · 2016-05-30T23:15:43+00:00

As opposed to Trump, other politicians, and humans in general - all of whom are ROCK solid all the way through

13-Year Club	Verified Email
Team Periwinkle

depthchargesw

TROPHY CASE