VISUALLY EDIT RECORDS FOR ANY QUERY USING SQL MANAGEMENT Save yourself the hassle. Open Microsoft SQL Management Studio. Connect to your database of choice. Right click on a table and select “ Edit Top 200 Rows”. In the toolbar there is an icon that says the word “ SQL ” on it that if you hover over it displays the word “ Show SQL Pane ”. Click this icon to reveal the SQL script that

is

TESTING CONNECTIVITY TO MICROSOFT SQL SERVER WITHOUT ANY Create a new file anywhere. For arguments sake create a new Text file on your desktop. Now rename that file and change it's file extension to TestDatabase.udl (take note of the file extension). Select "Yes" when asked if you want to change the file extension. This will give you a Data Link Editor that allows you to test the connection. INTEGRATION TESTING FTP CONNECTIONS IN .NET Steps to make it happen. Download FTPDMIN from here. Add the exe to the root of your test project (you can put this anywhere, but you’ll have to update the helper class below). Now add the exe to your project (i.e “view all items” in your test project’s solution explorer, and add the exe). Set the EXE to “Copy always” in it’s USING CUSTOM WEB.CONFIG TRANSFORMATIONS IN MSBUILD REPLACING QUERY STRING ELEMENTS IN C# .NET AND JAVASCRIPT While writing list navigation and search features in websites today there is a constant need to find/replace and play with query string elements, so that you can easily manipulate these mystical items while you’re carrying them around in your website’s URLs. DEBUGGING SQL QUERIES, FUNCTIONS, & STORED PROCEDURES WITH Working with Stored Procedures and functions on a database tier can be time consuming, hard to debug and sometimes just difficult to get clarity on what is “happening”. MIGRATING A UBIQUITI UNIFI CONTROLLER TO RUN ON A Firstly we want to export the site from the current controller. Login to the current (soon to be deprecated) controller and open up the settings screen for the site you want to migrate (the one that has the access points in it). In the bottom of the site settings screen you’ll notice an “export site” button. FIXING BROKEN SAMBA FILE SHARE ACCESS FOR LINUX HOSTS For the past few weeks I’ve been battling to get my Linux instances to access file shares on my Windows 10 instances over the network. Whether it was Ubuntu, Fedora, or RedHat, the recent upgrades to Windows 10 left my Windows shares inaccessible via Samba. RETRIEVE ONLY THE FIRST RECORD FROM A LEFT JOIN Retrieve only the first record from a LEFT JOIN. 17 November 2009. Recently I was working on a project where I had to return a simple list of products, and if they had images associated with them, return information about only one along with the product. Times like these, a simple left join or inner join just doesn’t cut it if there are more TEAMCITY AND GIT BEHIND A CORPORATE NTLM PROXY SERVER To configure CNTLM open the file: C:\Program Files (x86\cntlm\cntlm.ini. Username testuser Domain contorso Password password Proxy mycorporateproxy.mydomain.com:8080. Give the service a restart and then point Git at your new CNTLM proxy server. git config --global http.proxy=localhost:3128 git config --global https.proxy=myproxyserver.mydomain VISUALLY EDIT RECORDS FOR ANY QUERY USING SQL MANAGEMENT Save yourself the hassle. Open Microsoft SQL Management Studio. Connect to your database of choice. Right click on a table and select “ Edit Top 200 Rows”. In the toolbar there is an icon that says the word “ SQL ” on it that if you hover over it displays the word “ Show SQL Pane ”. Click this icon to reveal the SQL script that

is

TESTING CONNECTIVITY TO MICROSOFT SQL SERVER WITHOUT ANY Create a new file anywhere. For arguments sake create a new Text file on your desktop. Now rename that file and change it's file extension to TestDatabase.udl (take note of the file extension). Select "Yes" when asked if you want to change the file extension. This will give you a Data Link Editor that allows you to test the connection. INTEGRATION TESTING FTP CONNECTIONS IN .NET Steps to make it happen. Download FTPDMIN from here. Add the exe to the root of your test project (you can put this anywhere, but you’ll have to update the helper class below). Now add the exe to your project (i.e “view all items” in your test project’s solution explorer, and add the exe). Set the EXE to “Copy always” in it’s USING CUSTOM WEB.CONFIG TRANSFORMATIONS IN MSBUILD REPLACING QUERY STRING ELEMENTS IN C# .NET AND JAVASCRIPT While writing list navigation and search features in websites today there is a constant need to find/replace and play with query string elements, so that you can easily manipulate these mystical items while you’re carrying them around in your website’s URLs. DEBUGGING SQL QUERIES, FUNCTIONS, & STORED PROCEDURES WITH Working with Stored Procedures and functions on a database tier can be time consuming, hard to debug and sometimes just difficult to get clarity on what is “happening”. MIGRATING A UBIQUITI UNIFI CONTROLLER TO RUN ON A Firstly we want to export the site from the current controller. Login to the current (soon to be deprecated) controller and open up the settings screen for the site you want to migrate (the one that has the access points in it). In the bottom of the site settings screen you’ll notice an “export site” button. FIXING BROKEN SAMBA FILE SHARE ACCESS FOR LINUX HOSTS For the past few weeks I’ve been battling to get my Linux instances to access file shares on my Windows 10 instances over the network. Whether it was Ubuntu, Fedora, or RedHat, the recent upgrades to Windows 10 left my Windows shares inaccessible via Samba. RETRIEVE ONLY THE FIRST RECORD FROM A LEFT JOIN Retrieve only the first record from a LEFT JOIN. 17 November 2009. Recently I was working on a project where I had to return a simple list of products, and if they had images associated with them, return information about only one along with the product. Times like these, a simple left join or inner join just doesn’t cut it if there are more TEAMCITY AND GIT BEHIND A CORPORATE NTLM PROXY SERVER To configure CNTLM open the file: C:\Program Files (x86\cntlm\cntlm.ini. Username testuser Domain contorso Password password Proxy mycorporateproxy.mydomain.com:8080. Give the service a restart and then point Git at your new CNTLM proxy server. git config --global http.proxy=localhost:3128 git config --global https.proxy=myproxyserver.mydomain ENGINEERING TEAMS CAN LEARN FROM HUMAN FACTORS IN AVIATION Engineering teams can learn from Human Factors in Aviation. Engineering teams practicing DevOps strive to improve the way they build, ship and operate their software while avoiding customer impacting outages. Parts of this problem can be solved through automation that reviews and monitors your codebase before and after release, taking action USING CUSTOM WEB.CONFIG TRANSFORMATIONS IN MSBUILD Web.config transformations have been around for a while now, and a lot of developers use them in their staple day-to-day environment deployment strategies – hell, Scott Hanselman was spouting about them way back in the beginning on 2010 with his “Web Deployment Made Awesome: If you’re using XCOPY, you’re doing it wrong” post. As usual though, one size does not fit all – and in the INVESTIGATING ASP.NET MEMORY DUMPS FOR IDIOTS (LIKE ME Take note of the process ID for the worker process that is running your application pool. Now open up an elevated command prompt on your target server. Navigate to the folder C:\Program Files (x86)\Windows Kits\8.1\Debuggers\x64. Then type the following: adplus.exe –p –hang –o C:\FolderToStoreMemoryDumpIn. DEBUGGING SQL QUERIES, FUNCTIONS, & STORED PROCEDURES WITH Working with Stored Procedures and functions on a database tier can be time consuming, hard to debug and sometimes just difficult to get clarity on what is “happening”. AUTOMATED DEPLOYMENTS WITH TEAMCITY, DEPLOYMENT PROJECTS One of the continually high risk and sometimes fiddly operations in web deployment is a web application’s deployment, and yet a lot of people working in smaller teams seem to have become stuck in the land of cowboys because the task of automated deployments seems either too difficult, too time consuming to setup or is perceived as un-needed. MIGRATING A UBIQUITI UNIFI CONTROLLER TO RUN ON A Firstly we want to export the site from the current controller. Login to the current (soon to be deprecated) controller and open up the settings screen for the site you want to migrate (the one that has the access points in it). In the bottom of the site settings screen you’ll notice an “export site” button. SENDING ENCRYPTED E-MAIL WITH C# Sending encrypted e-mail with C#. 02 October 2009. There are times when the invention that we all call E-mail just doesn’t cut it for sending information securely. It is because of this that in every case where information really needs to be sent securely E-mail is not usually the medium chosen to send it. As most developers know though

