Jump to content


Check out our Community Blogs

Barnsite's Blog



Clear Up SSRS Subscriptions

  Posted by Barnsite, 12 June 2018 - - - - - - · 2202 views

One of the things with SSRS subscriptions is that they create a load of Agent Jobs that don’t clearly link back to specific reports.SQL warns you not to mess with these directly, so you need to find the report and remove or edit the subscriptions via the SSRS interface.We had loads that were expired, but the question was, what reports to t...


Copy DataGridView to Clipboard

  Posted by Barnsite, 01 June 2018 - - - - - - · 1664 views

Following on from exporting a DataGridView to a CSV file someone asked this week if it’s possible to copy the contents to the clipboard for pasting into another application.The code below copies the content of the passed DataGridView to the clipboard inserting the specified delimiter between each column.The basic idea is to scan each row a...


Simple SSRS Menu

  Posted by Barnsite, 24 May 2018 - - - - - - · 1994 views

This post assumes you know how to create a basic SSRS report and link it to a SQL Stored Procedure.We were starting to build up a fair number of SSRS reports that the users were running on an ad hoc basis. Initially I was emailing links to each individual report and people were saving them to their favourites. It wasn’t long before I realised...


Don’t Fall Victim To The Windows / Microsoft Phone Scam!

  Posted by Barnsite, 14 June 2017 - - - - - - · 2200 views

There are many phone scams where someone will ring you claiming to be from Microsoft, Dell, Apple, or some other known IT company.They will tell you that they have detected issues with your computer, normally “security” issues.They will often ask you to open the “Event Viewer” on your computer to show you the errors.They will then ask you to go...


Don’t Fall Victim To The Windows / Microsoft Phone Scam!

  Posted by Barnsite, 14 June 2017 - - - - - - · 11621 views

There are many phone scams where someone will ring you claiming to be from Microsoft, Dell, Apple, or some other known IT company.They will tell you that they have detected issues with your computer, normally “security” issues.They will often ask you to open the “Event Viewer” on your computer to show you the errors.They will then ask you to go...


Remove Characters in String T-SQL with No Loop Part 2

  Posted by Barnsite, 09 May 2016 - - - - - - · 354 views

Okay, expanding on what I did yesterday.I Built a table, called ExclusionList with one field, ExcludedTextE.g.Then created a function:CREATE FUNCTION [dbo].[udf_clean_string] ( @string VARCHAR(100) ) RETURNS VARCHAR(100)ASBEGIN SELECT @string = REPLACE(@string,ExcludedText,'')FROM ExclusionListRETURN @stringYou can then use like this:SELECT d...


Remove Characters in String T-SQL with No Loop Part 2

  Posted by Barnsite, 09 May 2016 - - - - - - · 18349 views

Okay, expanding on what I did yesterday.I Built a table, called ExclusionList with one field, ExcludedTextE.g.Then created a function:CREATE FUNCTION [dbo].[udf_clean_string] ( @string VARCHAR(100) ) RETURNS VARCHAR(100)ASBEGIN SELECT @string = REPLACE(@string,ExcludedText,'')FROM ExclusionListRETURN @stringYou can then use like this:SELECT d...


Remove Characters in String T-SQL with No Loop

  Posted by Barnsite, 09 May 2016 - - - - - - · 109 views

Ok, I’ve seen many ways to do this using loops, but nothing in plain T-SQLLet’s say we have a string that may contain illegal characters, in my case it was project identifiers that needed to be used as file names for exporting. However, many had / or * in the names.One thing I hate in T-SQL is loops, so having only found looping ways...


Remove Characters in String T-SQL with No Loop

  Posted by Barnsite, 09 May 2016 - - - - - - · 16370 views

Ok, I’ve seen many ways to do this using loops, but nothing in plain T-SQLLet’s say we have a string that may contain illegal characters, in my case it was project identifiers that needed to be used as file names for exporting. However, many had / or * in the names.One thing I hate in T-SQL is loops, so having only found looping ways...


Add child items to ToolStripMenuItem using C# – C Sharp

  Posted by Barnsite, 22 January 2013 - - - - - - · 6486 views

I wanted to be able to populate menu items from a database, i.e. I had a Print Document top level menu item and I wanted to be able to populate the children from the database dynamically with each available document.
The theory was this:
1. Use the MouseHover event for the main menu item
2. When the user hovers over the item, get the list of...






My Picture

0 user(s) viewing

0 members, 0 guests, 0 anonymous users

Categories

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download