×

Warning: Non-existent Step Referenced While Creating SQL Agent Job

April 6, 2017

Today there was a question submitted in dba.stackexchange.com with the heading “Suppressing non-ANSI warnings in SQLCMD script”. Details here. In summary, this happens when you use a script to create a SQL Agent job and one of the job steps has conditions (under advanced properties) to go to certain steps in case of success or […]

How to Exclude Read_Only Databases Using sp_MSforeachdb

March 28, 2017

I will explain how you can use sp_MSforeachdb stored procedure against READ_WRITE database only. There are numerous articles on the web about excluding databases using database id or name. Recently I needed a script to run against databases that are part of Always On Availability Groups and in READ_WRITE status. I used the ‘Updateability’ properties […]

TSQL to Find Status of SQL Server Statistics

March 19, 2017

About two years ago, I was working on an update statistics solution for 15 TB OLTP database.   The first thing I needed to know, is the status of statistics.   With a google search, I landed into this blog post by Erin Stellato (blog | Twitter) from SQLskills. Which gave me a perfect head start. […]

Free Azure Credit

March 16, 2017

There are multiple ways you can get free Azure credit, which can add up to $500 for one year. With a Microsoft account and one of these free credit options you can open an Azure account. You will be able to use this account for any Azure service based on your needs including, Virtual Machines, […]

TSQL Tuesday #88 -Communication is the Key

March 14, 2017

I thank Kennie Nybo Pontoppidan (b|t) for hosting TSQL Tuesday #88. The topic for this month is the daily database-related WT……. Last week I was setting up a collection of wait statistics with five minutes interval using a while loop. I was wrapping up Paul Randal’s (b|t) code from this blog post in a loop […]


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...