there

RUNNING ANDROID APPS ON WINDOWS PHONE 10 PREVIEW Once you’ve installed the app, launch it and connect your phone via USB. On your phone, with the above developer screen open, click “Pair” to connect it to your desktop device. Your phone will give you a code – enter it into the text box of the APKTOWIN10M app. This will permanently pair your desktop and laptop. GETTING WEBDEPLOY WORKING AFTER DISABLING INSECURE CIPHERS Getting WebDeploy working after disabling insecure Ciphers like SSL 3.0 and TLS 1.0. 28 February 2016. Recently I’ve been updating the configuration of a bunch of personal servers to match the 2016 PCI requirements. One of the 2016 PCI requirements requires you to disable TLS 1.0 as it is now considered insecure. EXCHANGE 2010: FIX BROKEN OUT OF OFFICE REPLIES To check how your client is connected to exchange, you can right-click the Outlook icon located in your system tray while holding CTRL, and select Connection Status. This should bring up the window below: I'm connected here using TCP/IP, and not using HTTPs. 2. Check which URL your Outlook client is using to configure the Out of office replies! VISUALLY EDIT RECORDS FOR ANY QUERY USING SQL MANAGEMENT Save yourself the hassle. Open Microsoft SQL Management Studio. Connect to your database of choice. Right click on a table and select “ Edit Top 200 Rows”. In the toolbar there is an icon that says the word “ SQL ” on it that if you hover over it displays the word “ Show SQL Pane ”. Click this icon to reveal the SQL script that

is

TESTING CONNECTIVITY TO MICROSOFT SQL SERVER WITHOUT ANY Create a new file anywhere. For arguments sake create a new Text file on your desktop. Now rename that file and change it's file extension to TestDatabase.udl (take note of the file extension). Select "Yes" when asked if you want to change the file extension. This will give you a Data Link Editor that allows you to test the connection. MAKING LINUX SAMBA SHARES VISIBLE TO WINDOWS HOSTS AFTER Following the WannaCry Ransomeware attack in 2017, Windows stopped supporting the SMB1 protocol – and along with it Windows hosts’ previous primary broadcast discovery mechanism. Since then, Linux hosts have mostly gone dark when it comes to sharing discoverable network shares with Windows network clients. INTEGRATION TESTING FTP CONNECTIONS IN .NET Steps to make it happen. Download FTPDMIN from here. Add the exe to the root of your test project (you can put this anywhere, but you’ll have to update the helper class below). Now add the exe to your project (i.e “view all items” in your test project’s solution explorer, and add the exe). Set the EXE to “Copy always” in it’s FIXING BROKEN SAMBA FILE SHARE ACCESS FOR LINUX HOSTS For the past few weeks I’ve been battling to get my Linux instances to access file shares on my Windows 10 instances over the network. Whether it was Ubuntu, Fedora, or RedHat, the recent upgrades to Windows 10 left my Windows shares inaccessible via Samba. INVESTIGATING ASP.NET MEMORY DUMPS FOR IDIOTS (LIKE ME Take note of the process ID for the worker process that is running your application pool. Now open up an elevated command prompt on your target server. Navigate to the folder C:\Program Files (x86)\Windows Kits\8.1\Debuggers\x64. Then type the following: adplus.exe –p –hang –o C:\FolderToStoreMemoryDumpIn. DEBUGGING SQL QUERIES, FUNCTIONS, & STORED PROCEDURES WITH Working with Stored Procedures and functions on a database tier can be time consuming, hard to debug and sometimes just difficult to get clarity on what is “happening”. REPLACING QUERY STRING ELEMENTS IN C# .NET AND JAVASCRIPT While writing list navigation and search features in websites today there is a constant need to find/replace and play with query string elements, so that you can easily manipulate these mystical items while you’re carrying them around in your website’s URLs. TEAMCITY AND GIT BEHIND A CORPORATE NTLM PROXY SERVER To configure CNTLM open the file: C:\Program Files (x86\cntlm\cntlm.ini. Username testuser Domain contorso Password password Proxy mycorporateproxy.mydomain.com:8080. Give the service a restart and then point Git at your new CNTLM proxy server. git config --global http.proxy=localhost:3128 git config --global https.proxy=myproxyserver.mydomain C# CONVERT DATASET TO CSV Today i found myself wanting to quickly export a dataset to CSV and i didn’t want to bloat of a library that does more than i need. The following method is the result of this need/want. VISUALLY EDIT RECORDS FOR ANY QUERY USING SQL MANAGEMENT Save yourself the hassle. Open Microsoft SQL Management Studio. Connect to your database of choice. Right click on a table and select “ Edit Top 200 Rows”. In the toolbar there is an icon that says the word “ SQL ” on it that if you hover over it displays the word “ Show SQL Pane ”. Click this icon to reveal the SQL script that

