Category - Programming

1
Find Text In a Stored Procedure On SQL Server
2
F.lux your blue light blocking app for better sleep
3
How to Build a Killer App (Infographic)
4
How to Check SQL Database Connection without Server Management Studio on Windows
5
Setting the height of a Telerik RadFileExplorer to 100% with ASP.NET C#

Find Text In a Stored Procedure On SQL Server

Time and time again I find the need to search all stored procedures for a table name or text in SQL server. Below is snippets of code that will do this task for you: SELECT OBJECT_NAME(object_id), OBJECT_DEFINITION(object_id) FROM sys.procedures WHERE OBJECT_DEFINITION(object_id) LIKE ‘%TEXT TO SEARCH FOR%’ SELECT DISTINCT o.name, o.xtype FROM syscomments c INNER JOIN[…]

Read More

F.lux your blue light blocking app for better sleep

PC/Mac/iOS/Android users, are you spending most of your day staring at an LCD screen? This could be harming your bodies circadian rhythm, tricking your body into thinking that it is still daylight when using your devices at night. Most circadian rhythms are controlled by the body/s biological “clock” called the suprachiasmatic nucleus or SCN. The[…]

Read More

How to Check SQL Database Connection without Server Management Studio on Windows

Stuck on a PC without SQL Management Studio? There is a utility built into windows that can be used to test SQL connections. Open up an explorer window: – Right click create a file name testConnection.udl – Accept that the changes and double click on the file – This will open up a “Data Link[…]

Read More

Setting the height of a Telerik RadFileExplorer to 100% with ASP.NET C#

With the requirement of the setting an entire frame to a RadFileExplorer the width can be set to 100% but it became evident that you simply cannot set the height to a 100%, you need to enter in a pixel value. However when the window is resized the height will not resize with it. Declaring[…]

Read More