MVDBA (Mike Vessey)


SQLServerCentral Article

The NoSQL Misdirections

Editorial Note: This is a republish, in memory of Mike who passed away too soon. You can see his memorial at sqlmemorial.org. Recently I have been working with a colleague who is doing a bit of a side projects outside of work. He's  trying to expand his skillset using a pet project at home. I encouraged […]

4.46 (13)

You rated this post out of 5. Change rating

2021-06-04 (first published: )

8,126 reads

SQLServerCentral Article

It's More Than What You Know

I'm a firm believer in keeping your tech skills up to date, as well as your social skills, What better way than attending or presenting at a conference or group meeting. The reason to attend an event I'm very fortunate that my company allows me training days and time for personal development, covering all expenses […]

You rated this post out of 5. Change rating

2019-12-03

1,940 reads

SQLServerCentral Article

Parameter pain

A forum question came up a few days ago regarding an abnormally large procedural cache. In an attempt to help out, I threw together a few ideas (some wrong, some right) and started looking at the types of query that were in the cache. A lot of the queries were in the format select * […]

4.7 (10)

You rated this post out of 5. Change rating

2019-11-11

4,746 reads

SQLServerCentral Article

Oops, I deleted that data

We all have these days as a DBA,  hopefully they are few and far between for most of us. This morning I walked into the office and found a stack of emails saying that a developer had responded to a support ticket and modified the values in one of our tables and got it wrong. OK, […]

3 (5)

You rated this post out of 5. Change rating

2019-10-29

9,169 reads

SQLServerCentral Article

Memories of DR testing

With the introduction of the GDPR, a lot of our prospective clients are demanding more and more information regarding data disposal, retention and usage practices. Both our new and existing clients want to look at our internal ecosystem and understand how we manage it. This means that I finally got a budget for a disaster […]

5 (4)

You rated this post out of 5. Change rating

2019-08-19

2,181 reads

Technical Article

move all indexes to a secondary file group

Move all (or chosen) standard indexes from your primary file group to a secondary file group (hopefully located on a seperate array)excludes clustered indexes, statistics and indexes associated with a primary keywhen you run it - set the debug to 1 to identify what the script will move, set it to 0 to actually perform […]

4.67 (3)

You rated this post out of 5. Change rating

2006-06-19 (first published: )

5,399 reads

Technical Article

2005 readiness

A script to test your database for 2005 readiness.these features are as described by the SQL 2000 BPA, however this script will run on SL 6.5,7,2000Please note that this is not a guarantee of readiness, however it is an indication that there are issues you may have to resolve to run your databases in 2005

You rated this post out of 5. Change rating

2006-06-02 (first published: )

830 reads

Blogs

Async stats update causing blocking

By

I recently encountered an issue where an index rebuild set to wait_at_low_priority ended up...

Level Up Your SQL Skills: The Best Intermediate to Advanced Courses

By

In the data-driven landscape of 2024, advanced SQL isn't just a nice-to-have, it's a...

Query deadlock info in Azure SQL DB

By

A couple of weeks ago, a developer came to me and wanted to know...

Read the latest Blogs

Forums

how to find the cpu memory disk and network of the OS where RDS is residing.

By rajemessage 14195

hi, i have one RDS, but i do not have any other permissions, and...

“user_scans” of table “sys.dm_db_index_usage_stats”

By Meera

I am trying to find answer to the below. What exactly the scan means...

how to assign studentid from one table to other one? please

By Zond Sita

Good Morning,   how to assign query one results to query 2 student id,...

Visit the forum

Question of the Day

A Lack of Memory Grant Feedback Persistence

SQL Server has added an Intelligent Query Processing feature called Memory Grant Feedback. In SQL Server 2022, this can be persisted across queries to improve the performance of future executions. In SQL Server 2022, when is memory grant feedback not persisted if the plan is evicted from cache? (choose 2)

See possible answers