February 6, 2017 at 1:37 pm
Ed Wagner - Monday, February 6, 2017 8:09 AMEirikur Eiriksson - Monday, February 6, 2017 6:38 AMBrandie Tarvin - Monday, February 6, 2017 6:32 AMjasona.work - Monday, February 6, 2017 5:48 AMTime to patch up your SQL 2000 instances!
SLAMMER is back for another go-round: http://blog.checkpoint.com/2017/02/02/sql-slammer-comeback/Taking bets that someone plugged an infected, unpatched machine back into the network for some reason, thus bringing SLAMMER back from the ash heap of history?
How do we know this is hitting just SQL 2000? Couldn't one of the current versions of SQL have accidentally re-introduced the bug that made SLAMMER so effective in the first place?
Doubt that's the case, the UDP buffer overflow flaw was a spectacular cock up, it would take a truly supreme idiot to repeat that one.
😎No worries, Eirikur, the world has an uncanny ability to always produce a better idiot. :hehe:
Spot on or should I say off, the idiots just keep coming better and better Ed
😎
February 6, 2017 at 1:49 pm
Eirikur Eiriksson - Monday, February 6, 2017 1:37 PMEd Wagner - Monday, February 6, 2017 8:09 AMEirikur Eiriksson - Monday, February 6, 2017 6:38 AMBrandie Tarvin - Monday, February 6, 2017 6:32 AMjasona.work - Monday, February 6, 2017 5:48 AMTime to patch up your SQL 2000 instances!
SLAMMER is back for another go-round: http://blog.checkpoint.com/2017/02/02/sql-slammer-comeback/Taking bets that someone plugged an infected, unpatched machine back into the network for some reason, thus bringing SLAMMER back from the ash heap of history?
How do we know this is hitting just SQL 2000? Couldn't one of the current versions of SQL have accidentally re-introduced the bug that made SLAMMER so effective in the first place?
Doubt that's the case, the UDP buffer overflow flaw was a spectacular cock up, it would take a truly supreme idiot to repeat that one.
😎No worries, Eirikur, the world has an uncanny ability to always produce a better idiot. :hehe:
Spot on or should I say off, the idiots just keep coming better and better Ed
😎
Not to worry anyone but the first day of the DBA training this week has been very informative. I've learned more that I can use in eight hours than I did in the last two BI courses. There'll be a box-fresh idiot throwing away his BI plates and hitting the servers soon.
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
February 6, 2017 at 3:02 pm
jasona.work - Monday, February 6, 2017 5:48 AMTime to patch up your SQL 2000 instances!
SLAMMER is back for another go-round: http://blog.checkpoint.com/2017/02/02/sql-slammer-comeback/Taking bets that someone plugged an infected, unpatched machine back into the network for some reason, thus bringing SLAMMER back from the ash heap of history?
Not just aninfected unpatched machine - for that thing to propagate there have to be misconfigured firewalls too.
Tom
February 7, 2017 at 4:28 am
For the presenters out there do you use the USB presentation clicker with the laser light when talking to a group?
February 7, 2017 at 4:40 am
BLOB EATER - Tuesday, February 7, 2017 4:28 AMFor the presenters out there do you use the USB presentation clicker with the laser light when talking to a group?
Always.
Got it as a gift (I believe from SQL Sat Portland) a few years back and never want to present without it anymore.
(I don't use the laser light often, many screens have too much light that the audience cannot see it and in recorded sessions it is totally useless for the recording), But the ability to move around and still be able to advance my slides without having to walk back to the desk every time is a huge benefit
February 7, 2017 at 4:48 am
Hugo Kornelis - Tuesday, February 7, 2017 4:40 AMBLOB EATER - Tuesday, February 7, 2017 4:28 AMFor the presenters out there do you use the USB presentation clicker with the laser light when talking to a group?Always.
Got it as a gift (I believe from SQL Sat Portland) a few years back and never want to present without it anymore.(I don't use the laser light often, many screens have too much light that the audience cannot see it and in recorded sessions it is totally useless for the recording), But the ability to move around and still be able to advance my slides without having to walk back to the desk every time is a huge benefit
ok nice, I think I will too. I like the thought of moving around and not rushing back to the laptop to advance the slides.
February 7, 2017 at 5:59 am
BLOB EATER - Tuesday, February 7, 2017 4:28 AMFor the presenters out there do you use the USB presentation clicker with the laser light when talking to a group?
Yes.
For small groups I use the laser pointer less because I can usually walk right up to the screen. However, I almost always control the slides remotely. I don't present behind a table or a lectern. I walk around.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
February 7, 2017 at 10:09 am
I was thinking of submitting a script that could hopefully be published in about 2 months. But I wanted to get your expertise on things that might be slipping my mind.
It's a function for ROT26 encryption which will include an example on applying it twice for extra security. Let me know if you have any ideas on how to make it more "robust".
IF OBJECT_ID('dbo.iROT26') IS NOT NULL
DROP FUNCTION iROT26;
GO
CREATE FUNCTION dbo.iROT26(
@String nvarchar(100)
)
RETURNS TABLE WITH SCHEMABINDING
AS RETURN
WITH
E(n) AS(
SELECT n FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0))E(n)
),
E2(n) AS(
SELECT a.n FROM E a, E b
),
E4(n) AS(
SELECT a.n FROM E2 a, E2 b
),
cteTally(n) AS(
SELECT TOP(LEN(@String))ROW_NUMBER() OVER(ORDER BY (SELECT NULL)) n
FROM E4
)
SELECT ( SELECT NCHAR(UNICODE(SUBSTRING(@String, n, 1)) * POWER(26,0))
FROM cteTally
WHERE n <= DATALENGTH(@String) / 2
FOR XML PATH(''), TYPE).value('./text()[1]', 'varchar(max)') rot26String;
GO
SELECT p.rowguid,
p.LastName,
r2.rot26String
FROM AdventureWorks2014.Person.Person p
CROSS APPLY dbo.iROT26( p.LastName) r
CROSS APPLY dbo.iROT26( r.rot26String) r2;
February 7, 2017 at 10:39 am
Luis Cazares - Tuesday, February 7, 2017 10:09 AMI was thinking of submitting a script that could hopefully be published in about 2 months. But I wanted to get your expertise on things that might be slipping my mind.
It's a function for ROT26 encryption which will include an example on applying it twice for extra security. Let me know if you have any ideas on how to make it more "robust".
IF OBJECT_ID('dbo.iROT26') IS NOT NULL
DROP FUNCTION iROT26;
GOCREATE FUNCTION dbo.iROT26(
@String nvarchar(100)
)
RETURNS TABLE WITH SCHEMABINDING
AS RETURN
WITH
E(n) AS(
SELECT n FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0))E(n)
),
E2(n) AS(
SELECT a.n FROM E a, E b
),
E4(n) AS(
SELECT a.n FROM E2 a, E2 b
),
cteTally(n) AS(
SELECT TOP(LEN(@String))ROW_NUMBER() OVER(ORDER BY (SELECT NULL)) n
FROM E4
)
SELECT ( SELECT NCHAR(UNICODE(SUBSTRING(@String, n, 1)) * POWER(26,0))
FROM cteTally
WHERE n <= DATALENGTH(@String) / 2
FOR XML PATH(''), TYPE).value('./text()[1]', 'varchar(max)') rot26String;
GOSELECT p.rowguid,
p.LastName,
r2.rot26String
FROM AdventureWorks2014.Person.Person p
CROSS APPLY dbo.iROT26( p.LastName) r
CROSS APPLY dbo.iROT26( r.rot26String) r2;
I think you should convert this to a scalar function....you know, for performance. :laugh:
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
February 7, 2017 at 10:53 am
BLOB EATER - Tuesday, February 7, 2017 4:28 AMFor the presenters out there do you use the USB presentation clicker with the laser light when talking to a group?
Yes. Absolutely, without question. The only time I'm at the keyboard of my laptop is for demos.
My old one failed a couple months before PASS, and that was a crisis!
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
February 7, 2017 at 10:59 am
9 year member of this site, 9 years of asking DBA questions, and can't write a differential backup script...
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
February 7, 2017 at 11:08 am
Talking about Silver Spoon, Gail?
February 7, 2017 at 11:08 am
GilaMonster - Tuesday, February 7, 2017 10:59 AM9 year member of this site, 9 years of asking DBA questions, and can't write a differential backup script...
Hey, looking up syntax on the interwebs is really hard.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
February 7, 2017 at 11:11 am
Nope, not Silver Spoon but falls in the same category.
February 7, 2017 at 11:17 am
Lynn Pettis - Tuesday, February 7, 2017 11:11 AMNope, not Silver Spoon but falls in the same category.
I read that post. Yes, definitely in the same SS category. I'm waiting for a followup question asking the same thing again.
Viewing 15 posts - 57,376 through 57,390 (of 66,000 total)
You must be logged in to reply to this topic. Login to reply