Access to SQL Server is finally coming
Imagine a world where one of the software giants releases their brand new operating system and a new application architecture...
2017-06-09
1,581 reads
Confessions of a Microsoft Addict
Time saving trick for PowerShell and CMD
Real quick and simple post for today. Having grown up with a computer since the 80’s, I can tell you...
2017-06-08
526 reads
SQL Server Monitoring: Creating your own metrics
The one and only important factor in monitoring is data. How much of x and how little of y? If...
2017-06-05
566 reads
If Clippy found his way to SSMS
Recently my wife and I were comparing Cortana with Siri. It’s sometimes fun to compare virtual assistants to see how...
2017-06-16 (first published: 2017-06-01)
2,697 reads
Not SQL: Taking a stand against scammers
If you’ve read my blog you’ll probably know that I don’t like our lack of forward thinking when it comes...
2017-05-03
520 reads
DBA 101: Tuning lookups
Sometimes it helps to go back to the basics and indexing is always a great topic. SQL Server has a...
2017-05-09 (first published: 2017-04-27)
3,096 reads
Query tuning 101: What’s a probe residual?
Query tuning is an important process that will probably never go away and sharpening your tuning skills is always a...
2017-04-26 (first published: 2017-04-17)
3,329 reads
DBA 101: Comparing two SQL plans
Simple post today: How to compare two plans in SSMS.
This task is a task that is often done by a...
2017-04-18 (first published: 2017-04-14)
2,025 reads
Way Off-topic: Why cutting the cord was right for me
FYI: This one is way off topic so don’t expect to find any fancy SQL tips here.
I did it. I...
2017-04-14
488 reads
T-SQL Tuesday: Finding issues with your query plan
This is my first time blogging with a T-SQL Tuesday topic. If you follow my blog you’ve probably noticed that...
2017-04-11
487 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...