MVDBA (Mike Vessey)

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

2019-12-03

1,877 reads

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)

2019-10-29

8,987 reads

The NoSQL misdirections.

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 him to look at NoSQL, in particular MongoDB. While I'm a traditional 3rd Normal Form relational developer, I still think there is […]

4.22 (9)

2019-09-02

5,071 reads

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)

2019-08-19

2,140 reads

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)

2006-06-19 (first published: )

5,170 reads

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

2006-06-02 (first published: )

793 reads

Blogs

Covid Thoughts, So Far

By

I’ve gathered a bunch of notes from conversations and time reflecting, thought I’d write...

How to Think Like a Certification Exam at the PASS Professional Development Virtual Group

By

Thanks for the 90+ who joined today's PASS Professional Development Virtual Group webinar on...

Deploy BACPAC to Azure Managed Instance failing from SSMS?

By

Recently I ran into an error when trying to copy a small database bacpac...

Read the latest Blogs

Forums

Advantages and Disadvantage using Temp Table or Fisical Table

By fransiscuscandra

Please share your thought about advantages and disadvantages for processing using temp table or...

Do people process data from beginning of time when there is data change?

By fransiscuscandra

This might be a beginner developer questions but need some clarifications. What is best...

Why would I want to use Compress and Decompress functions?

By VoldemarG

in what live operational or development situation /requirement would I want to use the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers