am2.co Open in urlscan Pro
2606:4700:3037::6815:4aa1  Public Scan

Form analysis
3 forms found in the DOM

GET https://am2.co/

<form role="search" method="get" class="search-form" action="https://am2.co/">
  <label>
    <span class="screen-reader-text">Search for:</span>
    <input type="search" class="search-field" placeholder="Search …" value="" name="s">
  </label>
  <input type="submit" class="search-submit" value="Search">
</form>

POST #

<form action="#" method="post" accept-charset="utf-8" id="subscribe-blog-blog_subscription-3" data-blog="118127311" data-post_access_level="everybody">
  <p id="subscribe-email">
    <label id="jetpack-subscribe-label" class="screen-reader-text" for="subscribe-field-blog_subscription-3"> Email Address </label>
    <input type="email" name="email" required="required" value="" id="subscribe-field-blog_subscription-3" placeholder="Email Address">
  </p>
  <p id="subscribe-submit">
    <input type="hidden" name="action" value="subscribe">
    <input type="hidden" name="source" value="https://am2.co/">
    <input type="hidden" name="sub-type" value="widget">
    <input type="hidden" name="redirect_fragment" value="subscribe-blog-blog_subscription-3">
    <input type="hidden" id="_wpnonce" name="_wpnonce" value="a19486329e"><input type="hidden" name="_wp_http_referer" value="/"> <button type="submit" class="wp-block-button__link" name="jetpack_subscriptions_widget"> Subscribe </button>
  </p>
</form>

GET https://am2.co

<form action="https://am2.co" method="get"><label class="screen-reader-text" for="cat">Categories</label><select name="cat" id="cat" class="postform">
    <option value="-1">Select Category</option>
    <option class="level-0" value="16">#sqlfamily</option>
    <option class="level-0" value="23">#TSQL2sday</option>
    <option class="level-0" value="31">Automation</option>
    <option class="level-0" value="6">Availability Groups</option>
    <option class="level-0" value="30">Azure</option>
    <option class="level-0" value="42">Backup &amp; Recovery</option>
    <option class="level-0" value="40">Blogging</option>
    <option class="level-0" value="2">Bugs</option>
    <option class="level-0" value="29">Cloud</option>
    <option class="level-0" value="19">Data Compression</option>
    <option class="level-0" value="49">DBA Database</option>
    <option class="level-0" value="48">Diversity &amp; Inclusion</option>
    <option class="level-0" value="17">filestream</option>
    <option class="level-0" value="9">indexes</option>
    <option class="level-0" value="33">Internals</option>
    <option class="level-0" value="46">Just for fun</option>
    <option class="level-0" value="39">LGBTQ</option>
    <option class="level-0" value="28">Log Shipping</option>
    <option class="level-0" value="27">Mirroring</option>
    <option class="level-0" value="5">MSX</option>
    <option class="level-0" value="13">PASS</option>
    <option class="level-0" value="24">Performance</option>
    <option class="level-0" value="26">PowerShell</option>
    <option class="level-0" value="25">professional development</option>
    <option class="level-0" value="44">Redgate</option>
    <option class="level-0" value="8">replication</option>
    <option class="level-0" value="43">Security</option>
    <option class="level-0" value="36">SentryOne Team Blog</option>
    <option class="level-0" value="7">server upgrade</option>
    <option class="level-0" value="45">Session Recordings</option>
    <option class="level-0" value="4">Shortcuts</option>
    <option class="level-0" value="3">SQL Agent</option>
    <option class="level-0" value="14">SQL Saturday</option>
    <option class="level-0" value="32">SSRS</option>
    <option class="level-0" value="18">statistics</option>
    <option class="level-0" value="15">Summit</option>
    <option class="level-0" value="11">synonyms</option>
    <option class="level-0" value="20">T-SQL</option>
    <option class="level-0" value="47">Thirsty Thursday</option>
    <option class="level-0" value="1">Uncategorized</option>
    <option class="level-0" value="10">views</option>
    <option class="level-0" value="37">What the heck is….</option>
  </select>
</form>

Text Content

ANDY M MALLON - AM²


DATABASES & DIVERSITY — CHECKING INTEGRITY

MENU
 * Home
 * About Me ►
   * About Me
   * Contact Andy
 * GitHub Stuff ►
   * Profile
   * DBA Database
   * Data Blogger Resource Kit
   * Presentation Content
 * Legal Stuff

 * Home
 * About Me
   * About Me
   * Contact Andy
 * GitHub Stuff
   * Profile
   * DBA Database
   * Data Blogger Resource Kit
   * Presentation Content
 * Legal Stuff


T-SQL TUESDAY: THE LAST TICKET I CLOSED

February 13, 2024 Andy 2

For this month’s T-SQL Tuesday, Brent Ozar (blog|Instagram) asks us to describe
the most recent ticket we closed. “We had a pretty significant wait spike…” The
literal last ticket I closed was “please run this script in production…”, and I
don’t think it would be … [Read More]


PUBLISHING A CODE OF CONDUCT ISN’T ENOUGH

July 13, 2022 Andy 1

I’ve seen more and more events & communities adopt Codes of Conduct. Even local
events, local user groups, and smaller online communities are adopting Codes of
Conduct. That’s GREAT! …but it’s just a great start. It’s not that easy.
Discoverability The issue of discoverability is … [Read More]


HOW DO I PREVENT A TRIGGER FROM FIRING FOR ONE PROCESS?

March 8, 2022 Andy 7

I recently saw a question on DBA Stack Exchange (it has since been deleted by
the author), who had a “special process” that ran regularly, and as part of that
process, they disabled the trigger, did some stuff, and re-enabled it. During
that process, the … [Read More]


QUERYING SERVERPROPERTY() AND DATABASEPROPERTYEX() FROM A VIEW (WITHOUT KNOWING
MAGIC)

December 17, 2021 Andy 1

I’m not going to beat around the bush. I hate the SERVERPROPERTY() and
DATABASEPROPERTYEX() system functions. Loathing The thing I hate the most about
these two functions is that you need to know the right magic spells to make them
work. Let’s look at SERVERPROPERTY() … [Read More]


WHAT THE HECK IS THE SSISDB? WHERE DOES IT COME FROM?

October 18, 2021 Andy 2

Back in my day, we stored SQL Server Integration Services (SSIS) packages in
msdb, or the file system. Well, I’m neither dead nor retired, so that’s not an
accurate statement–today is still “my time.” But when I was learning about SQL
Server, those were the … [Read More]


T-SQL TUESDAY #143: MY FAVORITE SHORT SCRIPTS

October 12, 2021 Andy 2

For this month’s T-SQL Tuesday, John McCormack (blog|twitter) asks us: “What are
your go-to short, handy scripts”? I’ve got so many handy dandy scripts, it was
hard to choose. Where to start? I have so many go-to scripts that are short,
amazing, and I use … [Read More]


WHAT TIME IS IT IN OZ?

October 5, 2021 Andy 1

There was a recent post on Database Administrators, where there was some
confusion over Daylight Saving Time(DST) in Australian timezones. Let’s be
honest though–timezones are confusing, especially when DST comes into play.
Arizona Time doesn’t observe Daylight Saving Time, so sometimes it’s the same as
… [Read More]


STOP USING SP_HEXADECIMAL & SP_HELP_REVLOGIN

July 6, 2021 Andy 2

Since I started at Stack Overflow, I’ve had the chance to see some of the
interesting challenges with running our databases at our scale. My coworker
Taryn Pratt (blog|twitter) recently blogged about fighting with deadlocks
related to Stack Overflow for Teams. Lots of logins Taryn … [Read More]


FAQS ABOUT THE DISSOLUTION OF PASS

December 28, 2020 Andy 2

In my prior post, I talked about how all signs pointed to it being Closing Time
for PASS. Since then, PASS has announced the organization will “cease its
operations and pursue dissolution.” TL;DR; The short version is that on 15
January, 2021, PASS will shut … [Read More]


CLOSING TIME

December 8, 2020 Andy 1

This year, I’ve written a couple of critical posts targeted at PASS. If you
follow me on Twitter, you know I’ve been critical there, too. Last week, the
PASS Board of Directors had their December meeting. Coming out of that meeting,
Mindy Curnutt (blog|twitter) resigned … [Read More]


POSTS NAVIGATION

1 2 … 17 »

Github Profile
DBA Database
Data Blogger Resource Kit
Mastodon:
amtwo@lgbt.tech

Search for:

SUBSCRIBE VIA EMAIL

Email Address

Subscribe

Join 981 other subscribers

SSMS SHORTCUTS

AWARDS & PROGRAMS





ARCHIVES

Archives Select Month February 2024 July 2022 March 2022 December 2021 October
2021 July 2021 December 2020 October 2020 June 2020 May 2020 April 2020 March
2020 December 2019 October 2019 September 2019 August 2019 May 2019 April 2019
January 2019 December 2018 November 2018 October 2018 September 2018 August 2018
July 2018 June 2018 March 2018 February 2018 January 2018 December 2017 November
2017 October 2017 September 2017 August 2017 July 2017 June 2017 April 2017
March 2017 February 2017 January 2017 December 2016 November 2016 October 2016
September 2016 August 2016 July 2016 June 2016 May 2016 April 2016 March 2016
February 2016 January 2016 December 2015 November 2015 October 2015 September
2015 August 2015 July 2015 June 2015 May 2015 April 2015 January 2015 November
2014 July 2014 May 2014

CATEGORIES

Categories Select Category #sqlfamily #TSQL2sday Automation Availability Groups
Azure Backup & Recovery Blogging Bugs Cloud Data Compression DBA Database
Diversity & Inclusion filestream indexes Internals Just for fun LGBTQ Log
Shipping Mirroring MSX PASS Performance PowerShell professional development
Redgate replication Security SentryOne Team Blog server upgrade Session
Recordings Shortcuts SQL Agent SQL Saturday SSRS statistics Summit synonyms
T-SQL Thirsty Thursday Uncategorized views What the heck is….

RSS

 * T-SQL Tuesday: The last ticket I closed February 13, 2024
 * Publishing a Code of Conduct isn’t enough July 13, 2022
 * How do I prevent a trigger from firing for one process? March 8, 2022
 * Querying SERVERPROPERTY() and DATABASEPROPERTYEX() from a view (without
   knowing magic) December 17, 2021
 * What the heck is the SSISDB? Where does it come from? October 18, 2021
 * T-SQL Tuesday #143: My favorite short scripts October 12, 2021
 * What time is it in Oz? October 5, 2021
 * Stop using sp_hexadecimal & sp_help_revlogin July 6, 2021
 * FAQs about the dissolution of PASS December 28, 2020
 * Closing Time December 8, 2020

Copyright © 2024 | Andy Mallon | am2.co