Skip to content

Jim Salasek's SQL Server Blog

Sharing what I learn about Sql Server

  • Home
  • About
  • Contact

Recent Posts

  • Terminate SSIS Jobs: A Step-by-Step Guide January 7, 2025
  • Copy SQL Server tables between servers easily with dbatools. December 17, 2024
  • Master Filtering in SSMS: Quick Database Object Access December 3, 2024
  • Find SQL Server Tables with Identity Columns Easily November 12, 2024
  • How to find all jobs that call a stored procedure. June 4, 2024
November 2026
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
30  
« Jan    

Tag: t-sql

SQL Server Like operator

I have been using SQL Server for almost 10 years, and I just learned something new using the LIKE operator. You can search any single character within a specified range by using a bracket [ ]. Lets look below to see what I mean.

Continue reading SQL Server Like operator
Posted on August 3, 2022May 30, 2022Categories Hints and TipsTags Like, t-sql, wildcard, [ ]Leave a comment on SQL Server Like operator

Restore Database using T-SQL

You can also restore your SQL Server database using T-SQL instead of SSMS.  Today I will show you how to do an easy recovery with restoring just a full backup and another scenario of restoring a full backup and any available transaction logs.

Continue reading Restore Database using T-SQL

Posted on March 21, 2017February 26, 2017Categories Hints and TipsTags norecover, recovery, restore database, restore log, t-sqlLeave a comment on Restore Database using T-SQL
Create a website or blog at WordPress.com
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Subscribe Subscribed
    Jim Salasek's SQL Server Blog
    Join 32 other subscribers

    Have a WordPress.com account? Log in now.

  • Jim Salasek's SQL Server Blog
    View site in Reader
    Manage subscriptionsSign upLog in
    Report this content
    Collapse this bar