Sometimes you don’t want to run an RDP session full screen but you do want to want to make use of the real estate more than the default RDP settings allow you to choose. Using the RDP panel you can only select set values from the slider control, there isn’t the ability to be fully flexible.
So you have to customise your RDP session but this time using notepad instead. Generally your RDP session will load its default values from the Default.rdp file, held in your “My Documents” folder. So edit this and change the following two lines to whatever value you want, from the 1920×1080 defaults, in my case.
Trying to find a file by filename and file type and getting matches that include the filename and type as well? Windows 10 search seems to have taken a step backwards by being “helpful” in search file contents and filenames, or types, when you use the search box.
Then you need to use the “name” keyword in the quick search box. The name option has two ways of being used:
name: web.config” This does what you don’t want! i.e. it returns files that contain the words “web” and “config”, but it doesn’t return files that have file contents including those words.
name:= web.config” This command will return only matches for “web.config” nothing else.
Using Office 365 on Windows 10 you can bring up the emoticons window by pressing the Windows key + “.” or Windows + “;”.
Actually in typing the above I’ve just found out the same thing works in Firefox on Windows 10, so there’s a good chance it will work for any app on Windows 10. ☺
Currently have an issue where most of the time shutting down the PC just performs a restart, annoying to say the least, been going on since late 2018.
I’m currently trying out this solution to see if it can be resolved.
6-Dec-19: A couple of test shutdowns later and it seems to be working, one to monitor.
If you repeatedly use a Remote Desktop session and that session needs access to files on the machine you’re connecting from then you’d normally set up a network drive, possibly mapped as follows:
net use z: \\yourmachine\c$ /persistent:Yes
But, depending on how Draconian your network security is then mapping folders on user machines may actually be blocked. Strange one as this ability is mostly essential when working on a remote machine, especially if a developer. Fortunately you can map using the built in sharing of RDP. Same format as earlier just the machine name changes and effectively becomes a constant, so the mapping is now:
net use z: \\tsclient\c /persistent:Yes
And job done, until the next group policy is introduced blocking that…
See this link for details on how to use
An example, that retrieves all view names on the current server follows:
DECLARE @command varchar(100)
SELECT @command = 'USE ?; SELECT name FROM sysobjects WHERE type = ''V'' ORDER BY name'
EXEC sp_MSforeachdb @command
Need to find a column in a database? The following SQL will return the tables, and columns, that contain a wildcard value
SELECT c.name AS ColumnName,
t.name AS TableName
FROM sys.columns c
JOIN sys.tables t
ON c.object_id = t.object_id
WHERE c.name LIKE '%column_name%'
ORDER BY TableName,
Try this solution, posted as a fix for Windows 7 but worked for me under Windows 10.
Quick post, aide-memoire, for disabling and then re-instating database contraints in MS-SQL.
EXEC sp_MSforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT ALL"
EXEC sp_MSforeachtable @command1="PRINT '?'", @command2="ALTER TABLE ? WITH CHECK CHECK CONSTRAINT ALL"