Skip to content

Tomas Lind

  • Home
  • About – Tomas Lind
  • Contact
  • Blog Series
    • Technical Analysis (TA)
  • T-SQL
    • T-SQL Scripts
    • Templates
  • Consulting Services
  • Software
CDC Capture job
Posted in
  • Change Data Capture (CDC)

CDC Capture job

An introduction to CDC can be found here. When CDC (Change Data Capture) is enabled on … CDC Capture jobRead more

by Tomas Lind•2014/04/102014/04/08•0
CDC Cleanup job
Posted in
  • Change Data Capture (CDC)

CDC Cleanup job

An introduction to CDC can be found here. All data modifications in a CDC enabled table … CDC Cleanup jobRead more

by Tomas Lind•2014/04/082014/04/08•0
SSDT and three part names
Posted in
  • SSDT

SSDT and three part names

Currently, SSDT (SQL Server Data Tools) in Visual Studio doesn’t accept self referencing three part names. … SSDT and three part namesRead more

by Tomas Lind•2014/04/032014/04/03•3
Master Data Services – MDS – Introduction and Concepts
Posted in
  • Master Data Services (MDS)

Master Data Services – MDS – Introduction and Concepts

MDM – Master Data Management Some types of data are shared across systems. One of the … Master Data Services – MDS – Introduction and ConceptsRead more

by Tomas Lind•2014/03/272017/03/08•0
Can’t shrink log file
Posted in
  • Transaction Log

Can’t shrink log file

On a heavily utilized system with lots of transaction, shrinking the log file may be difficult. … Can’t shrink log fileRead more

by Tomas Lind•2014/03/252014/04/11•0
SQL Server Change Data Capture (CDC) Basics
Posted in
  • Change Data Capture (CDC)

SQL Server Change Data Capture (CDC) Basics

Change Data Capture (CDC) was first introduced in SQL Server 2008, and is a tool that … SQL Server Change Data Capture (CDC) BasicsRead more

by Tomas Lind•2014/03/202014/03/12•2
Posted in
  • T-SQL

NULL and aggregates

An aggregate in SQL Server will ignore NULL values. Check out this simple demonstration to learn … NULL and aggregatesRead more

by Tomas Lind•2014/03/182014/03/14•2
Introduction to Automate BPA Server
Posted in
  • Architecture
  • Automate BPA Server
  • SQL Agent

Introduction to Automate BPA Server

If you are using SQL Agent together with SSIS and if you have a batch job … Introduction to Automate BPA ServerRead more

by Tomas Lind•2014/03/132014/03/16•0
Map users to logins
Posted in
  • Permissions
  • Security
  • System Stored Procedures

Map users to logins

“Why can’t I login after the database restore?” As a DBA, this is one of the … Map users to loginsRead more

by Tomas Lind•2014/03/112014/02/27•0
sp_cycle_errorlog
Posted in
  • Configuration
  • System Stored Procedures

sp_cycle_errorlog

Sometimes the error log files in SQL Server get too large to view and manage in … sp_cycle_errorlogRead more

by Tomas Lind•2014/03/062014/02/25•3

Posts pagination

Previous 1 … 5 6 7 … 10 Next

confided data manager

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Top Posts & Pages

  • SQL Agent job logging with tokens
  • Export data from Excel to SQL Server
  • Manual failover in a SQL Server cluster
  • How to align columns in Notepad++
  • List SQL server roles by users

Recent Posts

  • Get element max value from folder with XML files
  • Dynamic Data Masking (DDM) – Mask query results
  • The T-SQL Merge statement
  • From SQL Server to MSMQ using PowerShell
  • Identity columns that are about to overflow

Archives

Categories

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Copyright © 2025 Tomas Lind.
Powered by WordPress and HybridMag.
  • Home
  • About – Tomas Lind
  • Contact
  • Blog Series
    • Technical Analysis (TA)
  • T-SQL
    • T-SQL Scripts
    • Templates
  • Consulting Services
  • Software