Using LIKE on Integers Gets You Implicit Conversion
Using the Stack Overflow public export, take these two queries looking for a particular user by Id (the clustering key):SELECT * FROM dbo.Users WHERE Id = 26837; SELECT * FROM dbo.Users WHERE Id LIKE 26837; The first one (=) gets a clustered index seek …
The new Data Modeling for Power BI course
I recently published a new blog post on SQLBI.You can read it at this link: https://www.sqlbi.com/blog/marco/2018/02/06/the-new-data-modeling-for-power-bi-course/
How to use the SQL Prompt snippet placeholders for selecting and copying text
There are four SQL Prompt snippet placeholders that are all about selection and copying of text. These placeholders are very handy if, for example, you have two blocks of code that need to be part of a snippet. One part you hold on the clipboard, and t …
Stairway to Advanced T-SQL Level 6: Creating Rows Of Data Using The UNPIVOT Operator
The UNPIVOT operator does just the opposite of the PIVOT operator, which we looked at in the previous level. By using the PIVOT operator we can take multiple rows of data and create as single row as output. The UNPIVOT operator will take values from a …
Reduce SQL Server Costs with Heimdall Data Caching
This article explains how Heimdall Data auto-caches with zero disruption to your current infrastructure.
SQL SERVER – Unable to Repair – SQL_Telemetry_Repair_Startup_Cpu64 gives error – The Service Cannot Be Started
A few days ago, I wrote a blog where I have to perform repair of the SQL instance to fix the issue. While running repair, I encountered an interesting error. In this blog, we would learn how to fix error “The service cannot be started, either bec …
Setting mentoring ground rules
One of the things I always recommend in the first newsletter of each year is to try to get a mentor. On the flip side of that is that one of the most rewarding things you can do in your professional life is to *be* a mentor to one or more people. I men …
How to Survive as a Lone DBA
I was a Lone DBA for over 15 years and during that time I have learned a thing or two about how to survive on my own in relatively large environments. In this article, I will share with you some of the big things I learned during those years that may h …
T-SQL Tuesday #99 : Dealer’s Choice
T-SQL Tuesday #99 invitation……(read more)
The Annals of Hilariously Bad Code, Part 1: Critique the Code
Hey Beavis That’s the first time I’ve used “annals” correctly. I will be 40 sooner than later. Sometimes when we blog, we get inspiration from clients, students, other bloggers, questions on Stack Exchange, nightmares, or just d …
SQL Server Replication for Temporal Tables
In this tip, Ameena Lalani looks at how you can setup replication to include temporal history data.
SSIS Package with a Derived Column
I created this article to demonstrate the use of derived columns inside a ForEachLoop Container for a client requirement for some auxiliary marketing reports. I found the Data Conversion tool useful to escape the problem of mismatched data types, which …
Realistic, simulated data for testing, development and prototypes
This article proposes a scheme for using Redgate SQL Data Generator (SDG) as a ‘data generation and translation’ tool. We generate the data using a free copy of SQL Server Express, and then use standard bulk copy mechanisms to translate it …
SQL SERVER – Create Catalog Error 911: Database ‘SSISDB’ Does Not Exist. Make Sure That he name is entered correctly
Sometimes there are unexpected errors and it’s always fun to find the cause of them. In this blog, we would learn about fixing an error which I received while doing create catalog from SQL Server Management Studio. The text of the complete messag …
SQLskills SQL101: How You Can Make Your Database Backups More Reliable
SQLskills has an ongoing initiative to blog about basic topics, which we’re calling SQL101. We’re all blogging about things that we often see done incorrectly, technologies used the wrong way, or where there are many misunderstandings that …