Pages

▼
Showing posts with label SQL Server. Show all posts
Showing posts with label SQL Server. Show all posts
2025-11-30

Restore WideWorldImporters

›
For many years AdventureWorks was the primary sample database from Microsoft for SQL Server. But with many new features and new ways to stru...
2025-01-05

The obscure star-database

›
To play around with some obscrure naming possibilities in SQL Server I create the star-database. The name has nothing to do with the data wa...
2024-11-19

List orphan database users

›
Some days ago I was asked - politely - to move some databases between two SQL Server installations. Unfortunately the service had failed on ...
2024-10-28

Put SQL Server PVS in own filegroup

›
Putting the Persisted Version Store (PVS) in its own file group is to improve the performance of SQL Server Accelerated Database Recovery (A...
2024-09-09

SQL Server Workstation

›
Some notes from a SQL Server 2022 Developer Edition installation on a Windows 11 Pro workstation. The infrastructure is VMware Workstation P...
2024-07-03

Stored Procedure Guidelines (T-SQL)

›
Here are some personal guidelines on writing and using a stored procedure. They are mentioned in a somewhat random order. The list and each ...
2024-05-13

Buffer Pool scan

›
In a SQL Errorlog we saw a lot of events like this. Buffer Pool scan took 10 seconds: database ID 6, command 'CHECKPOINT', operatio...
2024-01-28

Integrated Security = SSPI

›
 The term  Integrated Security = SSPI is a element in a connection string for an application to get access to a data source using a OLEDB o...
2024-01-23

PowerShell SMO by SqlServer module

›
Install SqlServer module: Install-Module -Name sqlserver Typical warning: Untrusted repository You are installing the modules from an ...
2024-01-01

Top-ten posts 2023

›
2023 was – again – a year with far less posts than planned. Fortunately some elder posts still generate some activity on this blog. The top...
2023-02-14

Add SQL Agent job step with tokens in output file name

›
 If you create a new SQL Agent job step with tokens in output file name using the stored procedure sp_add_jobstep or want to add a filename...
2023-01-27

UDL-file connection to SQL Server

›
UDL is a component in Windows named Universal Data Link. To be more specific it is a OLE DB tool that is a connection defined in a UDL-file ...
2022-11-29

MSDTC Operations

›
Microsoft Distributed Transaction Coordinator , abbreviated MSDTC or just DTC, is a somewhat aged but still very essential technology from M...
2022-08-10

SqlClient 5.0

›
The .NET data provider SqlClient for SQL Server has been released in version 5.0 for general availability. This is a new major version so yo...
2022-07-15

Execute on a subset of databases

›
Sometimes it is necessary to execute a command or a statement on a subset of the databases in a instance. A quick solution is to generate th...
2022-07-11

RAISERROR with UNIQUEIDENTIFIER

›
The T-SQL type Uniqueidentifier is not a formatting possibility for at RAISERROR message. But converting the value to a string is a quick f...
2022-05-31

Descriptions

›
Databases and objects in databases on SQL Server can be described with the Extended Property MS_Description . This description can be read b...
2022-05-05

Restore AdventureWorks

›
There are several SQL Server sample databases from Microsoft, and one of the easiest to start and still somewhat up-to-date is AdventureWork...
2022-03-25

xp_dirtree (T-SQL)

›
It is possible to get the content of a directory from T-SQL with the Extended Stored Procedure (XP) master.dbo.xp_dirtree. This only requir...
2022-01-01

Top-ten posts 2021

›
Looking back at 2021 not only as another year with the Covid-19 pandemic. For various reasons it has only been a year with fewer posts than ...