PowerShell to Simulate Load
Gathering metrics is quite difficult if there are no queries. So, if you’re working in non-production environments, but you still...
2019-01-17 (first published: 2019-01-07)
2,257 reads
Blogs
Query plan hash
This is post 3 in the series about query fingerprints. Here’s the previous posts in this series:
Query HashSQL Handle
What is...
2019-01-07
179 reads
ArithAbort and SQL Agent Failures
ARITHABORT
I was coding along one day, working on rolling out some monitoring for a client—monitoring that I had used for previous...
2019-01-07
235 reads
SQL Bits Precon 2019
I am extremely happy to announce that I’ll be presenting a preconference training session with Bob Pusateri at this year’s...
2019-01-07
248 reads
Five database management trends to embrace in 2019
In 2018, companies looked for ways to improve their database performance and security. Their aim was to keep up with...
2019-01-07
295 reads
Data Warehousing Tip #3 – Build thin slice
My third data warehousing tip is to build thin slice. Deliver subsets of valuable functionality. Get feedback and buy in,...
2019-01-16 (first published: 2019-01-07)
2,817 reads
How to Change Suspect Mode to Normal Mode in SQL Server Database
If you are reading this, you are desperately looking for solutions to change suspect mode to normal mode. It also...
2019-01-07
194 reads
Profiler Is Dead, Long Live Extended Events
OK, so profiler isn’t actually dead, it has however been deprecated since 2012 and has had no new features since...
2019-01-07
246 reads
Creating my own Map Shapefiles for Power BI
(2019-Jan-06) In the past, I used to always rely on shapefiles crafted by others to create my map visualizations in...
2019-01-15 (first published: 2019-01-06)
6,436 reads
When does it make sense to hire a data science consulting company?
Going into 2019, data science and machine learning is all the hype. Organizations in every industry are starting to realize...
2019-01-06
27 reads
Blogs
New Pluralsight Course – Securing Azure Kubernetes Service (AKS) Clusters
My new course “Securing Azure Kubernetes Service (AKS) Clusters”, co-authored with my good friend...
Join Denny Cherry and Associates at SQL Bits 2023
I am very excited and lucky to be speaking once again at SQLBits along...
Daily Coping 27 Jan 2023
By Steve Jones
Today’s coping tip is to try something new to get out of your comfort...
Forums
Case statement with time
Hello everyone I hope everyone's ok. I have this query and I'm trying to...
what are the best books to become a SQL developer?
what are the best books to become a SQL developer?
what are the best books to become a DBA SQL?
what are the best books to become a DBA SQL?
Ask SSC