Irregular Identifiers – Be Aware of Surprises

Irregular Identifiers – Be Aware of Surprises

Surprises exist in SQL Server. There are “gotchas” to be aware of. One thing that can trip up your code is how tables, indexes, and other objects are named. They’re called identifiers. If you step outside the bound of a regular identifier then you must be careful how it is referenced.

For example adding a datetimestamp suffix to a table – let’s see how this can cause trouble.

Read More »

I’m Speaking – SQL Saturday Charlotte!

I’m Speaking – SQL Saturday Charlotte!

On Saturday October 14 I’ll be speaking at SQL Saturday Charlotte. I’m excited to be presenting a lively session about Environmental SQL Server Troubleshooting. If you want a preview you can check out some of my previous posts:

There are about 45 different sessions scheduled ranging from beginner to advanced – something for everyone.

Read More »