Complexity. How it is calculated.
What are the magic pink numbers you can see in Code Outline window?The answer is very simple - these are Code Complexity...
2014-05-28 (first published: 2014-05-23)
677 reads
SQL Code Guard
Varchar "miracle" and best practice
I've just spent fifteen minutes helping colleague to find "miracle in t-sql code".
- There should be rows, definitely! I can...
2014-05-20
658 reads
ExpressProfiler: The New Kid on the Block
I'm pleased to inform you that yet another of my pet-projects, ExpressProfiler, joined the rapidly growing family of Ecosystem-based tools...
2014-05-15
591 reads
Psst! Wanna some API?
If you have already visited SQL Code Guard's website you might notice a reference to an "API for custom tool...
2014-05-11
689 reads
A few words about simplicity: Using Red-Gate Ecosystem framework
In my first blog post I briefly covered when and why I created SQL Code Guard (SCG).To be honest, the first version...
2014-05-04
518 reads
When issue is not exactly "issue"
In last release of SQL Code Guard (2.4.5222) I've added few issues which can cause confusion.Eg - ST012 "Consider using temporary table instead of...
2014-04-27
553 reads
New release 2.4.5222
Today we released new version of SQL Code Guard - 2.4.5222There are many fixes and improvements, some new rules were added.Full...
2014-04-20
323 reads
Why I Developed SQL Code Guard: A Fairy Tale from a DBA
A long time ago, in a galaxy far, far away….
About ten years ago, I realized I was spending more than...
2014-02-24
811 reads
Blogs
Free SQL Practice: 9 Killer Resources to Boost Your Query Skills
So, you want to get your SQL skills razor-sharp without dropping any cash? You're...
DevOps Devour Hour Slides
By Steve Jones
Here are the slides from my talk today at the Redgate NYC Devour Hour:...
Advice I Like: Take Two Trips
By Steve Jones
If you have any doubt about being able to carry a load in one...
Forums
Is there an ISERROR equivalent in SS?
Hi everyone I have a SP that just failed. Format of SP is: Select...
Analyzing Tempdb Spills and Usage Across Recursive Queries
Comments posted to this topic are about the item Analyzing Tempdb Spills and Usage...
Creating a new API in Data API Builder
Comments posted to this topic are about the item Creating a new API in...
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