Angela

I started out as a software developer back in 1996 in Denver, CO, doing Client/Server development in PowerBuilder. I am now a Data Architect, living in High Point, NC and I love what I do. I’ve worked with all versions of SQL Server since the infamous split from the Sybase code (a.k.a. version 4.21a). I’ve worn all the hats that come with dealing with SQL Server, developer to data architect and everything in between. Mastodon handle: @SQLSwimmer

All authors

Blog Post

Saving Grace

According to Merriam-Webster the definition of grace is:
1a : unmerited divine assistance given humans for their regeneration or sanctification; b : a...

2013-05-30

1,232 reads

Blog Post

Certifiable?

I have recently begun to contemplate pursuing the MCSA Certification.  I have been working with SQL Server for almost 20...

2013-05-17

608 reads

Blog Post

Mentoring

I’m putting my money where my mouth is, with respect to my last blog post.  I am officially a mentor...

2012-08-24

632 reads

Blog Post

Paying it Forward

My company has recently put forth an effort to hire fresh college graduates and interns.  I think this is a...

2012-08-24 (first published: )

1,723 reads

Blog Post

Replication and TFS

 So, we’ve had this issue lately at work with our TFS build/deploys causing a significant amount of contention and only...

2012-08-16

2,306 reads

All authors

Blogs

Attacking the Weakest Link

By

When I look at a system and think about its security model, the first...

Migrate datetime data to datetimeoffset with AT TIME ZONE

By

I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...

The Comprehensive Guide to Mastering Your SQL DBA Skills

By

Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...

Read the latest Blogs

Forums

timeout in vs for ssas tabular deploy is 0 but i still timeout deploying

By stan

hi we run 2019 std but i'm testing this on 2016.   following some old...

Table variable declared within cursor persists across loop iterations

By Steve Collins

If you run this code it creates a 2 row cursor loop.  Within the...

Multiple processes accessing the same table. some to write others to read / Lock

By river1

Dears, Hope this message finds you well We have a log table which is...

Visit the forum

Question of the Day

The Backup File Extension

I run this command in SQL Server 2022. What is the extension of the backup file? 

BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'

See possible answers