Blog.sqlserveronline.com

  1. Home
  2. Blog.sqlserveronline.com

SQL Server / SSMS / Expanding Indexes List Query

WEBSame as in previous posts examples Expanding Tables List Query and Expanding Columns List Query I usually do not notice this type of queries working in the …

Actived: 9 days ago

URL: https://blog.sqlserveronline.com/2019/03/11/sql-server-ssms-expanding-indexes-list-query/

SQL Server / SSMS / Expanding Tables List Query

WEBUsually I do not even notice this query working in the background, since this operation is quite fast. But recently I end up working with a customer having DB with …

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 / Monitor Backup and Restore progress

WEBTo follow up backup or restore progress with start time, total elapsed time and estimated completion time in similar situation you can use following script. You can …

Category:  Health Go Health

SQL Server / 64KB Allocation Unit Size

WEBThere are really good whitepapers with a recommendation to keep allocation unit size for SQL Server data and log drives at 64KB. 64KB presents one full extent or 8 …

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

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

Azure SQL Managed Instance / Database Migration Service (DMS) …

WEBUsing Azure Database Migration Service (DMS) you can easily migrate your databases from multiple sources to Azure Data platforms with minimal downtime. For …

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

PowerShell / SQL Server / Cannot find type Microsoft.SqlServer

WEBHi DjE, Starting in PowerShell 5.0, with the addition of the PowerShellGet module, and the PowerShell Gallery of community and Microsoft-created resources, the …

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 / 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

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 …

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

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

SQL Server / Login failed for user ‘DOMAIN\MACHINENAME$’.

WEBExample, ‘DOMAIN\MACHINENAME$’, login will fail since you need to grant access to this account. You can solve this in two ways, you can create login and grant …

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

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

 › Flagler health st augustine

 › Wow npc health bars key

 › Gemino health care funding

 › Wow friendly health bars

 › Adirondack health is department

 › Friendly nameplates no healthbar

 › Kids health learning sites

 › Rural health clinic hugo ok

 › Vermont health connect renewal

 › Burn crusade health and mana

Recently Searched

 › Sunshine health dental phone number

 › Relias health training air force

 › Canadian public health core competencies

 › Create a healthcare id

 › Is chicken stir fry healthy

 › Axa health max benefits

 › Skyrim enemy health mods

 › Health promotion coordinator jobs

 › Health bar qvantry mod

 › Mental health prognosis sample