Blog.sqlserveronline.com

  1. Home
  2. Blog.sqlserveronline.com

PowerShell / SQL Server Backup / Cannot find type …

WEBMy name is Zoran, currently living in Auckland, New Zealand. I am a data specialist with more than 15 years of hands-on experience in database administration …

Actived: 2 days ago

URL: https://blog.sqlserveronline.com/2018/08/14/powershell-sql-server-backup-cannot-find-type-microsoft-sqlserver-management-smo-backup/

PowerShell / SQL Server / Check SQL Server current Update Status …

WEBMy name is Zoran, currently living in Auckland, New Zealand. I am a data specialist with more than 15 years of hands-on experience in database administration …

Category:  Health Go Health

SQL Server / Availability Group / Readable Secondary Replica …

WEBOne of the most common issues with Availability Group and using readable secondary replica is with Parallel REDO operations. On your readable secondary …

Category:  Health Go Health

SQL Server / Query Optimization / Memory Grant Warning / …

WEBRecently we had really nice meetup gathering here in Auckland. Was a beautiful evening, there were 20 people talking about SQL server, was perfect. One of …

Category:  Health Go Health

Azure SQL Managed Instance / Migration / Data Migration …

WEBBefore we migrate our database to the cloud we need to assess our on-premises SQL Server instance and Data Migration Assistant (DMA) tool can help us with …

Category:  Health Go Health

Azure SQL Managed Instances / SSMS / Connect to SQL Managed …

WEBIn the previous post we had example how to connect to Azure SQL Managed Instance from Azure VM within same VNet using private endpoint Now I will show you …

Category:  Health Go Health

SQL Server / Query Optimization / TempDB Page Splits / Table …

WEBBesides page splits on temporary database Table Spool operator may cause high number page lookups, page reads, disk I/O, so let’s see this in an example. You …

Category:  Health Go Health

Azure SQL Managed Instances / SSMS / Connect to SQL Managed …

WEBThere are different ways to connect to SQL Managed Instance using SSMS. One of the easiest ways to do that is using Private Endpoint. Azure SQL Managed …

Category:  Health Go Health

SQL Server / Instant File Initialization

WEBInstant file initialization reclaims used disk space without filling that space with zeros. What those this means for our SQL Server data files? Data file grow needs …

Category:  Health Go Health

Log Shipping Issue / Operating system error 32 (The process …

WEBMy name is Zoran, currently living in Auckland, New Zealand. I am a data specialist with more than 15 years of hands-on experience in database administration …

Category:  Health Go Health

Azure / SQL Server / Cannot open user default database (Login …

WEBFOR LOGIN azure_db_user. 2. GO. 3. EXEC sp_addrolemember N'db_owner', N'azure_db_user'. 4. GO. Now, if you try to connect to that db using SSMS …

Category:  Health Go Health

Azure / SQL Server / Rename an Azure SQL database

WEBJust one click on the database name and you will be able to type the new database name. Type new database name and confirm the change. USING Transact …

Category:  Health Go Health

Microsoft SQL Server 2012 Updates / RTM (11.00.2100) / SP1 …

WEBMy name is Zoran, currently living in Auckland, New Zealand. I am a data specialist with more than 15 years of hands-on experience in database administration …

Category:  Health Go Health

SQL Server / Initialize Secondary Database / Generate a full …

WEBRecent Posts. Microsoft SQL Server 2022 Updates / Release Candidate (RC 1) Evaluation Edition (16.0.950.9) SQL Server / PowerShell / Check SQL Server version …

Category:  Health Go Health

Microsoft SQL Server 2017 Updates / RTM (14.0.1000.169)

WEBMy name is Zoran, currently living in Auckland, New Zealand. I am a data specialist with more than 15 years of hands-on experience in database administration …

Category:  Health Go Health

SQL Server / Upgrading the Secondary Server Instances (STANDBY)

WEBIf you planning to upgrade to the new SQL Server Version 2016 or 2017 and if there is log shipping in place between those servers you should follow some upgrading …

Category:  Health Go Health

SQL Server / The target principal name is incorrect. Cannot …

WEBYou can verify domain user SPN is registered correctly with the following command. setspn –L Domain\Account. Write all properties permissions, Write msDS …

Category:  Health Go Health

Top Categories

 › Appendicitis

 › Headaches

 › Gout

 › Women's Health

 › Thyroid

 › Sleep

 › Skin

 › Sexual Health

 › Senior Health

 › Pregnancy

 › Oral Health

 › Neurology

 › Migraine

 › Mental Health

 › Men's Health

 › Menopause

 › Medications

 › Lung Conditions

 › Infectious Disease

 › HIV/AIDS

Popular Searched

 › Health insurance for employers group

 › Family health center college park ga

 › Barmer health insurance coverage

 › One health trust website

 › Honor health cash prices

 › Mental health reading activities k3

 › Health restricted activity regulation

 › Imperial health ipa provider portal

 › Free home health care certification

 › Veterans health administration home

Recently Searched

 › Texas telehealth rules mental health

 › Qualitative research definition health care

 › Https: healthpartners.nationsbenefits.com

 › Maggie fox health and science

 › Best rated health insurance uk

 › Hindley health centre appointments

 › What is neighborhood health plan

 › Medishare health insurance cost

 › Louisiana bayou health plans 2023

 › Behavioral health industry statistics