I’m Speaking! Code PaLOUsa!
This summer I’m going to try something a little different. I’ll be speaking at a technology conference that is not...
2017-04-18
367 reads
John Morehouse | Sqlrus.com
T-SQL Tuesday #89 – There is No Cloud
T-SQL Tuesday is a monthly blog gathering for the SQL Server/Data Professional community It is the brainchild of Adam Machanic (B|T)...
2017-04-11
329 reads
Schedulers To Rule Them All
Sometimes things just don’t make sense.
One of our production servers has 4×8 (4 sockets, 8 core) processors with hyper threading enabled. This...
2017-03-17
855 reads
May MVP – Bob Pusateri
Whoa. I’m way behind in my blogging.
For the month of May, my MVP choice is Bob Pusateri (B|T).
Bob is a...
2016-10-06
445 reads
I’m Speaking! SQL Saturday #548 – Kansas City
This weekend I’ll be traveling to Kansas City, Missouri for their annual SQL Saturday. This particular event is like going home...
2016-09-22
457 reads
Quick Script – Finding Most Recent Backup
Recently I have had to restore a number of databases into our training environment. Looking up each backup individually would...
2016-09-27 (first published: 2016-09-19)
1,324 reads
April MVP – Chris Yates
The April MVP nomination is Chris Yates (B|T).
Chris is one of those individuals that always have a positive outlook on...
2016-04-28
877 reads
Changing Of the Guard
As many of you know, I stay very active within the PASS community. In late 2007 I got my start,...
2016-04-14
493 reads
March MVP – Gareth Swanepoel
The March nomination is Gareth Swanepoel (B|T).
If you don’t know Gareth you should make it a point to get to know...
2016-03-31
774 reads
Nothing To See Here
In a galaxy far, far, far away a developer of a third party application somewhere in the Hoth system had to...
2016-03-29
891 reads
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
FARE Labs is The Leading FSSAI Third Party Auditing Services of India.
If you are looking for India’s best FSSAI Third Party Auditing Services in India....
Dealing with huge heap tables
Recently, our dev teams approach me for advice on improving their huge heap table...
Merge Replication failing with Error converting data type nvarchar to numeric
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers