Profile cover photo
Profile photo
Jan Buchholt Hebnes
118 followers
118 followers
About
Jan's interests
View all
Jan's posts

Post has attachment
Versioning .NET builds with MsBuild Tasks using TFS Revision
MSBuild - Detecting latest TFS Revision on Project Folder level using tf.exe history and replaces the Revision in AssemblyVersion and AssemblyFileVersion for AssemblyInfo.cs prior to building the project with CustomTasks in csproj. Inspired by http://stacko...

Post has attachment
Batch file logfile pattern for scheduled Tasks
Batch file logfile pattern for scheduled Tasks A simple and robust pattern for generating a log file when creating a scheduled task batchfile is the following. If you set a double   >> %log%   at the first reference to  %log%  the log file will not be empti...

Post has attachment
Unit testing internal methods / assembly: InternalsVisibleTo
For allowing internal methods to be testable from a specific assembly, you have been able to extend AssemblyInfo with [assembly: InternalsVisibleTo("MyLib.Tests")] Available since .Net 2.0. Related information: https://lostechies.com/jimmybogard/2007/10/12/...

Post has attachment
**
SQL Security Auditting For allowing more general auditing between database environments you could find the following is useful for dumping logins, users, roles and their releated object permissions into a comparable format. CREATE SCHEMA [audit] AUTHORIZATI...

Post has attachment
Helpfull TSQL Queries for large table and procedure sets
Searching for table names  SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE '%prop%' Searching for Stored Procedure and more containing text  SELECT OBJECT_NAME(object_id) FROM sys.sql_modules WHERE OBJECTPROPERTY(object_id, 'IsProcedure') = 1 ...

Post has attachment
Adding Visual Studio Code Map Scrollbar
Adding Visual Studio Code Map Scrollbar Since Visual Studio 2013 a code map has been available instead of a plain scroll bar. Toggling is done from "Scroll Bars" in the settings tab either under All languages or under a specific language.  I prefer this set...

Post has attachment
Sync an FTP folder using WinSCP commandline
syncftp.cmd "C:\Program Files (x86)\WinSCP\winscp" /script="C:\FTP-Sync\download.winscp" download.winscp open ftp://user:password@server.com/ synchronize local "C:\FTP-Sync\public" / exit

Post has attachment
Batching Commands for SQL and Optimizing network round trips.
Optimizing Database Access And Diving Into .Net SqlClient by Mladen Prajdić http://www.sqlpass.org/24hours/2016/summitpreview/Sessions/Details.aspx?sid=53738 I was watching the session and found that I would like to add to the batch commands section. Back i...

Post has attachment
Batching Commands for SQL and Optimizing network round trips.
Optimizing Database Access And Diving Into .Net SqlClient by Mladen Prajdić http://www.sqlpass.org/24hours/2016/summitpreview/Sessions/Details.aspx?sid=53738 I was watching the session and found that I would like to add to the batch commands section. Back i...

Post has attachment
SET STATISTICS IO ON by default in SQL Management Studio
When working with databases and indexes you should always use "SET STATISTICS IO ON"  and "SET STATISTICS TIME ON" For getting the logical reads and execution times and validating the you have index coverage on your queries. But not all are aware that these...
Wait while more posts are being loaded