Archive for the ‘SQL Server’ Category

Microsoft SQL Server 2012 – Product Support Lifecycle Policy June 2023

Sonntag, Juni 25th, 2023

Microsoft SQL Server – export XML column rows from SQL table into individual files

Samstag, Mai 21st, 2022

   Microsoft SQL Server – export XML column rows from SQL table into individual files

It is roughly formatted as such

+————–+——————+
| REFERENCE_ID | REFERENCE_XML |
+————–+——————+
| 1 | <xml>…</xml> |
| 2 | <xml>…</xml> |
| 3 | <xml>…</xml> |
| 4 | <xml>…</xml> |
| … | <xml>…</xml> |
| 70000 | <xml>…</xml> |
+————–+——————+

I would like to loop through every row and bulk export each REFERENCE_XML column and name it as the REFERENCE_ID

My output folder set would look as such

C:\References\1.xml
C:\References\2.xml
C:\References\3.xml
C:\References\4.xml
C:\References\…
C:\References\70000.xml

Microsoft SQL Server – Datenbank-/Tabellengrössen von jeder Datenbank einer Instanz

Donnerstag, April 14th, 2022

Microsoft SQL Server Profiler – to capture an expensive query running on a SQL Server Instance using a Profiler Trace

Montag, Oktober 4th, 2021

Microsoft SQL Server Profiler  – is an interface to create and manage traces and analyze and replay trace results events are saved in a trace file that can later be analyzed or used to replay a specific series of steps when diagnosing a problem

SolarWinds Database Performance Analyzer – zeigt Leistungsprobleme auf und bietet Optimierungstipps von Experten

Mittwoch, August 11th, 2021

Quest Foglight for SQL Server – diagnose and resolve database performance issues with monitoring software

Samstag, Juli 31st, 2021

Quest Foglight for SQL Server – you can quickly diagnose and resolve SQL Server performance problems and optimize your workloads to prevent future issues. This SQL Server tuning tool includes real-time and historical diagnostics, reporting and more, so you can confidently ensure the health of your entire database environment

Quest Spotlight on SQL Server Enterprise – monitor and optimize SQL Server database performance from any device

Samstag, Juli 31st, 2021

Microsoft SQL Server 2019 – Licensing Datasheet

Mittwoch, Februar 3rd, 2021

Microsoft SQL Server 2019 – Licensing for On-Premises VMware vSphere Implementations

Mittwoch, Februar 3rd, 2021

Microsoft SQL Server Licensing for On-Premises VMware vSphere Implementations – Part One

Microsoft SQL Server Licensing for On-Premises VMware vSphere Implementations – Part Two

Microsoft SQL Server 2019 – Licensing Guide

Mittwoch, Februar 3rd, 2021

Microsoft SQL Server 2019 – Licensing Guide

Microsoft SQL Server – VMware vSphere Best Practices Guide

Samstag, Juli 18th, 2020

Architecting Microsoft SQL Server on VMware vSphere – Best Practices Guide

Microsoft SQL Server – Licensing for On-Premises VMware vSphere Implementations

Samstag, Juli 18th, 2020

With the recent releases of both VMware vSphere 7 and SQL Server 2019 as well as changes announced to SQL Server licensing this is a good time to discuss – Licensing for SQL Server when virtualized using VMs with VMware vSphere

Microsoft SQL Server 2017 – unter Linux können Sie teure Datenlösungen hinter sich lassen und sich von frustrierenden Preisplänen verabschieden

Samstag, Juli 20th, 2019

Microsoft SQL Server 2016 – High Availability (HA) using SQL Server Always On Availability Group (AG)

Montag, Juni 17th, 2019

Microsoft SQL Server – to determine your current version number and the corresponding servicing or service pack level

Montag, Januar 14th, 2019