is

TESTING CONNECTIVITY TO MICROSOFT SQL SERVER WITHOUT ANY Create a new file anywhere. For arguments sake create a new Text file on your desktop. Now rename that file and change it's file extension to TestDatabase.udl (take note of the file extension). Select "Yes" when asked if you want to change the file extension. This will give you a Data Link Editor that allows you to test the connection. MAKING LINUX SAMBA SHARES VISIBLE TO WINDOWS HOSTS AFTER Following the WannaCry Ransomeware attack in 2017, Windows stopped supporting the SMB1 protocol – and along with it Windows hosts’ previous primary broadcast discovery mechanism. Since then, Linux hosts have mostly gone dark when it comes to sharing discoverable network shares with Windows network clients. INTEGRATION TESTING FTP CONNECTIONS IN .NET Steps to make it happen. Download FTPDMIN from here. Add the exe to the root of your test project (you can put this anywhere, but you’ll have to update the helper class below). Now add the exe to your project (i.e “view all items” in your test project’s solution explorer, and add the exe). Set the EXE to “Copy always” in it’s FIXING BROKEN SAMBA FILE SHARE ACCESS FOR LINUX HOSTS For the past few weeks I’ve been battling to get my Linux instances to access file shares on my Windows 10 instances over the network. Whether it was Ubuntu, Fedora, or RedHat, the recent upgrades to Windows 10 left my Windows shares inaccessible via Samba. INVESTIGATING ASP.NET MEMORY DUMPS FOR IDIOTS (LIKE ME Take note of the process ID for the worker process that is running your application pool. Now open up an elevated command prompt on your target server. Navigate to the folder C:\Program Files (x86)\Windows Kits\8.1\Debuggers\x64. Then type the following: adplus.exe –p –hang –o C:\FolderToStoreMemoryDumpIn. DEBUGGING SQL QUERIES, FUNCTIONS, & STORED PROCEDURES WITH Working with Stored Procedures and functions on a database tier can be time consuming, hard to debug and sometimes just difficult to get clarity on what is “happening”. REPLACING QUERY STRING ELEMENTS IN C# .NET AND JAVASCRIPT While writing list navigation and search features in websites today there is a constant need to find/replace and play with query string elements, so that you can easily manipulate these mystical items while you’re carrying them around in your website’s URLs. TEAMCITY AND GIT BEHIND A CORPORATE NTLM PROXY SERVER To configure CNTLM open the file: C:\Program Files (x86\cntlm\cntlm.ini. Username testuser Domain contorso Password password Proxy mycorporateproxy.mydomain.com:8080. Give the service a restart and then point Git at your new CNTLM proxy server. git config --global http.proxy=localhost:3128 git config --global https.proxy=myproxyserver.mydomain C# CONVERT DATASET TO CSV Today i found myself wanting to quickly export a dataset to CSV and i didn’t want to bloat of a library that does more than i need. The following method is the result of this need/want. ENGINEERING TEAMS CAN LEARN FROM HUMAN FACTORS IN AVIATION Engineering teams can learn from Human Factors in Aviation. Engineering teams practicing DevOps strive to improve the way they build, ship and operate their software while avoiding customer impacting outages. Parts of this problem can be solved through automation that reviews and monitors your codebase before and after release, taking action USING CUSTOM WEB.CONFIG TRANSFORMATIONS IN MSBUILD Defines a new target named TransformWebConfig (so that you can call this from somewhere else in your MSBUILD/Web deployment project file, such as in your AfterBuild section). Inside our newly created target, we call TransformXml and pass it the following parameters. Our source web.config is located at C:\Code\MyProject\Web.config. INVESTIGATING ASP.NET MEMORY DUMPS FOR IDIOTS (LIKE ME Take note of the process ID for the worker process that is running your application pool. Now open up an elevated command prompt on your target server. Navigate to the folder C:\Program Files (x86)\Windows Kits\8.1\Debuggers\x64. Then type the following: adplus.exe –p –hang –o C:\FolderToStoreMemoryDumpIn. RETRIEVE ONLY THE FIRST RECORD FROM A LEFT JOIN Retrieve only the first record from a LEFT JOIN. 17 November 2009. Recently I was working on a project where I had to return a simple list of products, and if they had images associated with them, return information about only one along with the product. Times like these, a simple left join or inner join just doesn’t cut it if there are more DEBUGGING SQL QUERIES, FUNCTIONS, & STORED PROCEDURES WITH Working with Stored Procedures and functions on a database tier can be time consuming, hard to debug and sometimes just difficult to get clarity on what is “happening”. MIGRATING A UBIQUITI UNIFI CONTROLLER TO RUN ON A Firstly we want to export the site from the current controller. Login to the current (soon to be deprecated) controller and open up the settings screen for the site you want to migrate (the one that has the access points in it). In the bottom of the site settings screen you’ll notice an “export site” button. DECONSTRUCTING THE AZURE POINT-TO-SITE VPN FOR COMMAND When configuring an Azure Virtual Network one of the most common things you'll want to do is setup a Point-to-Site VPN so that you can actually get to your servers to manage and maintain them. Azure Point-to-Site VPNs use client certificates to secure connections which can be quite complicated to configure so Microsoft has gone the extra mile to make it easy for you to configure and get setup EXECUTING JAVASCRIPT INSIDE CSS Executing JavaScript Inside CSS - Another Reason to Whitelist and Encode User Input. 30 October 2013. Web application security's had a lot of coverage in recent times with a lot of attention paid to approaches to dealing with user generated content or exposing form or query string data to users. Thanks to a number of big hacks over the

