Skip to content
  • home
  • featured
    • pencil ‘n more
    • Bestes Sohn Seite
  • impressum
  • datenschutz

Just another SQL blog

  • home
  • featured
    • pencil ‘n more
    • Bestes Sohn Seite
  • impressum
  • datenschutz

Category: English

TRY_CONVERT // Converting data to date, datetime, datetime2, time

9. March 202410. March 2024 marcus

Content Overview Probably the most challenging conversion is the conversion of a date and/or time, which is supplied as text, into a value of type date, time, datetime or datetime2. SQL Server provides the following data types, among others, for Read More …

All Languages, EnglishData Quality, Data type, Design Pattern, TRY_CONVERT

TRY_CONVERT // Converting data to bit

7. March 202410. March 2024 marcus

Content Overview SQL Server provides the bit data type for storing yes/no information. Converting an input value into a value of type bit can be a small challenge. Ideally, yes/no information is stored in the source system in a data Read More …

All Languages, EnglishData Quality, Data type, Design Pattern, TRY_CONVERT

TRY_CONVERT // Converting data to float, real

6. March 202410. March 2024 marcus

Content Overview SQL Server provides the following data types for storing floating point numbers: The data types float and real are not precise data types. They are suitable for storing particularly large or small values, but at the expense of Read More …

All Languages, EnglishData type, Datenqualität, Design Pattern, TRY_CONVERT

TRY_CONVERT // Converting data to money, smallmoney

3. March 20249. March 2024 marcus

SQL Server provides the following data types for storing currency values: The data type money is essentially identical to the data type decimal(19, 4) and the data type smallmoney to the data type decimal(10, 4). There are internal differences in Read More …

All Languages, EnglishData Quality, Data type, Design Pattern, TRY_CONVERT

Data quality in an ETL process

2. March 20247. March 2024 marcus

There is a lot of good literature on the subject of data quality. As a rule, this topic is described more theoretically, with impressive examples and the importance is proven with theories. However, I have not yet found any concrete Read More …

All Languages, EnglishData Quality, Design Pattern, ETL-Process

TRY_CONVERT // Converting data to bigint, int, smallint, tinyint

2. March 20249. March 2024 marcus

This article describes how to safely convert input values to bigint, int, smallint and tinyint data types. A seemingly simple task, one would think. For example, what happens if you want to convert a decimal number or an empty string Read More …

All Languages, EnglishData Quality, Data type, Design Pattern, TRY_CONVERT

Design Pattern // Logging an ETL process with T-SQL

20. February 202424. February 2024 marcus

How can you judge whether an ETL process has been successful? The mere fact that a process was not terminated with an exception does not necessarily mean that the process did what was expected of it. Readable and evaluable logging Read More …

All Languages, EnglishData Integration, Design Pattern, ETL-Process, Exception-Handling, Logging, Logging an ETL-Process, SQL, Stored Procedures, T-SQL

SSIS vs. SQL – Readability/Maintenance -or- How much of SQL you want to have in your SSIS package?

18. September 201819. February 2024 marcus

How this articel has developed… SQL Server Integration Services (SSIS) is a very powerful graphical tool set belonging to the Microsoft BI Stack along with SQL Server, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), etc. It supports Read More …

All Languages, EnglishCTE, SSIS, SSIS vs. SQL, T-SQL, Windowed Function

SSIS vs. SQL – Source Code Management

30. August 201810. May 2020 marcus

Dieser Artikel in Deutsch… Overview SQL Server Integration Services (SSIS) is a very powerful graphical tool set belonging to the Microsoft BI Stack along with SQL Server, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), etc. It supports Read More …

All Languages, EnglishCTE, Multi Developer Environment, SSIS, SSIS vs. SQL, T-SQL, TFS, Windowed Function

SSIS vs. SQL – Impersonation

17. August 20189. May 2020 marcus

Overview SQL Server Integration Services (SSIS) is a very powerful graphical tool set belonging to the Microsoft BI Stack along with SQL Server, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), etc. It supports a broad variety of Read More …

All Languages, EnglishSSIS, SSIS vs. SQL, T-SQL

Posts navigation

Older posts

latest posts

  • TRY_CONVERT // Converting data to date, datetime, datetime2, time 9. March 2024
  • TRY_CONVERT // Konvertierung nach date, datetime, datetime2, time 9. March 2024
  • TRY_CONVERT // Converting data to bit 7. March 2024
  • TRY_CONVERT// Konvertierung nach bit 7. March 2024
  • TRY_CONVERT // Converting data to float, real 6. March 2024

archive

  • March 2024
  • February 2024
  • September 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018

categories

  • All Languages (41)
    • English (18)
    • German (23)

tags

Architecture Column Editor CTE Data Cleansing Data Integration Data Quality Data type Datenqualität Design Pattern ETL-Process Exception-Handling Extract Format Load Logging Logging an ETL-Process Maintenance Multi Developer Environment Namenskonvention Naming Convention SQL SSIS SSIS vs. SQL SSMS options Stored Procedures T-SQL TFS Transform TRY_CONVERT Type Conversion Wartbarkeit Windowed Function
  • datenschutz
  • impressum
  • contact
Copyright. All rights reserved.
Powered by WordPress | WEN Associate by WEN Themes