C# screen sends my yyyymmdd so I thught to use a date fields ( not datetime) in sql. but now when I think of it - there is no need datetime will be fine with 00:00:00
So it's the same attempt. As I said, I didn't read the SO description properly, but I saw that the desired results in both questions are consistent with the description on DBA.SE
You need to use mysqli_fetch_assoc instead of mysqli_fetch_row . You could have worked this out for yourself if you'd have done some simple debugging and var_dump()ed $row. Basic debugging is one of the most important aspects of programming, please learn how — Phil49 mins ago
@Philᵀᴹ giving PHP advice on SO, hell has frozen over
So, we just noticed a new, fowl user on the tavern
I think he called us chicken. Or called itself a chicken. Or something poultry like that.
And interestingly it's a system user. (i.e. with negative ID)
So... what's the story? Who knows what fowlness lurks in the heart of the chicken?
...
Oh joy my company banned imgur so most of the SE network is now useless to me... Any screen shots of things I can't upload or see when someone does. What a great company.
@sp_BlitzErik Well I work for Wells Fargo and they got caught robbing a bunch of people. So now they are trying to look like they are making changes. So they are cracking down on things even if it doesn't make sense to do so.
Although if I recall it wasn't an IT problem that caused a bunch of employees to rob customers but more of greedy CEO issue.
running this on the DAC should show you how it's stored in the data file:
DBCC TRACEON(3604); GO DBCC IND('master','sys.sysxlgns',-1); /* For pages with type = 1 309 is page id in example */ DBCC PAGE('master',1,309,3) WITH TABLERESULTS;
actually you don't need the DAC for that, just for selecting from sys.sysxlgns
i'm not sure that password changes are logged for logins
you can look in the log for a database with select * from fn_dblog(null,null)
though it's more likely that those changes would occur in resource db than master
so if you wanted to change the password and check to see if it's logged at all, you'd need to be on the dac (like james mentioned) and looking at resource db
I'm looking at a 2014 instance with non-yielding schedulers and lots of contention on the SECURITY_CACHE spinlock, but I don't know if that's what this fix was for
Question. We have a pretty large DB 9 TB in size and a system that isn't really capable of doing DBCC checks on that DB in timely fashion. So I'm building a system that will look at the average time frames set for that filegroup and build a list of filegroups to DBCC depending that will fit in that window. So basically and automated system for doing DBCC checks on a system that is too big for it's own good. Do you think folks would be interested in that?
@sp_BlitzErik I could possibly do it in all SQL. Hard to say since I'm still in the prototype phase.
I was just thinking I don't see much online for that and I can't be the only person with this problem.
However I'd like it to be modular enough that someone could just download the code and implement it themselves and run it in any SQL Server environment.
@sp_BlitzErik Unfortunately the fact that my companies only product is money that we use to make more money I'm likely to not be able to use that in spite of their impossibly reasonable pricing.
Yikes. The features there are much better than the ones I was planning and for 250 bucks that's nothing. Don't get me wrong mine was going to be free but still. Dang.
Microsoft develops PowerShell for Windows and then ports sqlcmd.exe to Linux as the "official client" this is the command-line equivalent of Total War.
1> SELECT 1; GO
2> GO;
3> GO
Msg 102, Level 15, State 1, Server x230, Line 1
Incorrect syntax near 'GO'.
1> SELECT 1 GO;
2> GO?
3> GO
SqlState 07002, COUNT field incorrect or syntax error
how is what surprising? I'm not surprised at how horrible it is, I'm just stating it as such.
And I do realize that even Microsoft acknowledges this, which is why the're pushing their new Windows Power Shell SQL Server cmdlit or whatever, which they don't make available in their Linux install.
We have two tags catalog and system-tables. I do not understand the difference between the two tags -- in part because in PostgreSQL pg_catalog is the schema for the system tables. But, I don't want to assume it's that way in the spec or the other database. However, if it is my suggestion that we...
It's specific to Linux, but yea I'll look again. I don't think so in 2017. But this is your expertise not mine so I'm prolly overlooking it or something
If these are questions that I know the answer too, I'll always self-answer them and not waste anyone time. =) I'm usually working on finding an answer when I ask it. And only about half the time I find the right one
I do agree. I can't think of anyone better to write code for future corporate products than those who did it passionately for their free open source alternatives.
So, we just noticed a new, fowl user on the tavern
I think he called us chicken. Or called itself a chicken. Or something poultry like that.
And interestingly it's a system user. (i.e. with negative ID)
So... what's the story? Who knows what fowlness lurks in the heart of the chicken?
...
When will Winter Bash 2017 start?
