×

SQL Agent Jobs With Notification Enabled

January 8, 2016

DBA team that I worked with manage 170+ SQL Servers. We do not enable notification on any SQL Agent job. We centrally monitor all jobs and send a notification based on the tier (Business-critical). Last night on-call DBA got paged for a job failed in the server we are doing proof of concept. By looking […]

What Is Consuming My Log Space

October 2, 2015

Often times DBA’s (including myself at the beginning of my DBA career) struggle to find out what is causing the log files to grow. Or what is consuming all the space in my log files. I understand there are many factors that can impact the log file size besides all the active transactions. Such as: […]

Manage SQL Agent Job History

October 2, 2015

Recently in one of our server row count in MSDB.DBO.SysJobHistory table exceeded 100 Million and looking at job history was slow via SSMS. It was impossible via the GUI. Because we had about 50 jobs that were running frequently (called from a listener mostly once in every 2 to 3 minutes). I was curious if […]

List All Objects In FileGroup with Size

May 7, 2015

Recently at my work due to low free space on a LUN I was forced to rebuild few indexes on a different filegroup (which resides on a different LUN). I wanted to list all user objects belong to a single filegroup including size. I did not find a query online with everything I needed. So […]

Fix High or Low VLF Count

February 26, 2015

We started collecting a count of all VLF across the enterprise and yes there were few with high counts. I know there are no SET guidelines on how many is too low or too high. After chatting with MVP Allen Kinsel (Blog|Twitter) and Kevin Conan (Twitter) I decided to fix using this threshold. You will […]


profile for SqlWorldWide on Stack Exchange, a network of free, community-driven Q&A sites

Kubernetes Learning Path

50-days from zero to
hero with Kubernetes

Download eBook

Hey #AzureDataCommunity leaders, the info went out today for our Leader Summit in October. Check your inbox & add an... hour to your calendar that works best for your schedule. We're looking forward to connecting, networking and learning!

#DPS2021 Updates:
Starting now: Sessions by @dbanuggets, @tommartens68, Paul Ou Yang, @feaselkl, @pookamath, @blakhani
... Data+AI Gurukul by @jamesbroome_ , @chanmm
Join us for FREE: https://bit.ly/dps_2021
Thanks for RT
#Azure #analytics #AzureSQL #sql #SQLServer #PowerBI #DPS10

Surbhi Pokharna presents Applying a Security Mindset to Lock Down Azure SQL DB at #PASSDataCommunitySummit Register ... today! @PASSDataSummit #AzureSQL #Azure

Search the list of sessions here: http://ow.ly/NnUq50G2q6r and register for FREE today: http://ow.ly/J3YZ50G2pgu

My wife is a nurse. She quietly & humbly does her work. That work presently is on a full blown covid unit where she ... gets insulted by unvaccinated patients. Now to know she is being “protested” by the very type of people she is caring for is beyond enraging. #AbLeg

Load More...
/* (function () { var s = document.createElement('script'); s.type = 'text/javascript'; s.async = true; s.src = 'https://app.termly.io/embed.min.js'; s.id = '4f4146f3-eaa6-4e46-8f46-3fc9f2223b5f'; s.setAttribute("data-name", "termly-embed-banner"); var x = document.getElementsByTagName('script')[0]; x.parentNode.insertBefore(s, x); })(); */