Skip to content

Tomas Lind

  • Home
  • About – Tomas Lind
  • Contact
  • Blog Series
    • Technical Analysis (TA)
  • T-SQL
    • T-SQL Scripts
    • Templates
  • Consulting Services
  • Software
Default collation different from instance default
Posted in
  • Collation
  • Configuration

Default collation different from instance default

If you have databases with another default collation than the instance default, you may get something … Default collation different from instance defaultRead more

by Tomas Lind•2014/06/122015/12/07•0
Error 3624 when creating natively compiled stored procedure
Posted in
  • Bug
  • In-Memory

Error 3624 when creating natively compiled stored procedure

I was trying to upgrade my MACD technical analysis calculation to use the new In Memory … Error 3624 when creating natively compiled stored procedureRead more

by Tomas Lind•2014/05/242014/05/24•0
Sorted data flows in SSIS
Posted in
  • SSIS

Sorted data flows in SSIS

Sometimes a data flow in SSIS needs to be sorted. It may be because the business … Sorted data flows in SSISRead more

by Tomas Lind•2014/05/202014/05/18•1
Add missing lookup in SSIS
Posted in
  • Master Data Services (MDS)
  • SSIS

Add missing lookup in SSIS

Before a fact table is loaded, a common pattern is to do a lookup in SSIS … Add missing lookup in SSISRead more

by Tomas Lind•2014/05/132014/05/12•7
T-SQL function SERVERPROPERTY
Posted in
  • Configuration
  • System Stored Procedures

T-SQL function SERVERPROPERTY

The T-SQL function SERVERPROPERTY returns a lot of properties about the current SQL Server instance. The … T-SQL function SERVERPROPERTYRead more

by Tomas Lind•2014/05/062015/12/07•0
Table Valued Parameters in Stored Procedures
Posted in
  • T-SQL

Table Valued Parameters in Stored Procedures

In most cases stored procedures are developed so that it accepts a number of input parameters … Table Valued Parameters in Stored ProceduresRead more

by Tomas Lind•2014/05/012014/04/28•0
MDS Error httpwebrequest_webexception_remoteserver arguments: NotFound in MDS
Posted in
  • Master Data Services (MDS)

MDS Error httpwebrequest_webexception_remoteserver arguments: NotFound in MDS

A short note on this MDS error message and one of the possible causes.

by Tomas Lind•2014/04/292014/04/28•2
Reading the SQL Server error log with T-SQL – xp_readerrorlog
Posted in
  • Error log

Reading the SQL Server error log with T-SQL – xp_readerrorlog

SQL Server keeps a configurable number of error log files as text files on disk. So … Reading the SQL Server error log with T-SQL – xp_readerrorlogRead more

by Tomas Lind•2014/04/222014/04/16•0
SQL Server error log location
Posted in
  • Configuration
  • Error log

SQL Server error log location

The SQL Server service keeps its own error logs outside of SQL Server in a number … SQL Server error log locationRead more

by Tomas Lind•2014/04/172014/04/17•0
Manual failover in a SQL Server cluster
Posted in
  • Failover Cluster

Manual failover in a SQL Server cluster

In this blog post, I’ll demonstrate how to find the currently active node in a SQL … Manual failover in a SQL Server clusterRead more

by Tomas Lind•2014/04/152015/11/04•7

Posts pagination

Previous 1 … 4 5 6 … 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