jfperry
  • About
  • Database Administrator Consultants

Monthly Archives: October 2019

You are browsing the site archives by month.

DOS: For each file greater than date time run Command

October 10, 2019 1:30 pm \ by John Perry

@Echo OFF

C:

for /r %%A in (*) do (
if "%%~tA" GTR "2015-06-16 11:30" echo %%~tA %%A
)

Posted in: DOS

SSMS: Ctrl-E ^E stops executing query

October 1, 2019 3:08 pm \ by John Perry

Not sure what causes these keystrokes to stop working, but if you haven’t made any changes to SSMS keyboard options you can just push the RESET button. And it works again.

Posted in: Configuration

Categories

Backups Coding Configuration Documentation DOS ERRORs ETL ETL Excel Files HTML MAC master_admin Performance Permissions PowerShell Reports Services SQL SQLAgent SQL Server SSIS Uncategorized WEB Windows

Archives

October 2019
S M T W T F S
 12345
6789101112
13141516171819
20212223242526
2728293031  
« Aug   Dec »

Recent Posts

  • SQL: Last backups for all databases
  • SQL Agent: Use a batch file to run RoboCopy
  • DOS: For each file greater than date time run Command
  • SSMS: Ctrl-E ^E stops executing query
  • PowerShell: Remove brackets from all file names in folder

Tags

Audit Debugging Lesson Setup

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Pages

  • About
  • Database Administrator Consultants

Archives

  • December 2019
  • October 2019
  • August 2019
  • May 2019
  • April 2019
  • March 2019
  • February 2019
  • August 2018
  • July 2018
  • May 2018
  • April 2018
  • March 2018
  • January 2018
  • October 2017
  • September 2017
  • July 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • August 2016
  • July 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • January 2016
  • December 2015
  • November 2015
  • July 2015
  • May 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014
  • November 2014
  • October 2014
  • August 2014
  • May 2014
  • April 2014
  • March 2014
  • February 2014
  • January 2014
  • November 2013
  • July 2013
  • April 2013
  • March 2013
  • January 2011
  • October 2010
  • August 2010
  • July 2010
  • May 2010
  • March 2010
  • February 2010
  • December 2009
  • September 2009
  • July 2009
  • June 2009
  • May 2009
  • April 2009
  • March 2009
  • February 2009
  • January 2009
  • November 2008
  • October 2008
  • September 2008
  • August 2008
  • July 2008
  • February 2008
  • January 2008
  • October 2007
  • September 2007
  • July 2007
  • June 2007

Pages

  • About
  • Database Administrator Consultants

Categories

  • Backups
  • Coding
  • Configuration
  • Documentation
  • DOS
  • ERRORs
  • ETL
  • ETL
  • Excel
  • Files
  • HTML
  • MAC
  • master_admin
  • Performance
  • Permissions
  • PowerShell
  • Reports
  • Services
  • SQL
  • SQL Server
  • SQLAgent
  • SSIS
  • Uncategorized
  • WEB
  • Windows

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
© Copyright 2025 - jfperry
Prana Theme ⋅ Powered by WordPress