Impact on Indexes When Mixing VARCHAR and NVARCHAR Types
You may have heard, or read, that you should not mix VARCHAR and NVARCHAR datatypes, especially when one of them...
2017-07-10
5,287 reads
Spider-Man Homecoming Twitter Sentiment
Hello Dear Reader! This past Thursday night I took my son Zachary to see Spider-Man Homecoming, it was an amazing movie with a fantastic cast. Both of us are...
2017-07-10
16 reads
Spider-Man Homecoming Twitter Sentiment
Hello Dear Reader! This past Thursday night I took my son Zachary to see Spider-Man Homecoming, it was an amazing...
2017-07-10
371 reads
How to analyze SQL Server database performance using T-SQL
The performance of a database is the most challenging and critical part of database optimization. The challenge every DBA faces...
2017-07-10
471 reads
I’m Hosting! Idera July #sqlchat
Have you heard of these following terms and/or phrases?
Database Continuous DeliveryDatabase Lifecycle Management (DLM)DevOps[Insert other buzzword bingo entry here]You probably...
2017-07-10
125 reads
I’m Hosting! Idera July #sqlchat
Have you heard of these following terms and/or phrases?
Database Continuous DeliveryDatabase Lifecycle Management (DLM)DevOps[Insert other buzzword bingo entry here]You probably...
2017-07-10
284 reads
Running SSIS in an Azure VM
In the previous post in this series, I addressed how to use an on-premises instance of SSIS to move data...
2017-07-10
1,007 reads
The Choices We Make
If you keep your head up and look around you’ll see the choices people make all the time. I saw...
2017-07-21 (first published: 2017-07-10)
1,982 reads
Self-Paced Online Trainings
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-07-10
255 reads
Monday Coffee: Database Deployments
I’ve always been particularly cautious when it comes to deploying code to databases, some would say overly cautious.
Because of this...
2017-07-10
730 reads
Blogs
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Forums
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Choose the Second One
Comments posted to this topic are about the item Choose the Second One
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers