MVDBA

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.63 (8)

2019-09-02

4,893 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,078 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,135 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: )

786 reads

Blogs

Continuous integration and delivery (CI/CD) in Azure Data Factory using DevOps and GitHub - PASS Video

By

(2019-Oct-23) Video recording of my webinar session on Continuous Integration and Delivery (CI/CD) in Azure...

Invest in Yourself Stop Making Excuses

By

Bob Pusateri (B|T) tweeted a quote image that really struck a chord with me...

Every Execution Plan Is An Estimated Plan

By

I consider myself to be the most responsible for making such a huge deal...

Read the latest Blogs

Forums

SQL Management studio 2014 express edition

By bokswager

Guys, Can I use SSMS 2014 Express edition to connect to a lower and...

unable access sql provider in powershell without running an invoke-sqlcmd first

By Steve T

I encountered a weird issue and hope that somebody may have a fix for...

Function to pad Bigint with leading zeros or other single characters

By Shane Clarke

Comments posted to this topic are about the item Function to pad Bigint with...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers