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
470 reads
Blog Posts
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
282 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
122 reads
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,265 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
728 reads
Persisting data in docker containers – Part Two
Last week in Part One I went through how to mount directories from the host server into a docker container...
2017-07-10 (first published: 2017-06-28)
1,630 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,005 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
250 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
366 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
7 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers