Thom Bolin

Moving Indexes

Working with filegroups and managing the location of your various objects can be a cumbersome task in SQL Server. New author Thom Bolin brings us a technique and some code that worked well for one of his clients.

4.13 (16)

2008-09-15

6,064 reads

Backup Verification

The following script runs against the current server and retrieves number of days since last full or differential and the number of days between them. it also retrieves the number of hours since the last transaction log backup.It currently returns a grid output.currently the script is under going changes to send XML back to an […]

5 (1)

2006-05-22 (first published: )

1,225 reads

String Parsing

User Defined function to parse a string with known delimiters and return back the substing in the position.Takes string,delimiter and position as parameters. Can be used directly in TSQL code.

2003-03-27

311 reads

Blogs

How I passed the 70-761 certification exam

By

FUN FACT: I have been a Microsoft Certified Professional for SQL Server for over...

Azure Storage tips

By

As a followup to my blog post Azure Data Lake Store Gen2 is GA,...

Managing Agent Jobs on Availability Group Servers

By

As always, the scripts in this post can also be found on our Git...

Read the latest Blogs

Forums

Relatively easy query assistance - datediff

By morkal

Hi all, I have a question since I'm new to SQL: I have a...

Mirroring alerts

By kilein

Hi, In one of our customers the database mirroring was already configured. After long...

On Looking and Acting the Part

By Phil Factor

Comments posted to this topic are about the item On Looking and Acting the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers