×

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

My Stackexchange Profile

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

Preparing for my presentation to #Vermont SQL User Group on Tuesday.
https://www.meetup.com/VTCode/events/267938985/

... http://sqlworldwide.com/vermont-sql-server-user-group/

@sqlpass
#MVPbuzz

Load More...