years

WHO SAID BUILDING VISUAL STUDIO EXTENSIONS WAS HARD In years past building Visual Studio Extensions have often been considered the realm of the big boys. Staff working at Jetbrains or the Microsoft employees of the world. AUTOMATED DEPLOYMENTS WITH TEAMCITY, DEPLOYMENT PROJECTS One of the continually high risk and sometimes fiddly operations in web deployment is a web application’s deployment, and yet a lot of people working in smaller teams seem to have become stuck in the land of cowboys because the task of automated deployments seems either too difficult, too time consuming to setup or is perceived as un-needed. VISUALLY EDIT RECORDS FOR ANY QUERY USING SQL MANAGEMENT Save yourself the hassle. Open Microsoft SQL Management Studio. Connect to your database of choice. Right click on a table and select “ Edit Top 200 Rows”. In the toolbar there is an icon that says the word “ SQL ” on it that if you hover over it displays the word “ Show SQL Pane ”. Click this icon to reveal the SQL script that

is

TESTING CONNECTIVITY TO MICROSOFT SQL SERVER WITHOUT ANY Create a new file anywhere. For arguments sake create a new Text file on your desktop. Now rename that file and change it's file extension to TestDatabase.udl (take note of the file extension). Select "Yes" when asked if you want to change the file extension. This will give you a Data Link Editor that allows you to test the connection. MAKING LINUX SAMBA SHARES VISIBLE TO WINDOWS HOSTS AFTER Following the WannaCry Ransomeware attack in 2017, Windows stopped supporting the SMB1 protocol – and along with it Windows hosts’ previous primary broadcast discovery mechanism. Since then, Linux hosts have mostly gone dark when it comes to sharing discoverable network shares with Windows network clients. INTEGRATION TESTING FTP CONNECTIONS IN .NET Steps to make it happen. Download FTPDMIN from here. Add the exe to the root of your test project (you can put this anywhere, but you’ll have to update the helper class below). Now add the exe to your project (i.e “view all items” in your test project’s solution explorer, and add the exe). Set the EXE to “Copy always” in it’s FIXING BROKEN SAMBA FILE SHARE ACCESS FOR LINUX HOSTS For the past few weeks I’ve been battling to get my Linux instances to access file shares on my Windows 10 instances over the network. Whether it was Ubuntu, Fedora, or RedHat, the recent upgrades to Windows 10 left my Windows shares inaccessible via Samba. INVESTIGATING ASP.NET MEMORY DUMPS FOR IDIOTS (LIKE ME Take note of the process ID for the worker process that is running your application pool. Now open up an elevated command prompt on your target server. Navigate to the folder C:\Program Files (x86)\Windows Kits\8.1\Debuggers\x64. Then type the following: adplus.exe –p –hang –o C:\FolderToStoreMemoryDumpIn. DEBUGGING SQL QUERIES, FUNCTIONS, & STORED PROCEDURES WITH Working with Stored Procedures and functions on a database tier can be time consuming, hard to debug and sometimes just difficult to get clarity on what is “happening”. REPLACING QUERY STRING ELEMENTS IN C# .NET AND JAVASCRIPT While writing list navigation and search features in websites today there is a constant need to find/replace and play with query string elements, so that you can easily manipulate these mystical items while you’re carrying them around in your website’s URLs. TEAMCITY AND GIT BEHIND A CORPORATE NTLM PROXY SERVER To configure CNTLM open the file: C:\Program Files (x86\cntlm\cntlm.ini. Username testuser Domain contorso Password password Proxy mycorporateproxy.mydomain.com:8080. Give the service a restart and then point Git at your new CNTLM proxy server. git config --global http.proxy=localhost:3128 git config --global https.proxy=myproxyserver.mydomain C# CONVERT DATASET TO CSV Today i found myself wanting to quickly export a dataset to CSV and i didn’t want to bloat of a library that does more than i need. The following method is the result of this need/want. VISUALLY EDIT RECORDS FOR ANY QUERY USING SQL MANAGEMENT Save yourself the hassle. Open Microsoft SQL Management Studio. Connect to your database of choice. Right click on a table and select “ Edit Top 200 Rows”. In the toolbar there is an icon that says the word “ SQL ” on it that if you hover over it displays the word “ Show SQL Pane ”. Click this icon to reveal the SQL script that

is

