Grant Fritchey

Grant Fritchey is a SQL Server MVP with over 20 years’ experience in IT including time spent in support and development. Grant has worked with SQL Server since version 6.0 back in 1995. He has developed in VB, VB.Net, C# and Java. Grant has authored books for Apress and Simple-Talk, and joined Red Gate as a Product Advocate in January 2011. Find Grant on Twitter @GFritchey or on his blog as the Scary DBA.

Blog Post

PostgreSQL Restore in Azure

I recently wrote an article about PostgreSQL restores (and by extension, backups) over on Simple-Talk. The restore process within PostgreSQL, without 3rd party involvement, can be a little tricky....

2022-02-14 (first published: )

112 reads

SQLServerCentral Editorial

Joining a Community

In the last week I've been actively trying to join the PostgreSQL community. It's been an interesting experience. I suspect it's going to stay interesting for a while. As part of what I'm doing, I saw this excellent video from Ryan Booz, talking about joining a new community. It got me to thinking. You have […]

2022-02-12

58 reads

Blog Post

Two Clustered Indexes?

Everyone knows that you only get a single clustered index, right? Wouldn’t it be great though if you could have two clustered indexes? Well, you can. Sort of. Let’s...

2022-01-31 (first published: )

432 reads

SQLServerCentral Editorial

Model Good Behavior

I'm answering a question in the forums and I spot something that crawls up my spine: ;WITH... The person was using a Common Table Expression (CTE) which requires that the preceding statement in the batch have a statement terminator, the semi-colon. However, since the terminator isn't required everywhere, lots of people don't use it at […]

5 (3)

2022-01-29

111 reads

Blog Post

Why Is “WHERE 1=0” Slow?

I saw a question the other day, questioning why they’re creation of temporary tables was so slow. What they were doing was (a much more complicated version of) this:...

2022-01-24 (first published: )

853 reads

Blog Post

Identifying Recompile Causes

Strictly speaking, a recompile isn’t really a performance tuning problem. In fact, a lot of time, recompiles are desired because they reflect changes in statistics which are likely to...

2022-01-12 (first published: )

247 reads

SQLServerCentral Editorial

Where the World Takes You

We're launching into a new year and there are lots of "looking into the future" articles out there. Personally, I'm pretty jazzed for the coming year for any number of reasons (can you say "SQL Server 2022"?). However, I also get a little retrospective at times like this. Now, I'm not going to talk about […]

2022-01-08

96 reads

Blogs

SQL Saturday Jacksonville Slide Decks

By

Here are the slide decks for my sessions at SQL Saturday Jacksonville 2022 Continuous...

Power BI connectors to Azure Synapse

By

When using Power BI and pulling data from Azure Synapse, you will use the...

Snowflake + Azure Privatelink

By

Azure Privatelink provides private connectivity from an Azure Virtual Network to Azure PaaS such...

Read the latest Blogs

Forums

Filetred index

By aureliu

\hello Guys,   Mayyou help wuth the corect index filetred creation using modulo?  ...

Monitor SQL Server Job Failures

By ktflash

Ahoi, i am usually working with SSIS and SSAS, but since there is no...

DateDiff - Data Type conversion Issues

By protocoder

Hi Experts Not able to do DATEDIFF between two dates, but it works when...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers