×

Meta Data

Data Discovery and Classification -How it is Done?

March 11, 2018

On February 15, 2018, SQL Server Management Studio 17.5 was released. A new feature called “Data Discovery & Classification” was launched with this release. You can read about this feature in the following posts. SQL Data Discovery and Classification What’s new in SSMS 17.5: Data Discovery and Classification Since this feature was released a common question was […]

Reading All Available SQL Error logs

November 15, 2017

There are many blog posts available online about reading SQL Server Error Log or SQL Server Agent Error Log. What I needed was to search for a string (or string within a string) in all available error logs. Save the results in a table. That way I can find the frequency and pattern of the […]

TSQL2sday #94 Get-DbaRegisteredServerName | Power of dbatools

September 12, 2017

I thank Rob Sewell (b|t) for hosting TSQL Tuesday #94. Topic for this month Let’s get all Posh – What are you going to automate today?. If you are a database professional most likely you heard of dbatools by this time. Dbatools is a free PowerShell module with over 200 SQL server administration, best practice […]

NULL Values in Histogram

May 26, 2017

During my cardinality estimator presentation in DBA virtual group, there was a question asked about NULL values and histograms. I am quoting the question as is “SQL Server include null values in the index. How are statistics handle null values?” I will answer the question in this blog post. For demo purposes, I will be […]

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


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 will be speaking at @PASSCloudVC in 3 hours.
10 am PST
1 pm EST
17:00 UTC

Azure SQL Database - Where is my SQL ... Agent?
Registration: https://cloud.pass.org/
#sqlpass #MVPBuzz

#SQLFriday is free Microsoft Data Platform training, delivered by top speakers from the Data Platform community every ... Friday lunch (12:00 CEST), to your computer. Join meetup group at https://meetup.com/Sql-Friday and check out the full schedule at https://sqlfriday.net/schedule

Call for Speakers has reopened! In light of #PASSsummit 2020 becoming a virtual event, we want to give you another ... chance to share your #data knowledge with the #sqlpass community, from anywhere in the world!

Apply Today: http://ow.ly/iuiX50zVWQ0

Load More...