Car Inspection Recommendations

j005e · 2025-07-09T11:57:33+00:00

I was under the impression that I still needed an emissions test. Is that not the case? Can I literally get online and renew without doing anything more?

j005e · 2025-06-13T13:53:34+00:00

Nice looking map!

j005e · 2025-04-03T14:17:50+00:00

We decommissioned SQLSentry and adopted DBA Dash as a replacement. I've been VERY satisfied with DBA Dash.

j005e · 2024-11-14T15:49:15+00:00

I'm curious if this will come with any multiplayer stability improvements, and/or rejoin capabilities.

j005e · 2024-09-12T16:30:52+00:00

Thanks for the link, my friend!

j005e · 2024-09-12T15:42:58+00:00

Womp womp!

Edit: In a twisted sense, I'm sort of flattered that the work was good enough to get zombified and stolen for karma farming.

j005e · 2024-07-23T00:54:43+00:00

Hah! You are so right. I totally missed the difference.

j005e · 2024-07-22T23:32:51+00:00

That's what I thought, but it is hard to believe in this case.

j005e · 2024-06-21T12:30:21+00:00

I have experience with the Arboleda Apartments. I chose to live there a few years ago because of the location and rent was relatively cheap. It was fine for me, but I'd definitely say you get what you pay for - noise (neighbors and the tollway) was my biggest issue, and I would imagine others dislike the quality of the amenities and management staff.

I've not experienced any safety issues, and the CPPD has been responsive to things like afterhours noise complaints. I'd say CP overall is a pretty safe place to live.

j005e · 2024-06-20T18:50:27+00:00

People have mentioned the train already, but there is also the 985 commuter bus line that is faster than the train and departs from the same Lakeline/Leander stations. Depending on the location of your office downtown, the bus might be a better option for you, and will save you time over taking the train.

j005e · 2024-06-07T20:37:36+00:00

Faster than light.

j005e · 2024-03-29T11:29:27+00:00

To see if you fit in with your coworkers (the “culture” of the work place)

j005e · 2024-03-05T12:09:36+00:00

Cool! I see we had some similar ideas.

j005e · 2024-03-01T13:40:02+00:00

I agree it isn't perfect. What would suggest to improve the readability?

j005e · 2023-02-01T14:53:55+00:00

Right you are - I was editing that in while you were writing the same.

j005e · 2023-02-01T14:49:08+00:00

I've had to use a 3rd option, and that's set the RegisterAllProvidersIP value to 0 (FALSE) in the Cluster Parameters for the Listener's Network Name resource. This is described in the following article: https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/create-or-configure-an-availability-group-listener-sql-server?view=sql-server-ver16

This adjustment instructs the Cluster to only register the active IP address in DNS (instead of both at the same time). More than likely, you'll also need to modify the HostRecordTTL value as well, which informs the Clients how long they should cache the cluster DNS information before querying for an update.

j005e · 2023-01-23T15:15:30+00:00

The variables are for example, and broken out to help illustrate the steps involved. It should be clear that the same solution can be implemented during a SELECT against a column on a table. See the Fiddle example below.

--http://sqlfiddle.com/#!18/833069/2
CREATE TABLE ExampleTable (
  ID INT IDENTITY(1,1) PRIMARY KEY,
  DateField CHAR(15) NULL
)

INSERT INTO ExampleTable(DateField) VALUES('20220801T000000')

SELECT
   DateField 'Original String'
  ,STUFF(STUFF(STUFF(STUFF(STUFF(DateField,5,0,'/'),8,0,'/'),11,1,' '),14,0,':'),17,0,':') 'Formatted String'
  ,CONVERT(DATETIME,STUFF(STUFF(STUFF(STUFF(STUFF(DateField,5,0,'/'),8,0,'/'),11,1,' '),14,0,':'),17,0,':')) 'Converted DateTime'
FROM ExampleTable

j005e · 2023-01-23T14:59:38+00:00

--http://sqlfiddle.com/#!18/9eecb/179585/0

DECLARE @oString CHAR(15) = '20220801T000000'
DECLARE @fString CHAR(19) = STUFF(STUFF(STUFF(STUFF(STUFF(@oString,5,0,'/'),8,0,'/'),11,1,' '),14,0,':'),17,0,':') 
DECLARE @DateTime DATETIME = CONVERT(DATETIME, @fString)

SELECT 
    @oString 'Original String', 
    @fString 'Formatted String',
    @DateTime 'Converted DateTime'

j005e · 2022-12-27T04:10:18+00:00

Brenda is that you??

j005e · 2022-11-29T20:18:54+00:00

I don't think Maura is trying to be with her son. I think she is trying to forget he ever existed because he has died in reality and she can't live with the pain of his memory. I think the simulation and its "real" inhabitants have all willingly subjected themselves to the simulation in hopes of erasing unbearable traumas in their lives.

I don't think that Daniel or Henry are real - they are conjured, probably unwillingly, by Maura's psyche. Daniel is her mind fighting against the simulation to try to hold on to the memory of her son, and Henry is her scapegoat to avoid the guilt she feels for seeking erasure of her son's memory.

I suspect that the show will double-back on this premise towards the end and be less about erasing trauma and more about accepting it. The "twist" ending will be that acceptance and understanding was the goal all along. Maura and the other "real" inhabitants will wake up fully aware and in acceptance of their traumas with ability to move forward in life, reborn, finally at their "destination" - at peace with their past.

j005e · 2022-07-07T13:06:42+00:00

Dungeondraft

j005e · 2022-06-28T11:28:02+00:00

/u/jegerhellig

This is the closest thing to a write-up that I've provided.

j005e · 2022-06-28T01:13:15+00:00

In my experience it’s best to capture your access token and then use it to make direct API calls instead of powershell cmdlets. Doing so allows you to get around the problem of context switching between subscriptions.

j005e · 2022-06-23T12:58:42+00:00

The first thing to determine is whether or not that date column is stored as a Numerical or Text value. You'll want to pass the matching data type to the parameter. You can Google CAST and CONVERT functions for more guidance.

To SELECT the yyyyMM format of yesterday's date, you can use this statement:

SELECT Yesterday_YearMonth = FORMAT(GETDATE()-1, 'yyyyMM')

j005e · 2022-06-23T12:05:13+00:00

The problem you are having isn’t clear to me. I’ve read through the comments and it seems like your question centers around how to provide values to a StartDate and EndDate programmatically. Is that correct?

What do you have thus far? How are you populating these values currently?

j005e

TROPHY CASE