TESTING CONNECTIVITY TO MICROSOFT SQL SERVER WITHOUT ANY Create a new file anywhere. For arguments sake create a new Text file on your desktop. Now rename that file and change it's file extension to TestDatabase.udl (take note of the file extension). Select "Yes" when asked if you want to change the file extension. This will give you a Data Link Editor that allows you to test the connection. MAKING LINUX SAMBA SHARES VISIBLE TO WINDOWS HOSTS AFTER Following the WannaCry Ransomeware attack in 2017, Windows stopped supporting the SMB1 protocol – and along with it Windows hosts’ previous primary broadcast discovery mechanism. Since then, Linux hosts have mostly gone dark when it comes to sharing discoverable network shares with Windows network clients. INTEGRATION TESTING FTP CONNECTIONS IN .NET Steps to make it happen. Download FTPDMIN from here. Add the exe to the root of your test project (you can put this anywhere, but you’ll have to update the helper class below). Now add the exe to your project (i.e “view all items” in your test project’s solution explorer, and add the exe). Set the EXE to “Copy always” in it’s FIXING BROKEN SAMBA FILE SHARE ACCESS FOR LINUX HOSTS For the past few weeks I’ve been battling to get my Linux instances to access file shares on my Windows 10 instances over the network. Whether it was Ubuntu, Fedora, or RedHat, the recent upgrades to Windows 10 left my Windows shares inaccessible via Samba. INVESTIGATING ASP.NET MEMORY DUMPS FOR IDIOTS (LIKE ME Take note of the process ID for the worker process that is running your application pool. Now open up an elevated command prompt on your target server. Navigate to the folder C:\Program Files (x86)\Windows Kits\8.1\Debuggers\x64. Then type the following: adplus.exe –p –hang –o C:\FolderToStoreMemoryDumpIn. DEBUGGING SQL QUERIES, FUNCTIONS, & STORED PROCEDURES WITH Working with Stored Procedures and functions on a database tier can be time consuming, hard to debug and sometimes just difficult to get clarity on what is “happening”. REPLACING QUERY STRING ELEMENTS IN C# .NET AND JAVASCRIPT While writing list navigation and search features in websites today there is a constant need to find/replace and play with query string elements, so that you can easily manipulate these mystical items while you’re carrying them around in your website’s URLs. TEAMCITY AND GIT BEHIND A CORPORATE NTLM PROXY SERVER To configure CNTLM open the file: C:\Program Files (x86\cntlm\cntlm.ini. Username testuser Domain contorso Password password Proxy mycorporateproxy.mydomain.com:8080. Give the service a restart and then point Git at your new CNTLM proxy server. git config --global http.proxy=localhost:3128 git config --global https.proxy=myproxyserver.mydomain C# CONVERT DATASET TO CSV Today i found myself wanting to quickly export a dataset to CSV and i didn’t want to bloat of a library that does more than i need. The following method is the result of this need/want. ENGINEERING TEAMS CAN LEARN FROM HUMAN FACTORS IN AVIATION Engineering teams can learn from Human Factors in Aviation. Engineering teams practicing DevOps strive to improve the way they build, ship and operate their software while avoiding customer impacting outages. Parts of this problem can be solved through automation that reviews and monitors your codebase before and after release, taking action USING CUSTOM WEB.CONFIG TRANSFORMATIONS IN MSBUILD Defines a new target named TransformWebConfig (so that you can call this from somewhere else in your MSBUILD/Web deployment project file, such as in your AfterBuild section). Inside our newly created target, we call TransformXml and pass it the following parameters. Our source web.config is located at C:\Code\MyProject\Web.config. INVESTIGATING ASP.NET MEMORY DUMPS FOR IDIOTS (LIKE ME Take note of the process ID for the worker process that is running your application pool. Now open up an elevated command prompt on your target server. Navigate to the folder C:\Program Files (x86)\Windows Kits\8.1\Debuggers\x64. Then type the following: adplus.exe –p –hang –o C:\FolderToStoreMemoryDumpIn. RETRIEVE ONLY THE FIRST RECORD FROM A LEFT JOIN Retrieve only the first record from a LEFT JOIN. 17 November 2009. Recently I was working on a project where I had to return a simple list of products, and if they had images associated with them, return information about only one along with the product. Times like these, a simple left join or inner join just doesn’t cut it if there are more DEBUGGING SQL QUERIES, FUNCTIONS, & STORED PROCEDURES WITH Working with Stored Procedures and functions on a database tier can be time consuming, hard to debug and sometimes just difficult to get clarity on what is “happening”. MIGRATING A UBIQUITI UNIFI CONTROLLER TO RUN ON A Firstly we want to export the site from the current controller. Login to the current (soon to be deprecated) controller and open up the settings screen for the site you want to migrate (the one that has the access points in it). In the bottom of the site settings screen you’ll notice an “export site” button. DECONSTRUCTING THE AZURE POINT-TO-SITE VPN FOR COMMAND When configuring an Azure Virtual Network one of the most common things you'll want to do is setup a Point-to-Site VPN so that you can actually get to your servers to manage and maintain them. Azure Point-to-Site VPNs use client certificates to secure connections which can be quite complicated to configure so Microsoft has gone the extra mile to make it easy for you to configure and get setup EXECUTING JAVASCRIPT INSIDE CSS Executing JavaScript Inside CSS - Another Reason to Whitelist and Encode User Input. 30 October 2013. Web application security's had a lot of coverage in recent times with a lot of attention paid to approaches to dealing with user generated content or exposing form or query string data to users. Thanks to a number of big hacks over the

years

