×

TSQL Tuesday #89 -My Learning Steps to Azure

April 11, 2017

I thank Koen Verbeeck (b|t) for hosting TSQL Tuesday #89. Topic for this month The times they are a-changing inspired by the blog post Will the Cloud Eat My DBA Job? by Kendra Little. I was glad to see this topic was chosen. I clearly remembered reading this blog post and thanking kendra for writing […]

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


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

Check out this awesome lineup of #speakers for #COVID19 fundraiser Lightup Virtual Conference! Register now: ... https://2020twenty.net/lightup/ cc @thetechplatform @mitul_rana @jpomfret @SQLStad @SqlWorldWide @yashkamdar391 @PabloJavier911 @darkicebeam @PabloDiLoreto

Folks, I'm excited to speak at the #LightUp conference next week, it's 24 hours of fun. You can catch my dbatools ... session on Wednesday morning (4am EDT, 9am BST)

I'm super thrilled & honored that my "Notebooks 101 for SQL People session" has been selected as part of UNICEF ... #COVID19 #Lightup fundraising event. Tune in on July 14 at 9PM EDT. Register & donate: https://events.unicefusa.org/event/lightup2020 🙏
Check out the schedule here:
https://www.2020twenty.net/lightup/

Load More...