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
582 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,049 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
589 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
660 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,582 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
615 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,808 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
635 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
851 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,115 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
Question of the Day
RegEx Functions II
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers