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 […]
Training: The Paperback version of Learn Microsoft® SQL Server® Intuitively. Transact-SQL: The Solid Basics is on Amazon
Hi Intuitive Learners, One year ago the Kindle version of Learn Microsoft® SQL Server® Intuitively. Transact-SQL: The Solid Basics was published on Amazon. Now the paperback version of the book is available on Amazon and you can take a quick look at it here. You can contact us all the […]
T-SQL: UDF Scalar Function to quote the DB Object Name
While working on ETL, I build a list of tables and their corresponding columns that need to be created on the destination server. In this case the square brackets around SchemaName and TableName are mandatory. I started adding the square brackets with the built-in function QUOTENAME(), but soon I got […]
T-SQL: UDF Scalar Function to Clean Multiple Spaces
While working on autocomplete dropdown, i created a simple scalar function that replaces multiple spaces with one.