Skip to content

Kenneth Dalbjerg

Kenneth Qvistgaard Dalbjerg, IT Konsulent i århus

Kenneth Dalbjerg

Kenneth Qvistgaard Dalbjerg, IT Konsulent i århus

  • Home
  • Curriculum Vitae
    • Home
    • Computer
    • Windows
    • MSSQL
MSSQL

Clear mssql cache

admin February 14, 2023 0 Comments

If you for example need to test a query against two SQL servers hardware, its a good idea to clear the cache first.This query can do this:

MSSQL

MSSQL – See status of running jobs

admin January 18, 2022 0 Comments

If you ever need to see the status of a running jobs, this TSQL can be very helpfull

MSSQL

MSSQL – Always On availability group – Get sync status

admin January 8, 2022 0 Comments

If you wan to know the sync status of a always On availability group database replication, this command can be used:

MSSQL

MSSQL Backup History Query

admin February 1, 2021 0 Comments

To see MSSQL history Query, run this SQL query. It will show all backups between the 1 january 2021 and 1 february 2021, order by Database and then Last backup…

MSSQL

SQL – Check with statements that are blocked

admin April 30, 2020 0 Comments

You can check which statements are blocked by running this

MSSQL

MSSQL database roles get all securables – Full script out the Database Roles

admin September 11, 2019 0 Comments

Thanks for the script to John Eisbrener - Check for new version here: https://dbaeyes.wordpress.com/2013/04/19/fully-script-out-a-mssql-database-role/

MSSQL

MSSQL – check that the Agent Job have been run as Schedule

admin July 17, 2019 0 Comments

I have this problems, that if a schedule inside a Agent job, have not been started for some reason, there will be no errors about this problem. So Í have…

MSSQL

Implement SQL Server Agent Jobs with AlwaysOn Availability Groups

admin July 4, 2019 0 Comments

The function I use fn_hadr_group_is_primary from this post is a UDF (User Defined Function) that we create in the master database. The function gets an Availability Group name as an input parameter and returns…

Andet MSSQL

mssql get the backup information with copy_only information.

admin March 20, 2019 0 Comments

I need to find a way to see if the backup chain where broken. On my search I found this could script, created by "hot2use"I have found this script on…

MSSQL

Monitoring a Automatic Seeding in msSQL Always on Availability Groups

admin January 8, 2019 0 Comments

This command, can be run on both the primary and secondary node.

Posts navigation

1 2 3

Next Page »

Kategori

  • Andet (36)
  • Computer (279)
    • Ahsay (7)
    • Certificate (3)
    • Cisco (7)
    • Dell (7)
    • ESXi (5)
    • HPE (1)
    • Linux (54)
      • Debian (23)
      • Kubuntu (4)
      • Postfix (5)
    • Nimble Storage (1)
    • Programmering (11)
      • PHP (1)
    • vmware (2)
    • VPN (4)
    • Windows (190)
      • Active Directory (3)
      • AppV (1)
      • AzureAD (1)
      • CA (2)
      • Citrix (27)
      • Exchange (44)
      • GPO (1)
      • HyperV (3)
      • MSSQL (30)
      • Office365 (6)
      • Powershell (31)
      • RDS / Terminal (6)
    • Xenserver (14)
  • kennethdalbjerg.dk (13)
  • MIG (51)
  • Sjovt (4)

Links

  • Andersvn.dk – A colleague
  • Collision.dk – A colleague
  • Frijsendal Friskole
  • Gratis mailhotel
  • Guldhammer
  • Heidi Qvistgaard
  • Hestehus.dk
  • HTC Desire HD
  • IPCalc
  • It-afdelingen A/S Århus
  • Labrador Hvalpe
  • Lbjerg.dk – Link Index
  • Maria & Jens
  • Mobilt internet
  • Nyt tag Herning
  • SMTP
  • SMTP Server
  • Tjen Penge

Arkiv

Kalender

June 2023
M T W T F S S
 1234
567891011
12131415161718
19202122232425
2627282930  
« Apr    

Tag Cloud

Active Directory Ahsay Andet AppV AzureAD CA Certificate Cisco Citrix Computer Debian Dell ESXi Exchange GPO HPE HyperV kennethdalbjerg.dk Kubuntu Linux MIG MSSQL Nimble Storage Office365 PHP Postfix Powershell Programmering RDS / Terminal Sjovt vmware VPN Windows Xenserver

cmu.edu

You Missed

PHP

Connect to 365 Exchange mailbox with IMAP and OAuth

MSSQL

Clear mssql cache

AzureAD Office365 Windows

Computer won’t join Azure AD

Andet

Veeam backup and Replication – Failed to call RPC function ‘Vss.TruncateSqlLogs’

Kenneth Dalbjerg

Kenneth Qvistgaard Dalbjerg, IT Konsulent i århus

Copyright © All rights reserved | Blogus by Themeansar.

  • Home
  • Curriculum Vitae