SQL Code Guard v2.8 released
Main change - SCG moved back to .Net framework 3.0 to restore support of SSMS 2008/2008R2
Few small fixes, additional logging, nothing...
2015-05-04
586 reads
SQL Code Guard
Using SQL Code Guard TFS Checkin Policy with VS2013
To use TFS Checking policy the first thing that you must do - is to add policy to your TFS source...
2015-05-11 (first published: 2015-05-02)
6,052 reads
24HOP Russian Edition
Spoke at 24HOP Russian edition.
Interesting experience.
It is difficult to determine mood of audience if there is no visible audience 🙂
And...
2015-03-18
595 reads
SQL Code Guard v2.7 and SQL Server 2008R2: bad news and good news
Hi all!
Bad news: SQL Code Guard v2.7 is not working with SSMS from SQL Server 2008R2 (and below).
Good news: I...
2015-03-04
665 reads
SQL Code Guard v2.7 released
Hola!
SqlCodeGuard v2.7 is just released.
To be brief - major changes:1. Added command line utility
2. Added scgallow(issue)/scgignore(issue`)to control which issues should be...
2015-02-17
1,588 reads
ExpressProfiler - new build published
Just published new signed build of ExpressProfiler - few nice improvements like advanced search, stay on top window, transparency - just to make...
2015-02-09
617 reads
How to fix: Visual Studio 2012 startup problem: The 'HDIProjectPackage' package did not load correctly.
After installing Community Edition of VS2013 with some additional packages i've noticed that my VS2012 starts failing to start with...
2014-11-15
3,815 reads
SQLSaturday 311, Sofia, October 11
Making last changes before sqlsat 311.
By the way, did you ever visited SQL Saturday? No? Why?
SQL Saturday is fun, SQL Saturday...
2014-10-05
640 reads
To be brief. What to do when PATH variable is too long to be real PATH.
Sometimes after installing pretty useful addins when starting SSMS you can see error message like "Exception has been thrown by...
2014-09-15
854 reads
SQL Code Guard v2.6 released
Today we released new version of SQL Code Guard, 2.6
Main changes:1. Bug fixing2. Small GUI and usability improvements3. Fixed support...
2014-08-22 (first published: 2014-08-18)
7,119 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
Question of the Day
RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 [email protected] 8 [email protected]If I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers