Help
RSS
API
Feed
Maltego
Contact
Domain > dbadiaries.com
×
More information on this domain is in
AlienVault OTX
Is this malicious?
Yes
No
DNS Resolutions
Date
IP Address
2019-12-06
104.27.164.116
(
ClassC
)
2024-10-23
172.67.197.115
(
ClassC
)
Port 80
HTTP/1.1 301 Moved PermanentlyDate: Wed, 23 Oct 2024 19:49:14 GMTContent-Type: text/htmlTransfer-Encoding: chunkedConnection: keep-aliveLocation: https://dbadiaries.com/cf-cache-status: DYNAMICReport-To: {endpoints:{url:https:\/\/a.nel.cloudflare.com\/report\/v4?sm8xlqXCUgalV7mtW9guhqjslDiu4LAd%2FFgubA49zURsjALdsEetnTYRbSoXGQX5VI98wU%2BsEgfzMSajxfXblYsfWuyPCFmuc6IIap2nAqh%2FFAvF%2FL4CS0fO2iY%2BarL2anQ%3D%3D},group:cf-nel,max_age:604800}NEL: {success_fraction:0,report_to:cf-nel,max_age:604800}Server: cloudflareCF-RAY: 8d743fcbfe4215b0-SJCalt-svc: h3:443; ma86400server-timing: cfL4;desc?protoTCP&rtt21077&sent1&recv3&lost0&retrans0&sent_bytes0&recv_bytes53&delivery_rate0&cwnd250&unsent_bytes0&cid0000000000000000&ts0&x0 html>head>title>301 Moved Permanently/title>/head>body>center>h1>301 Moved Permanently/h1>/center>hr>center>nginx/1.18.0 (Ubuntu)/center>/body>/html>
Port 443
HTTP/1.1 200 OKDate: Wed, 23 Oct 2024 19:49:14 GMTContent-Type: text/html; charsetUTF-8Transfer-Encoding: chunkedConnection: keep-aliveLink: https://dbadiaries.com/wp-json/>; relhttps://api.w.org/cf-cache-status: DYNAMICvary: accept-encodingReport-To: {endpoints:{url:https:\/\/a.nel.cloudflare.com\/report\/v4?sn7y6OctOsVvXYM4PXKrPdSfm%2BT%2B6ZBh5JsA3E8Pp60THGbC5X1huhaCq7il7OW8kKhe0ifTs9o%2FSIOGjXdzGD2ZpCo2st4JR4Pi5mVvuDXC1bXlt3kzj3%2FA9XvJv9T%2BtpA%3D%3D},group:cf-nel,max_age:604800}NEL: {success_fraction:0,report_to:cf-nel,max_age:604800}Server: cloudflareCF-RAY: 8d743fcd1aa2159c-SJCalt-svc: h3:443; ma86400server-timing: cfL4;desc?protoTCP&rtt21643&sent5&recv6&lost0&retrans0&sent_bytes2859&recv_bytes725&delivery_rate134754&cwnd182&unsent_bytes0&cid80c85078373124da&ts529&x0 !DOCTYPE html>html dirltr langen-US prefixog: https://ogp.me/ns#>head itemscope itemtypehttps://schema.org/WebSite>meta charsetUTF-8 />meta nameviewport contentwidthdevice-width, initial-scale1 />title>DBA Diaries - Articles & Tutorials on SQL Server and MySQL/title>meta namedescription contentArticles and tutorials from a DBA working with SQL Server and MySQL relational database technology. />meta namerobots contentmax-image-preview:large />link relcanonical hrefhttps://dbadiaries.com />link relnext hrefhttps://dbadiaries.com/page/2 />meta namegenerator contentAll in One SEO (AIOSEO) 4.5.6 />meta propertyog:locale contenten_US />meta propertyog:site_name contentDBA Diaries | Thoughts and experiences of a DBA working with SQL Server and MySQL />meta propertyog:type contentwebsite />meta propertyog:title contentDBA Diaries - Articles & Tutorials on SQL Server and MySQL />meta propertyog:description contentArticles and tutorials from a DBA working with SQL Server and MySQL relational database technology. />meta propertyog:url contenthttps://dbadiaries.com />meta nametwitter:card contentsummary />meta nametwitter:title contentDBA Diaries - Articles & Tutorials on SQL Server and MySQL />meta nametwitter:description contentArticles and tutorials from a DBA working with SQL Server and MySQL relational database technology. />script typeapplication/ld+json classaioseo-schema> {@context:https:\/\/schema.org,@graph:{@type:BreadcrumbList,@id:https:\/\/dbadiaries.com#breadcrumblist,itemListElement:{@type:ListItem,@id:https:\/\/dbadiaries.com\/#listItem,position:1,name:Home}},{@type:CollectionPage,@id:https:\/\/dbadiaries.com#collectionpage,url:https:\/\/dbadiaries.com,name:DBA Diaries - Articles & Tutorials on SQL Server and MySQL,description:Articles and tutorials from a DBA working with SQL Server and MySQL relational database technology.,inLanguage:en-US,isPartOf:{@id:https:\/\/dbadiaries.com\/#website},breadcrumb:{@id:https:\/\/dbadiaries.com#breadcrumblist},about:{@id:https:\/\/dbadiaries.com\/#organization}},{@type:Organization,@id:https:\/\/dbadiaries.com\/#organization,name:DBA Diaries,url:https:\/\/dbadiaries.com\/},{@type:WebSite,@id:https:\/\/dbadiaries.com\/#website,url:https:\/\/dbadiaries.com\/,name:DBA Diaries,description:Thoughts and experiences of a DBA working with SQL Server and MySQL,inLanguage:en-US,publisher:{@id:https:\/\/dbadiaries.com\/#organization},potentialAction:{@type:SearchAction,target:{@type:EntryPoint,urlTemplate:https:\/\/dbadiaries.com\/?s{search_term_string}},query-input:required namesearch_term_string}}} /script>link reldns-prefetch href//fonts.googleapis.com />link relalternate typeapplication/rss+xml titleDBA Diaries » Feed hrefhttps://dbadiaries.com/feed />link relalternate typeapplication/rss+xml titleDBA Diaries » Comments Feed hrefhttps://dbadiaries.com/comments/feed />script src//www.googletagmanager.com/gtag/js?idG-NVRY0QG3C6 data-cfasyncfalse data-wpfc-renderfalse async>/script>script data-cfasyncfalse data-wpfc-renderfalse> var mi_version 8.28.0; var mi_track_user true; var mi_no_track_reason ; var MonsterInsightsDefaultLocations {page_location:https:\/\/dbadiaries.com\/}; if ( typeof MonsterInsightsPrivacyGuardFilter function ) { var MonsterInsightsLocations (typeof MonsterInsightsExcludeQuery object) ? MonsterInsightsPrivacyGuardFilter( MonsterInsightsExcludeQuery ) : MonsterInsightsPrivacyGuardFilter( MonsterInsightsDefaultLocations ); } else { var MonsterInsightsLocations (typeof MonsterInsightsExcludeQuery object) ? MonsterInsightsExcludeQuery : MonsterInsightsDefaultLocations; } var disableStrs ga-disable-G-NVRY0QG3C6, ; /* Function to detect opted out users */ function __gtagTrackerIsOptedOut() { for (var index 0; index disableStrs.length; index++) { if (document.cookie.indexOf(disableStrsindex + true) > -1) { return true; } } return false; } /* Disable tracking if the opt-out cookie exists. */ if (__gtagTrackerIsOptedOut()) { for (var index 0; index disableStrs.length; index++) { windowdisableStrsindex true; } } /* Opt-out function */ function __gtagTrackerOptout() { for (var index 0; index disableStrs.length; index++) { document.cookie disableStrsindex + true; expiresThu, 31 Dec 2099 23:59:59 UTC; path/; windowdisableStrsindex true; } } if (undefined typeof gaOptout) { function gaOptout() { __gtagTrackerOptout(); } } window.dataLayer window.dataLayer || ; window.MonsterInsightsDualTracker { helpers: {}, trackers: {}, }; if (mi_track_user) { function __gtagDataLayer() { dataLayer.push(arguments); } function __gtagTracker(type, name, parameters) { if (!parameters) { parameters {}; } if (parameters.send_to) { __gtagDataLayer.apply(null, arguments); return; } if (type event) { parameters.send_to monsterinsights_frontend.v4_id; var hookName name; if (typeof parametersevent_category ! undefined) { hookName parametersevent_category + : + name; } if (typeof MonsterInsightsDualTracker.trackershookName ! undefined) { MonsterInsightsDualTracker.trackershookName(parameters); } else { __gtagDataLayer(event, name, parameters); } } else { __gtagDataLayer.apply(null, arguments); } } __gtagTracker(js, new Date()); __gtagTracker(set, { developer_id.dZGIzZG: true, }); if ( MonsterInsightsLocations.page_location ) { __gtagTracker(set, MonsterInsightsLocations); } __gtagTracker(config, G-NVRY0QG3C6, {forceSSL:true,link_attribution:true} ); window.gtag __gtagTracker; (function () { /* https://developers.google.com/analytics/devguides/collection/analyticsjs/ */ /* ga and __gaTracker compatibility shim. */ var noopfn function () { return null; }; var newtracker function () { return new Tracker(); }; var Tracker function () { return null; }; var p Tracker.prototype; p.get noopfn; p.set noopfn; p.send function () { var args Array.prototype.slice.call(arguments); args.unshift(send); __gaTracker.apply(null, args); }; var __gaTracker function () { var len arguments.length; if (len 0) { return; } var f argumentslen - 1; if (typeof f ! object || f null || typeof f.hitCallback ! function) { if (send arguments0) { var hitConverted, hitObject false, action; if (event arguments1) { if (undefined ! typeof arguments3) { hitObject { eventAction: arguments3, eventCategory: arguments2, eventLabel: arguments4, value: arguments5 ? arguments5 : 1, } } } if (pageview arguments1) { if (undefined ! typeof arguments2) { hitObject { eventAction: page_view, page_path: arguments2, } } } if (typeof arguments2 object) { hitObject arguments2; } if (typeof arguments5 object) { Object.assign(hitObject, arguments5); } if (undefined ! typeof arguments1.hitType) { hitObject arguments1; if (pageview hitObject.hitType) { hitObject.eventAction page_view; } } if (hitObject) { action timing arguments1.hitType ? timing_complete : hitObject.eventAction; hitConverted mapArgs(hitObject); __gtagTracker(event, action, hitConverted); } } return; } function mapArgs(args) { var arg, hit {}; var gaMap { eventCategory: event_category, eventAction: event_action, eventLabel: event_label, eventValue: event_value, nonInteraction: non_interaction, timingCategory: event_category, timingVar: name, timingValue: value, timingLabel: event_label, page: page_path, location: page_location, title: page_title, referrer : page_referrer, }; for (arg in args) { if (!(!args.hasOwnProperty(arg) || !gaMap.hasOwnProperty(arg))) { hitgaMaparg argsarg; } else { hitarg argsarg; } } return hit; } try { f.hitCallback(); } catch (ex) { } }; __gaTracker.create newtracker; __gaTracker.getByName newtracker; __gaTracker.getAll function () { return ; }; __gaTracker.remove noopfn; __gaTracker.loaded true; window__gaTracker __gaTracker; })(); } else { console.log(); (function () { function __gtagTracker() { return null; } window__gtagTracker __gtagTracker; windowgtag __gtagTracker; })(); } /script>script type5ce7803cbb2ca33ddea18516-text/javascript>window._wpemojiSettings {baseUrl:https:\/\/s.w.org\/images\/core\/emoji\/14.0.0\/72x72\/,ext:.png,svgUrl:https:\/\/s.w.org\/images\/core\/emoji\/14.0.0\/svg\/,svgExt:.svg,source:{concatemoji:https:\/\/dbadiaries.com\/wp-includes\/js\/wp-emoji-release.min.js?ver6.4.5}};/*! This file is auto-generated */!function(i,n){var o,s,e;function c(e){try{var t{supportTests:e,timestamp:(new Date).valueOf()};sessionStorage.setItem(o,JSON.stringify(t))}catch(e){}}function p(e,t,n){e.clearRect(0,0,e.canvas.width,e.canvas.height),e.fillText(t,0,0);var tnew Uint32Array(e.getImageData(0,0,e.canvas.width,e.canvas.height).data),r(e.clearRect(0,0,e.canvas.width,e.canvas.height),e.fillText(n,0,0),new Uint32Array(e.getImageData(0,0,e.canvas.width,e.canvas.height).data));return t.every(function(e,t){return ert})}function u(e,t,n){switch(t){caseflag:return n(e,\ud83c\udff3\ufe0f\u200d\u26a7\ufe0f,\ud83c\udff3\ufe0f\u200b\u26a7\ufe0f)?!1:!n(e,\ud83c\uddfa\ud83c\uddf3,\ud83c\uddfa\u200b\ud83c\uddf3)&&!n(e,\ud83c\udff4\udb40\udc67\udb40\udc62\udb40\udc65\udb40\udc6e\udb40\udc67\udb40\udc7f,\ud83c\udff4\u200b\udb40\udc67\u200b\udb40\udc62\u200b\udb40\udc65\u200b\udb40\udc6e\u200b\udb40\udc67\u200b\udb40\udc7f);caseemoji:return!n(e,\ud83e\udef1\ud83c\udffb\u200d\ud83e\udef2\ud83c\udfff,\ud83e\udef1\ud83c\udffb\u200b\ud83e\udef2\ud83c\udfff)}return!1}function f(e,t,n){var rundefined!typeof WorkerGlobalScope&&self instanceof WorkerGlobalScope?new OffscreenCanvas(300,150):i.createElement(canvas),ar.getContext(2d,{willReadFrequently:!0}),o(a.textBaselinetop,a.font600 32px Arial,{});return e.forEach(function(e){oet(a,e,n)}),o}function t(e){var ti.createElement(script);t.srce,t.defer!0,i.head.appendChild(t)}undefined!typeof Promise&&(owpEmojiSettingsSupports,sflag,emoji,n.supports{everything:!0,everythingExceptFlag:!0},enew Promise(function(e){i.addEventListener(DOMContentLoaded,e,{once:!0})}),new Promise(function(t){var nfunction(){try{var eJSON.parse(sessionStorage.getItem(o));if(objecttypeof e&&numbertypeof e.timestamp&&(new Date).valueOf()e.timestamp+604800&&objecttypeof e.supportTests)return e.supportTests}catch(e){}return null}();if(!n){if(undefined!typeof Worker&&undefined!typeof OffscreenCanvas&&undefined!typeof URL&&URL.createObjectURL&&undefined!typeof Blob)try{var epostMessage(+f.toString()+(+JSON.stringify(s),u.toString(),p.toString().join(,)+));,rnew Blob(e,{type:text/javascript}),anew Worker(URL.createObjectURL(r),{name:wpTestEmojiSupports});return void(a.onmessagefunction(e){c(ne.data),a.terminate(),t(n)})}catch(e){}c(nf(s,u,p))}t(n)}).then(function(e){for(var t in e)n.supportstet,n.supports.everythingn.supports.everything&&n.supportst,flag!t&&(n.supports.everythingExceptFlagn.supports.everythingExceptFlag&&n.supportst);n.supports.everythingExceptFlagn.supports.everythingExceptFlag&&!n.supports.flag,n.DOMReady!1,n.readyCallbackfunction(){n.DOMReady!0}}).then(function(){return e}).then(function(){var e;n.supports.everything||(n.readyCallback(),(en.source||{}).concatemoji?t(e.concatemoji):e.wpemoji&&e.twemoji&&(t(e.twemoji),t(e.wpemoji)))}))}((window,document),window._wpemojiSettings);/script>link relstylesheet idmagazine-pro-css hrefhttps://dbadiaries.com/wp-content/themes/magazine-pro/style.css?ver3.7.0 mediaall />style idwp-emoji-styles-inline-css> img.wp-smiley, img.emoji { display: inline !important; border: none !important; box-shadow: none !important; height: 1em !important; width: 1em !important; margin: 0 0.07em !important; vertical-align: -0.1em !important; background: none !important; padding: 0 !important; }/style>link relstylesheet idwp-block-library-css hrefhttps://dbadiaries.com/wp-includes/css/dist/block-library/style.min.css?ver6.4.5 mediaall />style idclassic-theme-styles-inline-css>/*! This file is auto-generated */.wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none}/style>style idglobal-styles-inline-css>body{--wp--preset--color--black: #000000;--wp--preset--color--cyan-bluish-gray: #abb8c3;--wp--preset--color--white: #ffffff;--wp--preset--color--pale-pink: #f78da7;--wp--preset--color--vivid-red: #cf2e2e;--wp--preset--color--luminous-vivid-orange: #ff6900;--wp--preset--color--luminous-vivid-amber: #fcb900;--wp--preset--color--light-green-cyan: #7bdcb5;--wp--preset--color--vivid-green-cyan: #00d084;--wp--preset--color--pale-cyan-blue: #8ed1fc;--wp--preset--color--vivid-cyan-blue: #0693e3;--wp--preset--color--vivid-purple: #9b51e0;--wp--preset--color--theme-primary: #008285;--wp--preset--color--theme-secondary: #008285;--wp--preset--gradient--vivid-cyan-blue-to-vivid-purple: linear-gradient(135deg,rgba(6,147,227,1) 0%,rgb(155,81,224) 100%);--wp--preset--gradient--light-green-cyan-to-vivid-green-cyan: linear-gradient(135deg,rgb(122,220,180) 0%,rgb(0,208,130) 100%);--wp--preset--gradient--luminous-vivid-amber-to-luminous-vivid-orange: linear-gradient(135deg,rgba(252,185,0,1) 0%,rgba(255,105,0,1) 100%);--wp--preset--gradient--luminous-vivid-orange-to-vivid-red: linear-gradient(135deg,rgba(255,105,0,1) 0%,rgb(207,46,46) 100%);--wp--preset--gradient--very-light-gray-to-cyan-bluish-gray: linear-gradient(135deg,rgb(238,238,238) 0%,rgb(169,184,195) 100%);--wp--preset--gradient--cool-to-warm-spectrum: linear-gradient(135deg,rgb(74,234,220) 0%,rgb(151,120,209) 20%,rgb(207,42,186) 40%,rgb(238,44,130) 60%,rgb(251,105,98) 80%,rgb(254,248,76) 100%);--wp--preset--gradient--blush-light-purple: linear-gradient(135deg,rgb(255,206,236) 0%,rgb(152,150,240) 100%);--wp--preset--gradient--blush-bordeaux: linear-gradient(135deg,rgb(254,205,165) 0%,rgb(254,45,45) 50%,rgb(107,0,62) 100%);--wp--preset--gradient--luminous-dusk: linear-gradient(135deg,rgb(255,203,112) 0%,rgb(199,81,192) 50%,rgb(65,88,208) 100%);--wp--preset--gradient--pale-ocean: linear-gradient(135deg,rgb(255,245,203) 0%,rgb(182,227,212) 50%,rgb(51,167,181) 100%);--wp--preset--gradient--electric-grass: linear-gradient(135deg,rgb(202,248,128) 0%,rgb(113,206,126) 100%);--wp--preset--gradient--midnight: linear-gradient(135deg,rgb(2,3,129) 0%,rgb(40,116,252) 100%);--wp--preset--font-size--small: 12px;--wp--preset--font-size--medium: 20px;--wp--preset--font-size--large: 20px;--wp--preset--font-size--x-large: 42px;--wp--preset--font-size--normal: 16px;--wp--preset--font-size--larger: 24px;--wp--preset--spacing--20: 0.44rem;--wp--preset--spacing--30: 0.67rem;--wp--preset--spacing--40: 1rem;--wp--preset--spacing--50: 1.5rem;--wp--preset--spacing--60: 2.25rem;--wp--preset--spacing--70: 3.38rem;--wp--preset--spacing--80: 5.06rem;--wp--preset--shadow--natural: 6px 6px 9px rgba(0, 0, 0, 0.2);--wp--preset--shadow--deep: 12px 12px 50px rgba(0, 0, 0, 0.4);--wp--preset--shadow--sharp: 6px 6px 0px rgba(0, 0, 0, 0.2);--wp--preset--shadow--outlined: 6px 6px 0px -3px rgba(255, 255, 255, 1), 6px 6px rgba(0, 0, 0, 1);--wp--preset--shadow--crisp: 6px 6px 0px rgba(0, 0, 0, 1);}:where(.is-layout-flex){gap: 0.5em;}:where(.is-layout-grid){gap: 0.5em;}body .is-layout-flow > .alignleft{float: left;margin-inline-start: 0;margin-inline-end: 2em;}body .is-layout-flow > .alignright{float: right;margin-inline-start: 2em;margin-inline-end: 0;}body .is-layout-flow > .aligncenter{margin-left: auto !important;margin-right: auto !important;}body .is-layout-constrained > .alignleft{float: left;margin-inline-start: 0;margin-inline-end: 2em;}body .is-layout-constrained > .alignright{float: right;margin-inline-start: 2em;margin-inline-end: 0;}body .is-layout-constrained > .aligncenter{margin-left: auto !important;margin-right: auto !important;}body .is-layout-constrained > :where(:not(.alignleft):not(.alignright):not(.alignfull)){max-width: var(--wp--style--global--content-size);margin-left: auto !important;margin-right: auto !important;}body .is-layout-constrained > .alignwide{max-width: var(--wp--style--global--wide-size);}body .is-layout-flex{display: flex;}body .is-layout-flex{flex-wrap: wrap;align-items: center;}body .is-layout-flex > *{margin: 0;}body .is-layout-grid{display: grid;}body .is-layout-grid > *{margin: 0;}:where(.wp-block-columns.is-layout-flex){gap: 2em;}:where(.wp-block-columns.is-layout-grid){gap: 2em;}:where(.wp-block-post-template.is-layout-flex){gap: 1.25em;}:where(.wp-block-post-template.is-layout-grid){gap: 1.25em;}.has-black-color{color: var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-color{color: var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-color{color: var(--wp--preset--color--white) !important;}.has-pale-pink-color{color: var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-color{color: var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-color{color: var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-color{color: var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-color{color: var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-color{color: var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-color{color: var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-color{color: var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-color{color: var(--wp--preset--color--vivid-purple) !important;}.has-black-background-color{background-color: var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-background-color{background-color: var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-background-color{background-color: var(--wp--preset--color--white) !important;}.has-pale-pink-background-color{background-color: var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-background-color{background-color: var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-background-color{background-color: var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-background-color{background-color: var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-background-color{background-color: var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-background-color{background-color: var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-background-color{background-color: var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-background-color{background-color: var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-background-color{background-color: var(--wp--preset--color--vivid-purple) !important;}.has-black-border-color{border-color: var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-border-color{border-color: var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-border-color{border-color: var(--wp--preset--color--white) !important;}.has-pale-pink-border-color{border-color: var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-border-color{border-color: var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-border-color{border-color: var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-border-color{border-color: var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-border-color{border-color: var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-border-color{border-color: var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-border-color{border-color: var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-border-color{border-color: var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-border-color{border-color: var(--wp--preset--color--vivid-purple) !important;}.has-vivid-cyan-blue-to-vivid-purple-gradient-background{background: var(--wp--preset--gradient--vivid-cyan-blue-to-vivid-purple) !important;}.has-light-green-cyan-to-vivid-green-cyan-gradient-background{background: var(--wp--preset--gradient--light-green-cyan-to-vivid-green-cyan) !important;}.has-luminous-vivid-amber-to-luminous-vivid-orange-gradient-background{background: var(--wp--preset--gradient--luminous-vivid-amber-to-luminous-vivid-orange) !important;}.has-luminous-vivid-orange-to-vivid-red-gradient-background{background: var(--wp--preset--gradient--luminous-vivid-orange-to-vivid-red) !important;}.has-very-light-gray-to-cyan-bluish-gray-gradient-background{background: var(--wp--preset--gradient--very-light-gray-to-cyan-bluish-gray) !important;}.has-cool-to-warm-spectrum-gradient-background{background: var(--wp--preset--gradient--cool-to-warm-spectrum) !important;}.has-blush-light-purple-gradient-background{background: var(--wp--preset--gradient--blush-light-purple) !important;}.has-blush-bordeaux-gradient-background{background: var(--wp--preset--gradient--blush-bordeaux) !important;}.has-luminous-dusk-gradient-background{background: var(--wp--preset--gradient--luminous-dusk) !important;}.has-pale-ocean-gradient-background{background: var(--wp--preset--gradient--pale-ocean) !important;}.has-electric-grass-gradient-background{background: var(--wp--preset--gradient--electric-grass) !important;}.has-midnight-gradient-background{background: var(--wp--preset--gradient--midnight) !important;}.has-small-font-size{font-size: var(--wp--preset--font-size--small) !important;}.has-medium-font-size{font-size: var(--wp--preset--font-size--medium) !important;}.has-large-font-size{font-size: var(--wp--preset--font-size--large) !important;}.has-x-large-font-size{font-size: var(--wp--preset--font-size--x-large) !important;}.wp-block-navigation a:where(:not(.wp-element-button)){color: inherit;}:where(.wp-block-post-template.is-layout-flex){gap: 1.25em;}:where(.wp-block-post-template.is-layout-grid){gap: 1.25em;}:where(.wp-block-columns.is-layout-flex){gap: 2em;}:where(.wp-block-columns.is-layout-grid){gap: 2em;}.wp-block-pullquote{font-size: 1.5em;line-height: 1.6;}/style>link relstylesheet idcrp-style-rounded-thumbs-css hrefhttps://dbadiaries.com/wp-content/plugins/contextual-related-posts/css/rounded-thumbs.min.css?ver3.4.1 mediaall />style idcrp-style-rounded-thumbs-inline-css> .crp_related.crp-rounded-thumbs a { width: 150px; height: 150px; text-decoration: none; } .crp_related.crp-rounded-thumbs img { max-width: 150px; margin: auto; } .crp_related.crp-rounded-thumbs .crp_title { width: 100%; } /style>link relstylesheet idlazyloadxt-fadein-style-css hrefhttps://dbadiaries.com/wp-content/plugins/lazy-load-xt/css/jquery.lazyloadxt.fadein.min.css?ver1.0.6 mediaall />link relstylesheet idpronamic_cookie_style-css hrefhttps://dbadiaries.com/wp-content/plugins/pronamic-cookies/assets/pronamic-cookie-law-style.css?ver6.4.5 mediaall />link relstylesheet iddashicons-css hrefhttps://dbadiaries.com/wp-includes/css/dashicons.min.css?ver6.4.5 mediaall />link relstylesheet idmagazine-pro-fonts-css hrefhttps://fonts.googleapis.com/css?familyRoboto%3A300%2C400%7CRaleway%3A400%2C500%2C900&ver3.7.0 mediaall />link relstylesheet idmagazine-pro-gutenberg-css hrefhttps://dbadiaries.com/wp-content/themes/magazine-pro/lib/gutenberg/front-end.css?ver3.7.0 mediaall />style idmagazine-pro-gutenberg-inline-css>.gb-block-post-grid .gb-block-post-grid-more-link:hover,.gb-block-post-grid header .gb-block-post-grid-title a:hover { color: #008285;}.button-more-link.gb-block-post-grid .gb-block-post-grid-more-link:hover,.gb-block-post-grid .is-grid .gb-block-post-grid-image a .gb-block-post-grid-date,.site-container .wp-block-button .wp-block-button__link { background-color: #008285; color: #ffffff;}.button-more-link.gb-block-post-grid .gb-block-post-grid-more-link:hover,.wp-block-button .wp-block-button__link:not(.has-background),.wp-block-button .wp-block-button__link:not(.has-background):focus,.wp-block-button .wp-block-button__link:not(.has-background):hover { color: #ffffff;}.site-container .wp-block-button.is-style-outline .wp-block-button__link { color: #008285;}.site-container .wp-block-button.is-style-outline .wp-block-button__link:focus,.site-container .wp-block-button.is-style-outline .wp-block-button__link:hover { color: #23a5a8;}.site-container .wp-block-pullquote.is-style-solid-color { background-color: #008285;} .site-container .has-small-font-size { font-size: 12px; } .site-container .has-normal-font-size { font-size: 16px; } .site-container .has-large-font-size { font-size: 20px; } .site-container .has-larger-font-size { font-size: 24px; } .site-container .has-theme-primary-color, .site-container .wp-block-button .wp-block-button__link.has-theme-primary-color, .site-container .wp-block-button.is-style-outline .wp-block-button__link.has-theme-primary-color { color: #008285; } .site-container .has-theme-primary-background-color, .site-container .wp-block-button .wp-block-button__link.has-theme-primary-background-color, .site-container .wp-block-pullquote.is-style-solid-color.has-theme-primary-background-color { background-color: #008285; } .site-container .has-theme-secondary-color, .site-container .wp-block-button .wp-block-button__link.has-theme-secondary-color, .site-container .wp-block-button.is-style-outline .wp-block-button__link.has-theme-secondary-color { color: #008285; } .site-container .has-theme-secondary-background-color, .site-container .wp-block-button .wp-block-button__link.has-theme-secondary-background-color, .site-container .wp-block-pullquote.is-style-solid-color.has-theme-secondary-background-color { background-color: #008285; }/style>link relstylesheet idtablepress-default-css hrefhttps://dbadiaries.com/wp-content/plugins/tablepress/css/build/default.css?ver2.2.5 mediaall />link relstylesheet idenlighterjs-css hrefhttps://dbadiaries.com/wp-content/plugins/enlighter/cache/enlighterjs.min.css?veryd/wItF5+YCJcEK mediaall />script srchttps://dbadiaries.com/wp-content/plugins/google-analytics-for-wordpress/assets/js/frontend-gtag.min.js?ver8.28.0 idmonsterinsights-frontend-script-js type5ce7803cbb2ca33ddea18516-text/javascript>/script>script data-cfasyncfalse data-wpfc-renderfalse idmonsterinsights-frontend-script-js-extra>var monsterinsights_frontend {js_events_tracking:true,download_extensions:doc,pdf,ppt,zip,xls,docx,pptx,xlsx,inbound_paths:{\path\:\\\\/go\\\/\,\label\:\affiliate\},{\path\:\\\\/recommend\\\/\,\label\:\affiliate\},home_url:https:\/\/dbadiaries.com,hash_tracking:false,v4_id:G-NVRY0QG3C6};/script>script srchttps://dbadiaries.com/wp-includes/js/jquery/jquery.min.js?ver3.7.1 idjquery-core-js type5ce7803cbb2ca33ddea18516-text/javascript>/script>script srchttps://dbadiaries.com/wp-includes/js/jquery/jquery-migrate.min.js?ver3.4.1 idjquery-migrate-js type5ce7803cbb2ca33ddea18516-text/javascript>/script>script srchttps://dbadiaries.com/wp-content/plugins/lazy-load-xt/js/jquery.lazyloadxt.extra.min.js?ver1.0.6 idlazy-load-xt-script-js type5ce7803cbb2ca33ddea18516-text/javascript>/script>script srchttps://dbadiaries.com/wp-content/plugins/lazy-load-xt/js/jquery.lazyloadxt.srcset.min.js?ver1.0.6 idlazy-load-xt-srcset-js type5ce7803cbb2ca33ddea18516-text/javascript>/script>script idpronamic_cookie_js-js-extra type5ce7803cbb2ca33ddea18516-text/javascript>var Pronamic_Cookies_Vars {cookie:{path:\/,expires:Thu, 23 Oct 2025 19:49:14 GMT}};/script>script srchttps://dbadiaries.com/wp-content/plugins/pronamic-cookies/assets/pronamic-cookie-law.js?ver6.4.5 idpronamic_cookie_js-js type5ce7803cbb2ca33ddea18516-text/javascript>/script>link relhttps://api.w.org/ hrefhttps://dbadiaries.com/wp-json/ />link relEditURI typeapplication/rsd+xml titleRSD hrefhttps://dbadiaries.com/xmlrpc.php?rsd />meta namegenerator contentWordPress 6.4.5 />link relicon hrefhttps://dbadiaries.com/wp-content/themes/magazine-pro/images/favicon.ico />link relpingback hrefhttps://dbadiaries.com/xmlrpc.php />script async srchttps://www.googletagmanager.com/gtag/js?idUA-3614103-5 type5ce7803cbb2ca33ddea18516-text/javascript>/script>script type5ce7803cbb2ca33ddea18516-text/javascript> window.dataLayer window.dataLayer || ; function gtag(){dataLayer.push(arguments);} gtag(js, new Date()); gtag(config, UA-3614103-5);/script>/head>body classhome blog wp-embed-responsive header-full-width content-sidebar genesis-breadcrumbs-hidden genesis-footer-widgets-hidden itemscope itemtypehttps://schema.org/WebPage>div classsite-container>ul classgenesis-skip-link>li>a href#genesis-content classscreen-reader-shortcut> Skip to main content/a>/li>li>a href#genesis-sidebar-primary classscreen-reader-shortcut> Skip to primary sidebar/a>/li>/ul>header classsite-header itemscope itemtypehttps://schema.org/WPHeader>div classwrap>div classtitle-area>h1 classsite-title itempropheadline>a hrefhttps://dbadiaries.com/>DBA Diaries/a>/h1>p classsite-description itempropdescription>Thoughts and experiences of a DBA working with SQL Server and MySQL/p>/div>/div>/header>div classsite-inner>div classcontent-sidebar-wrap>main classcontent idgenesis-content>article classpost-6402 post type-post status-publish format-standard category-all-articles category-sql-tips-and-tricks tag-mysql tag-sql-server entry aria-labelHow to fix “conversion failed when converting date and/or time from character string” itemscope itemtypehttps://schema.org/CreativeWork>header classentry-header>h2 classentry-title itempropheadline>a classentry-title-link relbookmark hrefhttps://dbadiaries.com/how-to-fix-conversion-failed-when-converting-date-and-or-time-from-character-string>How to fix “conversion failed when converting date and/or time from character string”/a>/h2>p classentry-meta>time classentry-time itempropdatePublished datetime2023-04-30T13:42:55+00:00>April 30, 2023/time> by span classentry-author itempropauthor itemscope itemtypehttps://schema.org/Person>a hrefhttps://dbadiaries.com/author/admin classentry-author-link relauthor itempropurl>span classentry-author-name itempropname>Andy Hayes/span>/a>/span> span classentry-comments-link>a hrefhttps://dbadiaries.com/how-to-fix-conversion-failed-when-converting-date-and-or-time-from-character-string#respond>Leave a Comment/a>/span> /p>/header>div classentry-content itemproptext>p>Bad data - its everywhere and a common problem is badly formatted dates. conversion failed when converting date and/or time from character string is the message returned in such situations.Its not unique to SQL and will be seen in other languages such as Python, C#, Java and others.In this post, we look at the why and how you can fix it.Getting to the bottom of … a hrefhttps://dbadiaries.com/how-to-fix-conversion-failed-when-converting-date-and-or-time-from-character-string classmore-link>Read more... span classscreen-reader-text>about How to fix “conversion failed when converting date and/or time from character string”/span>/a>/p>/div>/article>article classpost-6368 post type-post status-publish format-standard category-all-articles category-sql-tips-and-tricks tag-postgresql tag-sql-2 tag-sql-server entry has-post-thumbnail aria-labelUsing SQL GROUPING SETS for Multiple GROUP BY Queries in a Single Query itemscope itemtypehttps://schema.org/CreativeWork>header classentry-header>h2 classentry-title itempropheadline>a classentry-title-link relbookmark hrefhttps://dbadiaries.com/using-sql-grouping-sets-for-multiple-group-by-queries-in-a-single-query>Using SQL GROUPING SETS for Multiple GROUP BY Queries in a Single Query/a>/h2>p classentry-meta>time classentry-time itempropdatePublished datetime2023-04-30T10:29:35+00:00>April 30, 2023/time> by span classentry-author itempropauthor itemscope itemtypehttps://schema.org/Person>a hrefhttps://dbadiaries.com/author/admin classentry-author-link relauthor itempropurl>span classentry-author-name itempropname>Andy Hayes/span>/a>/span> span classentry-comments-link>a hrefhttps://dbadiaries.com/using-sql-grouping-sets-for-multiple-group-by-queries-in-a-single-query#respond>Leave a Comment/a>/span> /p>/header>div classentry-content itemproptext>a classentry-image-link hrefhttps://dbadiaries.com/using-sql-grouping-sets-for-multiple-group-by-queries-in-a-single-query aria-hiddentrue tabindex-1>img width150 height150 srchttps://dbadiaries.com/wp-content/uploads/2023/04/sql-grouping-sets-150x150.png classalignleft post-image entry-image altsql grouping sets itempropimage decodingasync srcsethttps://dbadiaries.com/wp-content/uploads/2023/04/sql-grouping-sets-150x150.png 150w, https://dbadiaries.com/wp-content/uploads/2023/04/sql-grouping-sets-100x100.png 100w sizes(max-width: 150px) 100vw, 150px />/a>p>SQL GROUPING SETS is a feature of the SQL language that allows you to specify multiple group by sets in a single query.The best way to demonstrate this is with code and examples.So imagine you have table of sales data which contained the following fields:productregionsale_amountA visual of this would look like:Now say you had a requirement to … a hrefhttps://dbadiaries.com/using-sql-grouping-sets-for-multiple-group-by-queries-in-a-single-query classmore-link>Read more... span classscreen-reader-text>about Using SQL GROUPING SETS for Multiple GROUP BY Queries in a Single Query/span>/a>/p>/div>/article>article classpost-6163 post type-post status-publish format-standard category-mysql-administration tag-mysql tag-replication entry has-post-thumbnail aria-labelHow to Setup MySQL Master Master Replication itemscope itemtypehttps://schema.org/CreativeWork>header classentry-header>h2 classentry-title itempropheadline>a classentry-title-link relbookmark hrefhttps://dbadiaries.com/how-to-setup-mysql-master-master-replication>How to Setup MySQL Master Master Replication/a>/h2>p classentry-meta>time classentry-time itempropdatePublished datetime2018-04-04T15:42:05+00:00>April 4, 2018/time> by span classentry-author itempropauthor itemscope itemtypehttps://schema.org/Person>a hrefhttps://dbadiaries.com/author/admin classentry-author-link relauthor itempropurl>span classentry-author-name itempropname>Andy Hayes/span>/a>/span> span classentry-comments-link>a hrefhttps://dbadiaries.com/how-to-setup-mysql-master-master-replication#comments>1 Comment/a>/span> /p>/header>div classentry-content itemproptext>a classentry-image-link hrefhttps://dbadiaries.com/how-to-setup-mysql-master-master-replication aria-hiddentrue tabindex-1>img width150 height150 srchttps://dbadiaries.com/wp-content/uploads/2018/04/mysql-master-master-replication-150x150.jpg classalignleft post-image entry-image altmysql master master replication itempropimage decodingasync loadinglazy />/a>p>MySQL master master replication, also known as mysql chained replication, multi master replication or mysql daisy chaining replication is an extension of mysql replication allowing the creation of multiple master servers that can then be masters of multiple slaves. In this post, I demonstrate how to setup mysql master master replication.In a multi master mysql … a hrefhttps://dbadiaries.com/how-to-setup-mysql-master-master-replication classmore-link>Read more... span classscreen-reader-text>about How to Setup MySQL Master Master Replication/span>/a>/p>/div>/article>article classpost-6192 post type-post status-publish format-standard category-sql-tips-and-tricks tag-mysql tag-sql-server entry has-post-thumbnail aria-labelHow To Use SQL to Convert a STRING to an INT itemscope itemtypehttps://schema.org/CreativeWork>header classentry-header>h2 classentry-title itempropheadline>a classentry-title-link relbookmark hrefhttps://dbadiaries.com/how-to-use-sql-to-convert-a-string-to-an-int>How To Use SQL to Convert a STRING to an INT/a>/h2>p classentry-meta>time classentry-time itempropdatePublished datetime2017-11-25T17:26:19+00:00>November 25, 2017/time> by span classentry-author itempropauthor itemscope itemtypehttps://schema.org/Person>a hrefhttps://dbadiaries.com/author/admin classentry-author-link relauthor itempropurl>span classentry-author-name itempropname>Andy Hayes/span>/a>/span> span classentry-comments-link>a hrefhttps://dbadiaries.com/how-to-use-sql-to-convert-a-string-to-an-int#respond>Leave a Comment/a>/span> /p>/header>div classentry-content itemproptext>a classentry-image-link hrefhttps://dbadiaries.com/how-to-use-sql-to-convert-a-string-to-an-int aria-hiddentrue tabindex-1>img width150 height150 srchttps://dbadiaries.com/wp-content/uploads/2017/11/sql-convert-string-to-int-150x150.jpg classalignleft post-image entry-image altsql convert string to int itempropimage decodingasync loadinglazy />/a>p>Using SQL to convert a string to an int is used in a variety of situations. You may have text data that you cannot alter at the source and you need to get some accurate answers from it. You may also have text data that you want to insert to an integer column. There could be other reasons too.There is an easy solution to this and I will show you examples in both SQL Server … a hrefhttps://dbadiaries.com/how-to-use-sql-to-convert-a-string-to-an-int classmore-link>Read more... span classscreen-reader-text>about How To Use SQL to Convert a STRING to an INT/span>/a>/p>/div>/article>article classpost-5115 post type-post status-publish format-standard category-mysql-administration tag-mysql entry has-post-thumbnail aria-labelHow to set up MySQL Replication Tutorial itemscope itemtypehttps://schema.org/CreativeWork>header classentry-header>h2 classentry-title itempropheadline>a classentry-title-link relbookmark hrefhttps://dbadiaries.com/how-to-set-up-mysql-replication>How to set up MySQL Replication Tutorial/a>/h2>p classentry-meta>time classentry-time itempropdatePublished datetime2017-11-11T11:57:32+00:00>November 11, 2017/time> by span classentry-author itempropauthor itemscope itemtypehttps://schema.org/Person>a hrefhttps://dbadiaries.com/author/admin classentry-author-link relauthor itempropurl>span classentry-author-name itempropname>Andy Hayes/span>/a>/span> span classentry-comments-link>a hrefhttps://dbadiaries.com/how-to-set-up-mysql-replication#comments>1 Comment/a>/span> /p>/header>div classentry-content itemproptext>a classentry-image-link hrefhttps://dbadiaries.com/how-to-set-up-mysql-replication aria-hiddentrue tabindex-1>img width150 height150 srchttps://dbadiaries.com/wp-content/uploads/2017/11/setup-mysql-replication-master-config-file-150x150.jpg classalignleft post-image entry-image altsetup mysql replication master config file itempropimage decodingasync loadinglazy />/a>p>One may setup MySQL replication typically either to scale out, facilitate reporting or to provide backups of MySQL databases. I wrote a post about this before.The whole process relies on binary logs which are output to a location on the master server and read in by the slave.This post is a MySQL replication tutorial. I am going to setup MySQL replication involving two My … a hrefhttps://dbadiaries.com/how-to-set-up-mysql-replication classmore-link>Read more... span classscreen-reader-text>about How to set up MySQL Replication Tutorial/span>/a>/p>/div>/article>div classarchive-pagination pagination>div classpagination-next alignright>a hrefhttps://dbadiaries.com/page/2>Next Page »/a>/div>/div>/main>aside classsidebar sidebar-primary widget-area rolecomplementary aria-labelPrimary Sidebar itemscope itemtypehttps://schema.org/WPSideBar idgenesis-sidebar-primary>h2 classgenesis-sidebar-title screen-reader-text>Primary Sidebar/h2>section idcategories-2 classwidget widget_categories>div classwidget-wrap>h3 classwidgettitle widget-title>Categories/h3>ul>li classcat-item cat-item-100>a hrefhttps://dbadiaries.com/category/all-articles>All Articles/a> (84)/li>li classcat-item cat-item-5>a hrefhttps://dbadiaries.com/category/career-development>Career Development/a> (8)/li>li classcat-item cat-item-102>a hrefhttps://dbadiaries.com/category/all-articles/mysql-administration>MySQL Administration/a> (18)/li>li classcat-item cat-item-106>a hrefhttps://dbadiaries.com/category/all-articles/mysql-performance>MySQL Performance/a> (2)/li>li classcat-item cat-item-101>a hrefhttps://dbadiaries.com/category/all-articles/sql-server-administration>SQL Server Administration/a> (24)/li>li classcat-item cat-item-103>a hrefhttps://dbadiaries.com/category/all-articles/sql-server-news>SQL Server News/a> (3)/li>li classcat-item cat-item-104>a hrefhttps://dbadiaries.com/category/all-articles/sql-server-performance>SQL Server Performance/a> (14)/li>li classcat-item cat-item-105>a hrefhttps://dbadiaries.com/category/all-articles/sql-server-security>SQL Server Security/a> (3)/li>li classcat-item cat-item-11>a hrefhttps://dbadiaries.com/category/all-articles/sql-tips-and-tricks>SQL Tips and Tricks/a> (21)/li>/ul>/div>/section>section idajax_hits_counter_popular_posts_widget-2 classwidget ajax_hits_counter_popular_posts_widget>div classwidget-wrap>h3 classwidgettitle widget-title>Top 10 Popular Posts/h3>ul>li classitem-num-1 item-id-3235>span classentry-content>a hrefhttps://dbadiaries.com/using-sp_change_users_login-to-fix-sql-server-orphaned-users titleUsing sp_change_users_login to fix SQL Server orphaned users>Using sp_change_users_login to fix SQL Server orphaned users/a>/span>/li>li classitem-num-2 item-id-5254>span classentry-content>a hrefhttps://dbadiaries.com/no-mysql-show-users-how-to-list-mysql-user-accounts-and-their-privileges titleMySQL SHOW USERS? – How to List All MySQL Users and Privileges>MySQL SHOW USERS? – How to List All MySQL Users and Privileges/a>/span>/li>li classitem-num-3 item-id-347>span classentry-content>a hrefhttps://dbadiaries.com/how-to-shrink-tempdb titleHow to shrink tempdb>How to shrink tempdb/a>/span>/li>li classitem-num-4 item-id-3127>span classentry-content>a hrefhttps://dbadiaries.com/how-to-transfer-logins-to-another-sql-server-or-instance titleHow to Transfer Logins to Another SQL Server or Instance>How to Transfer Logins to Another SQL Server or Instance/a>/span>/li>li classitem-num-5 item-id-3627>span classentry-content>a hrefhttps://dbadiaries.com/how-to-delete-millions-of-rows-using-t-sql-with-reduced-impact titleHow to Delete Millions of Rows using T-SQL with Reduced Impact>How to Delete Millions of Rows using T-SQL with Reduced Impact/a>/span>/li>li classitem-num-6 item-id-5608>span classentry-content>a hrefhttps://dbadiaries.com/t-sql-how-to-select-top-n-rows-for-each-group-using-row_number titleT-SQL – How to Select Top N Rows for Each Group Using ROW_NUMBER()>T-SQL – How to Select Top N Rows for Each Group Using ROW_NUMBER()/a>/span>/li>li classitem-num-7 item-id-1570>span classentry-content>a hrefhttps://dbadiaries.com/new-t-sql-features-in-sql-server-2012-offset-and-fetch titleNew T-SQL features in SQL Server 2012 – OFFSET and FETCH>New T-SQL features in SQL Server 2012 – OFFSET and FETCH/a>/span>/li>li classitem-num-8 item-id-5224>span classentry-content>a hrefhttps://dbadiaries.com/how-to-kill-all-mysql-processes-for-a-specific-user titleHow to Kill All MySQL Processes For a Specific User>How to Kill All MySQL Processes For a Specific User/a>/span>/li>li classitem-num-9 item-id-2378>span classentry-content>a hrefhttps://dbadiaries.com/using-sp_who2-to-help-with-sql-server-troubleshooting titleUsing exec sp_who2 to help with SQL Server troubleshooting>Using exec sp_who2 to help with SQL Server troubleshooting/a>/span>/li>li classitem-num-10 item-id-11>span classentry-content>a hrefhttps://dbadiaries.com/how-to-move-tempdb titleHow to move tempdb>How to move tempdb/a>/span>/li>/ul>/div>/section>section idrecent-posts-2 classwidget widget_recent_entries>div classwidget-wrap>h3 classwidgettitle widget-title>Recent Posts/h3>ul>li>a hrefhttps://dbadiaries.com/how-to-fix-conversion-failed-when-converting-date-and-or-time-from-character-string>How to fix “conversion failed when converting date and/or time from character string”/a>/li>li>a hrefhttps://dbadiaries.com/using-sql-grouping-sets-for-multiple-group-by-queries-in-a-single-query>Using SQL GROUPING SETS for Multiple GROUP BY Queries in a Single Query/a>/li>li>a hrefhttps://dbadiaries.com/how-to-setup-mysql-master-master-replication>How to Setup MySQL Master Master Replication/a>/li>li>a hrefhttps://dbadiaries.com/how-to-use-sql-to-convert-a-string-to-an-int>How To Use SQL to Convert a STRING to an INT/a>/li>li>a hrefhttps://dbadiaries.com/how-to-set-up-mysql-replication>How to set up MySQL Replication Tutorial/a>/li>/ul>/div>/section>section idsearch-2 classwidget widget_search>div classwidget-wrap>h3 classwidgettitle widget-title>Search/h3>form classsearch-form methodget actionhttps://dbadiaries.com/ rolesearch itemproppotentialAction itemscope itemtypehttps://schema.org/SearchAction>label classsearch-form-label screen-reader-text forsearchform-1>Search the site .../label>input classsearch-form-input typesearch names idsearchform-1 placeholderSearch the site ... itempropquery-input>input classsearch-form-submit typesubmit valueSearch>meta contenthttps://dbadiaries.com/?s{s} itemproptarget>/form>/div>/section>section idnav_menu-6 classwidget widget_nav_menu>div classwidget-wrap>h3 classwidgettitle widget-title>Connect/h3>div classmenu-social-container>ul idmenu-social classmenu>li idmenu-item-4459 classtwitter-prl-s32 menu-item menu-item-type-custom menu-item-object-custom menu-item-4459>a titleTwitter hrefhttps://twitter.com/andyhayes7 itempropurl>Twitter/a>/li>li idmenu-item-4460 classfacebook-prl-s32 menu-item menu-item-type-custom menu-item-object-custom menu-item-4460>a titleFacebook hrefhttps://facebook.com/dbadiaries itempropurl>Facebook/a>/li>li idmenu-item-4480 classfeed-prl-s32 menu-item menu-item-type-custom menu-item-object-custom menu-item-4480>a titleRSS hrefhttps://dbadiaries.com/feed itempropurl>RSS/a>/li>/ul>/div>/div>/section>section idnav_menu-7 classwidget widget_nav_menu>div classwidget-wrap>h3 classwidgettitle widget-title>About/h3>div classmenu-footer-menu-container>ul idmenu-footer-menu classmenu>li idmenu-item-4472 classmenu-item menu-item-type-post_type menu-item-object-page menu-item-4472>a hrefhttps://dbadiaries.com/cookie-policy itempropurl>Cookie Policy/a>/li>li idmenu-item-4473 classmenu-item menu-item-type-post_type menu-item-object-page menu-item-4473>a hrefhttps://dbadiaries.com/disclaimer itempropurl>Disclaimer/a>/li>li idmenu-item-4474 classmenu-item menu-item-type-post_type menu-item-object-page menu-item-4474>a hrefhttps://dbadiaries.com/about itempropurl>About/a>/li>/ul>/div>/div>/section>/aside>/div>/div>footer classsite-footer itemscope itemtypehttps://schema.org/WPFooter>div classwrap>Copyright © script src/cdn-cgi/scripts/7d0fa10a/cloudflare-static/rocket-loader.min.js data-cf-settings5ce7803cbb2ca33ddea18516-|49 defer>/script>
View on OTX
|
View on ThreatMiner
Please enable JavaScript to view the
comments powered by Disqus.
Data with thanks to
AlienVault OTX
,
VirusTotal
,
Malwr
and
others
. [
Sitemap
]