August 10, 2017 at 11:03 am
Brandie Tarvin - Wednesday, August 9, 2017 12:35 PMThom A - Wednesday, August 9, 2017 8:47 AMWho doesn't enjoy creating Excel documents with 196 columns..? :sick:I had to create an SSIS package to load a file with almost 700 columns to it.
Talk about FUN.
Isn't that what BIML is for?
August 10, 2017 at 11:05 am
Can I stop changing my passwords every 90 days, please?
http://gizmodo.com/the-guy-who-invented-those-annoying-password-rules-now-1797643987
August 10, 2017 at 11:09 am
Luis Cazares - Thursday, August 10, 2017 11:05 AMCan I stop changing my passwords every 90 days, please?
http://gizmodo.com/the-guy-who-invented-those-annoying-password-rules-now-1797643987
Sure. So long as you don't mind changing them every day. @=)
August 10, 2017 at 11:16 am
Brandie Tarvin - Thursday, August 10, 2017 11:09 AMLuis Cazares - Thursday, August 10, 2017 11:05 AMCan I stop changing my passwords every 90 days, please?
http://gizmodo.com/the-guy-who-invented-those-annoying-password-rules-now-1797643987Sure. So long as you don't mind changing them every day. @=)
I do that for some of the websites I use. Change it each time I log in as I can't remember the password from the last time I logged in. 😀
August 10, 2017 at 5:30 pm
Luis Cazares - Thursday, August 10, 2017 11:05 AMCan I stop changing my passwords every 90 days, please?
http://gizmodo.com/the-guy-who-invented-those-annoying-password-rules-now-1797643987
https://www.troyhunt.com/passwords-evolved-authentication-guidance-for-the-modern-era/
August 10, 2017 at 5:33 pm
My best server room story is a new room built at the nuclear plant for our VAX, DG, and some PC servers. Nice, fancy room, raised floor, separate UPS room, separate sprinklers and power generator. Put in machines, turned on, worked a few days, noticed every morning the room was about 90F. Spec was 70F (or so).
After a week my boss talked to the contractor, we redid the calculations, as we were expecting to add more PC servers.
#machines, check
wattage usage byeach, check
BTU load, check
BTU output by each AC, check
divide by 3, ch, wait, what?
apparently the contractor assumed that we were working 8 hours a day, so that must be how much the computers worked.
August 11, 2017 at 4:07 am
Steve Jones - SSC Editor - Thursday, August 10, 2017 5:33 PMMy best server room story is a new room built at the nuclear plant for our VAX, DG, and some PC servers. Nice, fancy room, raised floor, separate UPS room, separate sprinklers and power generator. Put in machines, turned on, worked a few days, noticed every morning the room was about 90F. Spec was 70F (or so).
After a week my boss talked to the contractor, we redid the calculations, as we were expecting to add more PC servers.#machines, check
wattage usage byeach, check
BTU load, check
BTU output by each AC, check
divide by 3, ch, wait, what?apparently the contractor assumed that we were working 8 hours a day, so that must be how much the computers worked.
HA! I always knew my servers were going on vacation over the weekends. This explains so much...
August 11, 2017 at 4:34 am
Steve Jones - SSC Editor - Thursday, August 10, 2017 5:30 PMLuis Cazares - Thursday, August 10, 2017 11:05 AMCan I stop changing my passwords every 90 days, please?
http://gizmodo.com/the-guy-who-invented-those-annoying-password-rules-now-1797643987https://www.troyhunt.com/passwords-evolved-authentication-guidance-for-the-modern-era/
Wait...
Microsoft is also on the same page here:
Password expiration policies do more harm than good, because these policies drive users to very predictable passwords composed of sequential words and numbers which are closely related to each other (that is, the next password can be predicted based on the previous password). Password change offers no containment benefits cyber criminals almost always use credentials as soon as they compromise them.
Soooo, is Microsoft changing the SQL Server "Enforce password policy," "Enforce password expiration" stuff anytime soon?
August 11, 2017 at 4:40 am
Brandie Tarvin - Friday, August 11, 2017 4:34 AMSoooo, is Microsoft changing the SQL Server "Enforce password policy," "Enforce password expiration" stuff anytime soon?
Depends what your definition "soon" is, and then what that time period is in Microsoft time. We all know that 1 "Microsoft Minute" can be anywhere between 10 seconds and several hours/days. 😉
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 11, 2017 at 4:44 am
Thom A - Friday, August 11, 2017 4:40 AMBrandie Tarvin - Friday, August 11, 2017 4:34 AMSoooo, is Microsoft changing the SQL Server "Enforce password policy," "Enforce password expiration" stuff anytime soon?
Depends what your definition "soon" is, and then what that time period is in Microsoft time. We all know that 1 "Microsoft Minute" can be anywhere between 10 seconds and several hours/days. 😉
Time to pull out Ye Ol' DBCC TIMEWARP(), then. It'll make life much easier with Microsoft Minutes. @=)
August 11, 2017 at 5:25 am
Brandie Tarvin - Friday, August 11, 2017 4:44 AMThom A - Friday, August 11, 2017 4:40 AMBrandie Tarvin - Friday, August 11, 2017 4:34 AMSoooo, is Microsoft changing the SQL Server "Enforce password policy," "Enforce password expiration" stuff anytime soon?
Depends what your definition "soon" is, and then what that time period is in Microsoft time. We all know that 1 "Microsoft Minute" can be anywhere between 10 seconds and several hours/days. 😉
Time to pull out Ye Ol' DBCC TIMEWARP(), then. It'll make life much easier with Microsoft Minutes. @=)
Thom is so very right about a "Microsoft Minute" - I've felt like I was stuck in a bubble of time while waiting for that last 10 seconds of a status bar before.
August 11, 2017 at 8:11 am
Brandie Tarvin - Friday, August 11, 2017 4:34 AMSteve Jones - SSC Editor - Thursday, August 10, 2017 5:30 PMLuis Cazares - Thursday, August 10, 2017 11:05 AMCan I stop changing my passwords every 90 days, please?
http://gizmodo.com/the-guy-who-invented-those-annoying-password-rules-now-1797643987https://www.troyhunt.com/passwords-evolved-authentication-guidance-for-the-modern-era/
Wait...
Microsoft is also on the same page here:
Password expiration policies do more harm than good, because these policies drive users to very predictable passwords composed of sequential words and numbers which are closely related to each other (that is, the next password can be predicted based on the previous password). Password change offers no containment benefits cyber criminals almost always use credentials as soon as they compromise them.
Soooo, is Microsoft changing the SQL Server "Enforce password policy," "Enforce password expiration" stuff anytime soon?
Probably not. Someone will keep asking for this functionality because of "security" and it might still come until we find something different than passwords to authenticate users. I wonder if at any time, they'll ask you to get eye surgery because your retina has been compromised and someone accessed your bank accounts.
August 11, 2017 at 8:15 am
Luis Cazares - Friday, August 11, 2017 8:11 AMI wonder if at any time, they'll ask you to get eye surgery because your retina has been compromised and someone accessed your bank accounts.
Now that's funny. I'd bet they'd feel completely justified in mandating that people get eye surgery to use their OS. Hopefully, they won't require a chip implant in your eye. I'd hate to think that happened when they released a patch for the chip that didn't work.
August 11, 2017 at 11:35 am
Just found the following code. This is what happens when a procedural developer starts writing T-SQL. Fortunately, some learn to stop the non-sense.
--Variables names changed
DECLARE @intOneSourceID INT
,@intAnotherSourceID INT
SET @intOneSourceID = NULL
SET @intAnotherSourceID = NULL
August 11, 2017 at 3:23 pm
"I don't understand."
"What don't you understand?"
"I don't understand."
"I don't understand."
"What don't you understand?"
"I don't understand."
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 15 posts - 59,611 through 59,625 (of 66,738 total)
You must be logged in to reply to this topic. Login to reply