SQL Code Guard 2.9 released
Nothing special - just signed with renewed code sign certificate, small fixes, etc
Have fun!
Wait a minute! Almost forgot.
More great news coming...
2017-02-22
760 reads
New developer build of SQL Code Guard released
Issues fixed since last developer build
[*] fixed incorrect binding of MI008 to MI007
[*] fixed xtra EI028 in case with named...
2016-03-09
993 reads
SQLSaturday 426, Lviv, Dec 05 - only few days left!
Last changes and preparation for SQLSaturday in Lviv - http://sqlsaturday.com/426/EventHome.aspx
You still have a time to register and attend it.
Great city, great...
2015-12-01
529 reads
Support for SSMS 2016 now available
Good news!
Red-Gate published new version of its SIPF framework with support of SSMS 2016!
Now you can simply download and install...
2015-11-11
538 reads
Catching specific statements using new MI008 "Statement used" rule
Imagine that you want (for some reason) prohibit usage of some statement (or statements), eg - CURSOR
How can you find if...
2015-11-05 (first published: 2015-10-30)
1,840 reads
I'm alive!!!!
Hi all!
Sorry for long delay but i was a pretty busy preparing SQLSat
Now mission is accomplished and i'll return to...
2015-09-21
438 reads
ExpressProfiler: say "Hi!" to new developer!
I glad to introduce new member of Express Profiler team - Chris Moore!
He has many ideas and eager to implement them.
Welcome...
2015-06-25
528 reads
SQL Code Guard - Developer build: just as planned
Well, not exactly just as planned, but at last!
Few minor fixes
[*] fixed unparsed with CONTAINS condition[*] fixed xtra "ST010 Use...
2015-06-24
600 reads
SQL Code Guard - developer builds
Hi all
Unfortunatelly I'm pretty busy now and will be busy till end of the year
So I have not so much...
2015-06-16
558 reads
SqlSaturday 377, Kiev, May 23 - only 3 days left
Hello everyone!
As you may already know - on 23rd May in Kiev will be held SqlSaturday 377.
Hurry up!
You can meet many...
2015-05-20
458 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers