Sam Bendayan


Technical Article

Beware the REPLACE function when doing heavy string parsing

I found something interesting the other day. I was attempting to optimize a very heavy string parsing routine using T-SQL and was having problems. I don’t normally use T-SQL for such heavy string parsing, but this was a special case of a legacy structure that I had to work with, so I had no choice.

You rated this post out of 5. Change rating

2009-08-27

5,504 reads

Technical Article

To Date or Not To Date….

OK….so I’m in the middle of a very interesting Effective Dating project…basically we’re dealing with some tables that only store current data, but there is a need for future-dated data as well. Because the base table can’t hold that data...

You rated this post out of 5. Change rating

2009-05-18

3,057 reads

Technical Article

What's a DBA

Most of us are tired of this overused, vague term. How many of you have clicked on a 'DBA' job posting only to find that it's not what you do? Or asked for a DBA resume from a recruiter and gotten something other than what you expected? Or...

You rated this post out of 5. Change rating

2009-05-14

1,999 reads

Blogs

How I implemented database migration on AWS using AWS DMS

By

As a Software Engineer, I would like to replicate a copy of my database...

My personal experience dockerizing a Rust Application: Deploy to AWS ECR using Github Actions

By

I have heard about many interesting things about programming in Rust and I decided...

Terraform Elastic Jobs

By

I did a couple of other posts on Elastic Jobs. But now I want...

Read the latest Blogs

Forums

The Biggest Database Professional Challenges Today

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Biggest Database Professional Challenges...

How to use Jupyter Notebook in VSCode

By Daniel Calbimonte

Comments posted to this topic are about the item How to use Jupyter Notebook...

The Last DBCC Date

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Last DBCC Date

Visit the forum

Question of the Day

The Last DBCC Date

How can I easily get the last DBCC CheckDB date from T-SQL in SQL Server 2022?

See possible answers