WHO SAID BUILDING VISUAL STUDIO EXTENSIONS WAS HARD In years past building Visual Studio Extensions have often been considered the realm of the big boys. Staff working at Jetbrains or the Microsoft employees of the world. AUTOMATED DEPLOYMENTS WITH TEAMCITY, DEPLOYMENT PROJECTS One of the continually high risk and sometimes fiddly operations in web deployment is a web application’s deployment, and yet a lot of people working in smaller teams seem to have become stuck in the land of cowboys because the task of automated deployments seems either too difficult, too time consuming to setup or is perceived as un-needed. VISUALLY EDIT RECORDS FOR ANY QUERY USING SQL MANAGEMENT I watched an interesting thing take place the other day, in the form of someone using the visual tooling in SQL Management Studio to “Edit Top 200 rows” in a table, then realising that the record they wanted was not there, running a manual SELECT query to find the record, and then running a manual UPDATE command to edit the row. TESTING CONNECTIVITY TO MICROSOFT SQL SERVER WITHOUT ANY Often you'll find yourself logged into a web or application server and need to simply test that you can get to the SQL server you've unsuccessfully been trying to point your app at. INTEGRATION TESTING FTP CONNECTIONS IN .NET When writing testable code your first port of call is often to abstract any dependencies and make them easy to mock. This is the same for any of your codebase that talks to FTP servers. USING CUSTOM WEB.CONFIG TRANSFORMATIONS IN MSBUILD INVESTIGATING ASP.NET MEMORY DUMPS FOR IDIOTS (LIKE ME Sometimes your ASP.Net sites crash or hang, and you have no idea why. No exceptions, no event logs. This leaves you a little light on places to start your debug investigation journey. FIXING BROKEN SAMBA FILE SHARE ACCESS FOR LINUX HOSTS For the past few weeks I’ve been battling to get my Linux instances to access file shares on my Windows 10 instances over the network. Whether it was Ubuntu, Fedora, or RedHat, the recent upgrades to Windows 10 left my Windows shares inaccessible via Samba. EXECUTING JAVASCRIPT INSIDE CSS Web application security's had a lot of coverage in recent times with a lot of attention paid to approaches to dealing with user generated content or exposing form or query string data to users. DECONSTRUCTING THE AZURE POINT-TO-SITE VPN FOR COMMANDSEE MORE ON DOUGRATHBONE.COMAZURE P2S VPN CERTIFICATEAZURE P2S VPN MACAZURE P2S VPN SETUPAZURE P2S AADAZURE P2S OPENVPNCONFIGURE OPENVPN AZURE P2S C# CONVERT DATASET TO CSV Today i found myself wanting to quickly export a dataset to CSV and i didn’t want to bloat of a library that does more than i need. The following method is the result of this need/want. TEAMCITY AND GIT BEHIND A CORPORATE NTLM PROXY SERVER Recent Posts. Making Linux Samba shares visible to Windows hosts after WannaCry; Engineering teams can learn from Human Factors in Aviation; Fixing broken Samba File Share access for Linux hosts after installing the latest version of Windows 10 VISUALLY EDIT RECORDS FOR ANY QUERY USING SQL MANAGEMENT I watched an interesting thing take place the other day, in the form of someone using the visual tooling in SQL Management Studio to “Edit Top 200 rows” in a table, then realising that the record they wanted was not there, running a manual SELECT query to find the record, and then running a manual UPDATE command to edit the row. TESTING CONNECTIVITY TO MICROSOFT SQL SERVER WITHOUT ANY Often you'll find yourself logged into a web or application server and need to simply test that you can get to the SQL server you've unsuccessfully been trying to point your app at. INTEGRATION TESTING FTP CONNECTIONS IN .NET When writing testable code your first port of call is often to abstract any dependencies and make them easy to mock. This is the same for any of your codebase that talks to FTP servers. USING CUSTOM WEB.CONFIG TRANSFORMATIONS IN MSBUILD INVESTIGATING ASP.NET MEMORY DUMPS FOR IDIOTS (LIKE ME Sometimes your ASP.Net sites crash or hang, and you have no idea why. No exceptions, no event logs. This leaves you a little light on places to start your debug investigation journey. FIXING BROKEN SAMBA FILE SHARE ACCESS FOR LINUX HOSTS For the past few weeks I’ve been battling to get my Linux instances to access file shares on my Windows 10 instances over the network. Whether it was Ubuntu, Fedora, or RedHat, the recent upgrades to Windows 10 left my Windows shares inaccessible via Samba. EXECUTING JAVASCRIPT INSIDE CSS Web application security's had a lot of coverage in recent times with a lot of attention paid to approaches to dealing with user generated content or exposing form or query string data to users. DECONSTRUCTING THE AZURE POINT-TO-SITE VPN FOR COMMANDSEE MORE ON DOUGRATHBONE.COMAZURE P2S VPN CERTIFICATEAZURE P2S VPN MACAZURE P2S VPN SETUPAZURE P2S AADAZURE P2S OPENVPNCONFIGURE OPENVPN AZURE P2S C# CONVERT DATASET TO CSV Today i found myself wanting to quickly export a dataset to CSV and i didn’t want to bloat of a library that does more than i need. The following method is the result of this need/want. TEAMCITY AND GIT BEHIND A CORPORATE NTLM PROXY SERVER Recent Posts. Making Linux Samba shares visible to Windows hosts after WannaCry; Engineering teams can learn from Human Factors in Aviation; Fixing broken Samba File Share access for Linux hosts after installing the latest version of Windows 10 USING CUSTOM WEB.CONFIG TRANSFORMATIONS IN MSBUILD Web.config transformations have been around for a while now, and a lot of developers use them in their staple day-to-day environment deployment strategies – hell, Scott Hanselman was spouting about them way back in the beginning on 2010 with his “Web Deployment Made Awesome: If you’re using XCOPY, you’re doing it wrong” post. As usual though, one size does not fit all – and in the DEBUGGING SQL QUERIES, FUNCTIONS, & STORED PROCEDURES WITH Working with Stored Procedures and functions on a database tier can be time consuming, hard to debug and sometimes just difficult to get clarity on what is “happening”. REPLACING QUERY STRING ELEMENTS IN C# .NET AND JAVASCRIPT While writing list navigation and search features in websites today there is a constant need to find/replace and play with query string elements, so that you can easily manipulate these mystical items while you’re carrying them around in your website’s URLs. DECONSTRUCTING THE AZURE POINT-TO-SITE VPN FOR COMMAND When configuring an Azure Virtual Network one of the most common things you'll want to do is setup a Point-to-Site VPN so that you can actually get to your servers to manage and maintain them. Azure Point-to-Site VPNs use client certificates to secure connections which can be quite complicated to configure so Microsoft has gone the extra mile to make it easy for you to configure and get setup EXECUTING JAVASCRIPT INSIDE CSS Web application security's had a lot of coverage in recent times with a lot of attention paid to approaches to dealing with user generated content or exposing form or query string data to users. RUNNING ANDROID APPS ON WINDOWS PHONE 10 PREVIEW If you’re lucky enough to have a supported device the next step is to simply follow this guide and download the Windows Insider app to upgrade your phone to Windows Phone 10.. It takes a while to install, but don’t worry about me, I'll just sit here and wait for you RETRIEVE ONLY THE FIRST RECORD FROM A LEFT JOIN Recently I was working on a project where I had to return a simple list of products, and if they had images associated with them, return information about only one along with the product. WRITING YOUR OWN CUSTOM ASP.NET MVC ATTRIBUTES ASP.Net’s attribute is another cool feature that makes it easy to add authentication at the Controller level when building a website, but the real goldmine here is that like nearly everything else in ASP.Net MVC, you can pick apart the functionality and extend it yourself – In this post we will take a look at creating our own custom Authentication attribute. OUTPUT DATA AS RAW XML FROM MS SQL In the modern world we live in with Web Services, RPC calls and the like, SQL server has had a lot of work on its hands trying to keep its followers from leaving to newer ways to store data such as document

databases.

PROGRAMMATICALLY CLEARING THE ASP.NET CACHE FOR WEB FORMS Page level caching for ASP.Net webforms and MVC websites is pretty awesome, because it allows you to implement something that's quite complex; multilevel caching, without having to really understand too much about caching, or even write much code.

DOUG RATHBONE

_Leadership and internet musings from the Perl generation..._ THE DIRTY DOZEN – WHAT ENGINEERING TEAMS CAN LEARN FROM HUMAN

FACTORS IN AVIATION

29 March 2020 0 Comments Engineering teams practicing DevOps strive to improve the way they build, ship and operate their software while avoiding customer impacting outages. Parts of this problem can be solved through automation  to review and monitor your codebase before and after release, taking action before a human operator even investigates an event. One of the hardest parts of reducing system outages completely is that software still involves human, and human involvement always brings its own set of challenges.

* DevOps ,

* Best Practices ,

* Troubleshooting , * Tips and Tricks ,

* Team management

Read the full post

FIXING BROKEN SAMBA FILE SHARE ACCESS FOR LINUX HOSTS AFTER INSTALLING THE LATEST VERSION OF WINDOWS 10 02 April 2018 5 Comments For the past few weeks I’ve been battling to get my Linux instances to access file shares on my Windows 10 instances over the network. Whether it was Ubuntu, Fedora, or RedHat, the recent upgrades to Windows 10 left my Windows shares inaccessible via Samba. Troubleshooting was difficult as I had nothing to go on exception really ambiguous messages via the syslog (“Failed to mount Windows share: Connection timed out”). After some trial and error it all came down to an undocumented change in how Windows 10 supports the SMB

protocol.

* Linux ,

* Troubleshooting ,

* Networking

Read the full post

CONFIGURING A THIRD-PARTY ASUS RT-AC3200 ROUTER TO DIRECTLY CONNECT TO A CENTURYLINK GIGABIT GPON SERVICE 31 March 2018 19 Comments CenturyLink’s gigabit service is pretty awesome, but their provided routers are pretty average when it comes to configurability and simply raw performance. The problem with this is that the way CenturyLink’s Gigabit service runs, you need to do a little more work to configure just any normal router to work with the service. For me, it took a little bit of digging and experimentation to figure out the right way to get a third party modem to work with CenturyLink; in my case a high performance Asus AC-3200, previously used with my Wave gigabit internet service due to it’s high performance routing backplane. * Tips and Tricks ,

* Networking ,

* Troubleshooting

Read the full post

MIGRATING A UBIQUITI UNIFI CONTROLLER TO RUN ON A RASPBERRY PI FOR

PENNIES

31 March 2018 10 Comments Ubiquiti WiFi gear is becoming well known as the _go to_ brand for nerds wanting to have home WiFi that competes with commercial set ups. The Ubiquiti AC-PRO access points in particular are in the category of “next level” consumer gear, and after installing them i’ve never looked back. Being commercial gear the Ubiquiti APs do have one annoying requirement: you need to run controller software on your network to monitor and control the access points through Ubiquiti’s cloud based controller software. Luckily you can run this software on a range of hardware – and a $35 Raspberry Pi is just the ticket.

* Networking ,

* WiFi ,

* Ubiquiti Networks ,

* Unifi ,

* Tips and Tricks ,

* Raspberry Pi

Read the full post

GETTING WEBDEPLOY WORKING AFTER DISABLING INSECURE CIPHERS LIKE SSL

3.0 AND TLS 1.0

28 February 2016 6 Comments Recently I’ve been updating the configuration of a bunch of personal servers to match the 2016 PCI requirements. One of the 2016 PCI requirements requires you to disable TLS 1.0 as it is now considered insecure. One of the problems with doing this of course is the fact that WebDeploy uses SSL and by default won’t allow connections and deployments to occur with TLS disabled. Luckily the fix is rather simple.

* Web Deploy ,

* Security ,

* Windows Server ,

* Best Practices

Read the full post

ADD CUSTOM CALL-TO-ACTIONS TO YOUR CUSTOMER’S GMAIL INBOX BY SENDING WITH GMAIL EMAIL MARKUP 15 January 2016 3 Comments A few years ago the Gmail team began experimenting with the concept of interactive extensions to email messages, with the release of Gmail Actions (now called Gmail Email Markup ). These simple additions to your HTML email allow developers to add call-to-action type links to your emails, without customers even needing to open your email.

* Best Practices ,

* E-mail

Read the full post

WHEN .GITIGNORE STOPS BEING YOUR FRIEND - DEBUGGING MISSING GIT

REPOSITORY FILES

18 November 2015 0 Comments One of the first things you figure out when working with Git is that like other source control providers, you want an easy way to exclude files from ending up on your source control to save yourself uploading items such as binaries and local user files (here’s looking at you Resharper!). By adding a .gitignore file to your repository you easily make this possible (if you’re using Windows, feel free to take a look at my post on creating these files successfully in Windows). The problem you have next is when you add a gitignore rule that’s a little too aggressive and your new project files fail to be picked up by Git, but you’re not quite sure which rule is the cause – this post shows you how you can troubleshoot

these issues.

* Git ,

* Hidden features , * Tips and Tricks ,

* Tools ,

* Troubleshooting ,

* Source Control

Read the full post

RUNNING ANDROID APPS ON WINDOWS PHONE 10 PREVIEW 30 August 2015 70 Comments Depending on who you talk to, one of the coolest parts of the new Windows Phone OS coming to devices in the next few months is the ability to run Android apps. Yes, you heard me correctly: you will be able to run Android apps on your Windows Phone 10 device. With the preview releases coming out on a regular basis lately it’s good to see we’re getting a little bit closer to having this ability in everyone’s hands soon, but in the meantime the question really is: how do I get to try this now? * Hidden features ,

* New Features ,

* Windows Phone 10 ,

* Android

Read the full post

SO YOU WANT YOUR TEAM TO START USING GIT? – PART 4: TEAM WORKFLOWS 11 September 2014 4 Comments So you’ve got your own personal Git use dialled in, you’ve got a server environment configured with commits flying into your project like crazy, now you’re ready to start leveraging the power of Git _with others._ New workflows exist for distributed version control systems that offer big gains in terms of developer workflow, interaction, quality assurance and overall delivery process. Let’s take a look at one of them – GitFlow, so we can turn your team’s

Git usage up to 11.

* Git ,

* Source Control

Read the full post

SO YOU WANT YOUR TEAM TO START USING GIT? – PART 3: MORE THAN JUST

COMMITTING

27 August 2014 0 Comments So you’ve got got your source code into Git, you’ve learned how to work with your repository in a basic fashion and you’ve pushed it onto another server for safe storage. There are a few more tricks to using Git that will make the journey easier and are worth looking at before continuing.  Although you’ll become more confortable with Git’s approach to source control over time knowing that the following features exist and how to use them will save you a lot

later.

* Git ,

* Source Control

Read the full post

< Earlier Posts

* RSS

* Email

* Twitter

* Facebook

DOUG RATHBONE

ALL-ROUND INTERNET GUY

Search

* Home

* Contact Me

RECENT POSTS

* The Dirty Dozen – What Engineering teams can learn from Human

Factors in Aviation

* Fixing broken Samba File Share access for Linux hosts after installing the latest version of Windows 10 * Configuring a Third-Party Asus RT-AC3200 router to directly connect to a CenturyLink Gigabit GPON Service * Migrating a Ubiquiti Unifi Controller to run on a Raspberry Pi for

Pennies

* Getting WebDeploy working after disabling insecure Ciphers like

SSL 3.0 and TLS 1.0

* Add Custom Call-to-actions to your Customer’s Gmail Inbox by sending with Gmail Email Markup * When .gitignore stops being your friend - Debugging missing Git

repository files

* Running Android apps on Windows Phone 10 preview * So you want your Team to start using Git? – Part 4: Team

Workflows

* So you want your Team to start using Git? – Part 3: More than

just Committing

* So you want your Team to start using Git? – Part 2: Pushing it

up Somewhere

* So you want your Team to start using Git? – Part 1: Getting

started

* 101 Pedantic Programmer’s thoughts on Lenovo’s new ThinkPad

X240

* Investigating ASP.Net Memory Dumps for Idiots (like Me) * Who said building Visual Studio Extensions was hard?

POPULAR POSTS

* Writing your own custom ASP.Net MVC attributes * Testing connectivity to Microsoft SQL Server without any tools

installed

* Debugging SQL Queries, Functions, & Stored Procedures with SQL Management Studio’s Integrated Debugger * Running Android apps on Windows Phone 10 preview * Investigating ASP.Net Memory Dumps for Idiots (like Me) * Html.AntiForgeryToken – Balancing Security with Usability * Using Custom Web.config Transformations in MSBUILD * Running large MSSQL scripts & resulting memory errors * Automated deployments with TeamCity, Deployment projects & SVN * What good Web Developers should know about sending E-mail

TAGS

* .Net 4 ,

* Accessibility ,

* Active Directory ,

* Advertising ,

* Ajax ,

* Amazon AWS ,

* Analytics ,

* Android ,

* Apple ,

* Arachnophobia ,

* ASP.Net ,

* ASP.Net MVC ,

* Automation ,

* Azure ,

* Best Practices ,

* Blackberry ,

* Browsers ,

* C# ,

* Certifications ,

* Cloud Services ,

* Conferences ,

* Config Transformations , * Continuous Integration ,

* CSS ,

* Database ,

* Debugging ,

* Deployment ,

* Design ,

* DevOps ,

* DKIM ,

* DNS ,

* Domain Keys ,

* E-mail ,

* Exceptions ,

* Exchange Server ,

* GaDotNet ,

* General banter ,

* Git ,

* GoogleAnalyticsDotNet ,

* Hardware ,

* Hidden features ,

* Hosting ,

* Hyper V ,

* IIS ,

* Internet Explorer ,

* InTheKnow ,

* JavaScript ,

* jQuery ,

* Kinect ,

* Kinect SDK ,

* Linux ,

* Mail Server ,

* Mobile devices ,

* MS SQL ,

* MSBUILD ,

* Natural User Interface ,

* Networking ,

* New Features ,

* NewRelic ,

* Nuget ,

* Offshoring ,

* OnCheckin ,

* Open Source ,

* Opinion ,

* Optimisation ,

* Other ,

* Performance ,

* Personal Certificates , * Personal Projects ,

* Piracy ,

* Politics ,

* Project Management , * Publishing Profiles ,

* Raspberry Pi ,

* Reflection ,

* RegEx ,

* Remote Desktop Connection ,

* Security ,

* Shared hosting ,

* SharePoint ,

* Silverlight ,

* Silverlight Toolkit ,

* SimpleDeploy ,

* SMTP ,

* Social Networking ,

* Source Control ,

* Spam ,

* SQL ,

* Statistics ,

* Surface SDK ,

* Sys Admin ,

* Talks ,

* Team Foundation Server ,

* Team management ,

* TeamCity ,

* Telco ,

* Telstra ,

* TFS 2010 ,

* Time Zones ,

* Tips and Tricks ,

* Tools ,

* Troubleshooting ,

* Ubiquiti Networks ,

* Unifi ,

* Unit Testing ,

* Usability ,

* VB.Net ,

* Video ,

* Virtualisation ,

* Visual Studio ,

* Vodafone ,

* VSIX ,

* W3C ,

* WCAG ,

* Web Deploy ,

* Web security ,

* WiFi ,

* WinDbg ,

* Windows Phone 10 ,

* Windows Phone 7 ,

* Windows Phone 7 Mango , * Windows Phone SDK ,

* Windows Server ,

* XML

DISCLAIMER:

The opinions expressed herein are my own and do not represent my employer’s view in any way. They are strong opinions lightly held - feel free to set me straight

.

Site designed with love by Doug Rathbone in late 2011. Awesomely HTMLified by the great JVDL Deployed Early and Often by the Awesome OnCheckin All content unless otherwise attributed is copyright 2011 © Doug

Rathbone.