If you have databases with another default collation than the instance default, you may get something … Default collation different from instance defaultRead more
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
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
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
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
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
MDS Error httpwebrequest_webexception_remoteserver arguments: NotFound in MDS
A short note on this MDS error message and one of the possible causes.
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
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
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