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,035 reads
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
573 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
574 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
652 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,570 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
608 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,796 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
629 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
834 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,105 reads
Blogs
A New Word: Lackout
By Steve Jones
lackout – n. the sudden awareness that you’re finally over someone, noticing that the...
Delta Lake over Spark Connect
By Ed Elliott
All Spark Connect Posts I have just finished an update for the spark connect dotnet...
Introducing FabricTools (PowerShell module)
By Kamil
The Challenge: DevOps for Microsoft Fabric In the world of Microsoft Fabric, DevOps...
Forums
Merge techniques
In Azure SQL DB, i want to merge records from the staging table to...
SSRS error: The Value for the image 'Image1' has a constant value...
Full error message: SSRS error: The Value for the image 'Image1' has a constant...
XML_COMPRESSION for existing tables
We are in the process of upgrading to SQL Server 2022 and would like...
Question of the Day
Adding Defaults
I have a table, called dbo.logger, in SQL Server 2022. I decide to add two new columns to this table with this code.
ALTER TABLE dbo.logger ADD CreateDate DATETIME CONSTRAINT dfGetDate DEFAULT GETDATE() GO ALTER TABLE dbo.logger ADD ModifyDate DATETIME DEFAULT dfGetDate GOWhat happens when I run these two batches? See possible answers