Ziek's SQL Home

Blogs

SQL Inventory Dashboards: From Raw Data to Real Insight

By

Tired of inventory headaches? Stock shortages and gluts don't just cause stress; they cost...

Free SQL Practice: 9 Killer Resources to Boost Your Query Skills

By

So, you want to get your SQL skills razor-sharp without dropping any cash? You're...

DevOps Devour Hour Slides

By

Here are the slides from my talk today at the Redgate NYC Devour Hour:...

Read the latest Blogs

Forums

Find Duplicate Rows

By JP789

What’s the best way to find duplicate rows in a sql query? I heard...

Isolation Level in Azure SQL Database

By inHouseDBA

Hello, Can you please clarify the following: In Azure SQL DB both ALLOW_SNAPSHOT_ISOLATION/READ_COMMITTED_SNAPSHOT are set...

Is there an ISERROR equivalent in SS?

By water490

Hi everyone I have a SP that just failed.  Format of SP is: Select...

Visit the forum

Question of the Day

Creating a new API in Data API Builder

If I run "dab init" to create a new API over a database, what parameters are required?

See possible answers