×

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 […]

Which Node SQL Cluster was Running

February 20, 2015

While troubleshooting unplanned SQL cluster failover few questions are asked commonly. When did the last failover occur? How frequently you failover (planned and unplanned)? Did this happen recently? All these questions can be answered by this query.  Your output will depend on how frequently you recycle error log and retention of the error log. You […]

Optimize SQL Backup

January 13, 2015

Database backup is one of the regular tasks DBA’s perform but few explore all the options that are built in the product. Instead of exploring and using built in switches I noticed DBA’s try writing custom scripts or buying third party tools. I explored some of the options and was able to do a full […]

Find Transactional Replication Details

November 21, 2014

This will be a quick post about a script to find replication metadata in detail.  You need to run this in your distributor (where distribution database resides) server and filter in various ways depending on your needs.  Also, modify the order based on what you are looking for. Run where distribution database resides


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

I'm expecting a lot of my followers to follow this diagram and end up at Database Reliability Engineering.

So I suppose... I owe @BrentO a thank you for effectively writing that part of this blog post for me!
https://octopus.com/blog/devops-reading-list

#sqlhelp
#AzureSupport
Anyone know how to get to these section in portal. I know how to configure this using PowerShell ... .
I am not seeing this while creating new database.

https://docs.microsoft.com/en-us/azure/azure-sql/database/automated-backups-overview?tabs=single-database#configure-backup-storage-redundancy-by-using-the-azure-portal

Are you a Data Professional?
Do you have a Dream to become a Public Speaker but struggle with self-doubt?
Then this ... article is for you!
@NewStarsOfData
https://dbanuggets.com/2020/11/21/take-that-first-step-in-faith-rest-will-pave-its-path-to-your-speaking-journey/

#sqlsatmontreal organizers thank you for work and opportunity.
Flawless execution.
Thanks to all speakers, sponsors, ... volunteers and attendees.

#sqlpass

Load More...