T-SQL: Running Total or Replace Text with Running Variable in Groups
Running total in groups: Running text replace in groups: Get the result: Keep it simple :-)
MariaDB: PIVOT
I googled “mariadb pivot” and the first answer was this. Ouch, this is a big (and complex) procedure. Then I scrolled down, but I couldn’t find a quick answer, so I created one. Here is the template: Keep it simple :-)
T-SQL: Recursive CTE. List Child to Parent (Create Breadcrumb)
I create a web application and I need to show the navigation to the current page as breadcrumb. The structure of the menu is stored in the database and I will use a recursive CTE to show the current page as breadcrumb.
T-SQL Hint: What are the values that we can insert into BIT column
I met a code that CONVERT(BIT, Value) and insert into BIT column. Let’s see what are the possible values.
T-SQL: The ‘quote_character’ in the Built-in Function QUOTENAME()
I needed to quote an identifier (a column name) with “<“. I checked the documentation for the build-in function QUOTENAME() and I did not find the information that I need. Here is a quick T-SQL to show which characters we can use as a second argument of the function.
SSIS: Check for Errors in SSISDB and Send Email
SSISDB is the database that is collaborating with SSIS. When we execute a package, the execution information is logged in SSISDB. If a job is scheduled, we need to know if there are errors in the executions. As a last step in SSIS package, I run stored procedure that searches […]
T-SQL: Change Tracking Retention Period – What do we have after it expires
In the last posts we played with Change Tracking (CT): T-SQL: Change Tracking – What is this and how it works T-SQL: Change Tracking Retention Period – How Long the Changes are Kept? Let’s execute few queries and see what do we have after the retention period expires.
T-SQL: How to Search for % in String (% and LIKE)
In one of my web projects (ASP.NET and SQL Server) I have a screen with top 50 customers. To facilitate the client, I put few textboxes and give them the chance to filter the customers, until they reach the one that they need. In another case I use a textbox […]
T-SQL: Change Tracking Retention Period – How Long the Changes are Kept
As we mentioned in Change Tracking – What is this and how it works, the retention period is the one that determines how long the changes are kept.
T-SQL: Change Tracking – What is this and how it works
Change tracking was introduced in SQL Server 2008. This is a tool that keeps the fact that there are changes in tracked tables for a specified period of time. It doesn’t show what the changes are, it tells that a data has been changed. It answers if a change has been […]