Humor

  1. Home
  2. Humor
  3. (Page 3)

Bad Idea Jeans Week: Building a Fork Bomb in SQL Server

Bad Idea Jeans, Humor, SQL Server
14 Comments
Somewhat different than a sex bomb, a fork bomb is a denial-of-service attack that just starts a process that replicates itself, thereby starting more and more processes until the service goes down. Wikipedia’s fork bomb page lists examples on most operating systems (including Windows). I’ve always found fork bombs funny because of their elegant simplicity, so…
Read More

#DellDBADays 2016: What Would You Do with Unlimited Hardware?

Humor
94 Comments
Last August, we got the team together in person for Dell DBA Days. We ran all kinds of interesting experiments with SQL Server, and shared the results with you via live webcasts. https://www.youtube.com/watch?v=Gn43sOLrcVs You can watch our recorded episodes from last year – I’d highly recommend the last one, Watch SQL Server Break and Explode. Erik…
Read More

Creating Tables and Stored Procedures in TempDB – Permanently

No, not #tables – actual tables. Here’s how: USE tempdb; GO /* This one is only available during my session: */ CREATE TABLE #myTempTable (ID INT IDENTITY(1,1), Stuffing VARCHAR(100)); GO /* This one is global, meaning it's available to other sessions: */ CREATE TABLE ##myTempTable (ID INT IDENTITY(1,1), Stuffing VARCHAR(100)); GO /* You can create…
Read More

Microsoft Discontinues SQL Server Support for Windows

Humor
13 Comments
Microsoft announced today that the forthcoming SQL Server 2016 version won’t just run on Linux – it will only run on Linux. Mark Souza, Microsoft “When we started developing the Linux port of SQL Server, we weren’t really serious about it at all,” confessed Mark Souza, lead documentation author for the project. “But after a couple of weeks, we…
Read More

Contest: SQL Server Theme Songs

Humor
244 Comments
During this month’s Senior DBA Class in Chicago, I started joking with the attendees about what songs they should play during common DBA job tasks, like: Best Song to Play During a Server Outage Best Song to Illustrate Your Predecessor’s Skills Best Song to Accompany an Index Rebuild Best Song to Play When Examining a Slow Query Best…
Read More

Brent’s Bad Idea Jeans: Stop People From Changing Tables with This One Trick

Bad Idea Jeans, Humor, SQL Server
21 Comments
Developers hate his bad idea jeans: CREATE VIEW dbo.StopThemDead WITH SCHEMABINDING AS SELECT COUNT(*) FROM dbo.Table1 UNION ALL SELECT COUNT(*) FROM dbo.Table2 UNION ALL.... 123456 CREATE VIEW dbo.StopThemDead WITH SCHEMABINDINGASSELECT COUNT(*) FROM dbo.Table1UNION ALLSELECT COUNT(*) FROM dbo.Table2UNION ALL.... Presto, the schemabinding option means no one can change the underlying tables. (At least, until they figure…
Read More
Menu