ICYMI: There will be an awesome talk in a couple of minutes.
@Jpomfret will talk about #dbatools and how to manage #replication with them.
Make your #DBA life easier

https://www.meetup.com/de-DE/data-tgif/events/294744117

#SQLServer #PowerShell

/cc @dbatools

New blog post.

My world the past 6 months and the future of SQL Agent Insight.

https://brentec.ca/blog/2023/08/the-last-six-months-and-the-future-of-sql-agent-insight/

#sqlserver #dba #monitoring

New blog post.

The last 6 months and the future of SQL Agent Insight.

https://brentec.ca/blog/2023/08/the-last-six-months-and-the-future-of-sql-agent-insight/

#sqlserver #dba #monitoring

52 years and people still can't spell the name.

#NationalRailroadPassengerCorp #DBA #Amtrak #noC

Quick questions for all y’all #DevOps and #DBA #MSSQL peeps. How do you handle database index creation?

Do you create them first in the database itself and then add it to your SQL database project?

Do you create them inside your SQL database project and then push it to PROD using CI/CD?

Or you treat it as something completely different?

A moment of silence.
Maybe I'm late to the party but this just crossed my desk:
https://www.reddit.com/r/sysadmin/comments/12rvvqi/lost_a_legend_this_year/

Don Burleson, of Burleson Consultong, best known for the website dba-oracle.com, passed away in January.

This guy saved the day for myself and so many DBAs over the years. His website pops up in the results any time you search for something about Oracle database. Every single time.

Rest in peace, savior of the database

#oracle #oracleDatabase #dba #burleson

#scrum #scrummaster #productowner #developer #qa #devops #DBA #uiuxdesigner

RT @HLAvocats: L'amphithéâtre Devinci Executive Education accueille la #conference inaugurable de @corinnelepage pour l’ouverture du MBA #Management de la #TransitionEnergetique avec #FabienGuimtrandy, #DBA, Président du Directoire, et #ThierryVincent, Directeur du #MBA.

🐦🔗: https://n.respublicae.eu/corinnelepage/status/1638625619482124299

SQL Agent Insight is agentless, nothing is installed on your #sqlserver, ever, nor is there any client-side installation required either.
#TSQL and #SMO are the only methods of gathering the data that you require, and the SMO libraries are included, meaning no other installations are necessary.

Manage your SQL Server Agent estate with SQL Agent Insight. Download for free and use without feature restrictions.

https://brentec.ca

#DBA #monitoring

Exclusive to SQL Agent Insight, the ability to pause and resume #sqlserver agent jobs! With custom server side code (optional), you have the ability to pause agent jobs and resume them at a future date/time of your choosing. No more forgotten jobs to enable manually! A simple feature, but useful during maintenance, and SQL Agent Insight doesn't have to be running to resume the jobs!

Download for free and use without feature restrictions, https://brentec.ca

#DBA #monitoring #pcsoftware

SQL Agent Insight's job history for #sqlserver agent is a great alternative to SSMS. It has the capability to load history information containing 100's of thousands of records, something that would cause log viewer in SSMS to error. Plus, the job history charts the 100 most recent job runs and their timings for a quick review of the job's outcomes which can be useful to hone in on a problem run.

Try for free without feature restrictions. Download at https://brentec.ca

#DBA #monitoring

Don't want to write cumbersome T-SQL queries to figure out what is going on with your #SQLServer #database mail?

Get access to database mail, profiles and accounts within your SQL Server agent instance quickly with SQL Agent Insight.

·DB mail profiles and accounts in a single view, no wizard traversal.
·Gain access to database mail items; quickly see which mail has been sent, not sent, retrying or has failed.

Download and use for free. https://brentec.ca

#DBA #monitoring

SQL Agent Insight makes scripting of #sqlserver agent jobs a breeze. Scripting jobs for #backup purposes, or for transferring them to another instance, SQL Agent Insight has the options for you or your #DBA.

Scripting of all jobs can be done in only a couple of clicks.

Download and use for free with no feature restrictions. https://brentec.ca

https://brentec.casql-agent-insight/features/

Have a large #SQLServer Agent estate to manage? Make it easier with SQL Agent Insight.
I've created this utility as a side project over the years and with the recent addition of being able to create/edit SQL agent jobs, it can now be used as your go-to method for working with SQL Server agent.

Check out some of the features:
https://brentec.ca/sql-agent-insight/features/

#DBA #monitoring

SQL Agent Insight has the capability to "see into the future" by showing you upcoming scheduled #sqlserver agent jobs. A lot of products can easily show job history, but SQL Agent Insight was one of the first, if not the first, to show future scheduled jobs and any conflicts those jobs may have.

Try and use for free, with no feature restrictions. Download at https://brentec.ca.

Check out other features: https://brentec.ca/sql-agent-insight/features/

#DBA #monitoring

Want to use a better alternative to #sqlserver management studio for your SQL Agent estate? Check out SQL Agent Insight @ brentec.ca.

Download it, use it, without feature restrictions.

https://brentec.ca/sql-agent-insight/features/

#DBA #monitoring

SQL Agent Insight's dashboard has everything you need to see at a glance for all of your #sqlserver agent #monitored instances. Easily filter alerts and see the status of each instance in an easy to view color coded topology.

Download and use for free, without feature restrictions @ brentec.ca.

While you are there, check out many of the other features.

https://brentec.ca/sql-agent-insight/features/

#DBA #monitoring

SQL Agent Insight 0.27 is available with features to allow your #DBA to effortlessly discover long running #sqlserver agent jobs.

Download and use for free without feature restrictions @ brentec.ca

https://brentec.ca/sql-agent-insight/features/

#monitoring

SQL Agent Insight has over 60 configurable #sqlserver agent metrics that can alert you via email when one of the thresholds has been breached. Give it a try, download for free, without any feature restrictions.

#DBA #monitoring

https://brentec.ca/sql-agent-insight/features/

SQL Agent Insight 0.27 is available with it's latest feature to create native #sqlserver agent jobs.

#DBA #monitoring

https://brentec.ca/sql-agent-insight/change-log/