Back to basics: What is a HEAP table?
Understanding the fundamentals is key for success, with everything you do. These days SQL Server has expanded into much more...
2018-05-24 (first published: 2018-05-16)
5,652 reads
Confessions of a Microsoft Addict
I’m speaking: SQL Saturday Los Angeles 06-09-18
Hello California! I’m headed your way and will be speaking at SQL Saturday #773. The full schedule is live and...
2018-05-14
234 reads
Monday morning comic 2018-05-18
Here’s the first issue of a new Monday morning comic series. Hopefully some of you all get a giggle.
2018-05-14
336 reads
SQL Ops Studio extension development : Starting an adventure
I’ve been in technology a long, long time (more than 2 decades). Over the years, I learned Access which took...
2018-04-26
1,186 reads
SQL Tuning: Finding statements for missing indexes
Missing indexes are an important part of the indexing strategy. I usually start with sys.dm_db_index_usage_stats to find both inefficient and...
2018-04-20
600 reads
Query tuning: Apply yourself
It’s Friday and I’m ready for the weekend as I’m sure everyone else is. This weekend I’m looking forward to...
2018-04-16 (first published: 2018-04-06)
3,410 reads
SSMS now has a vulnerability report
Security is an important and often overlooked function of technology. Don’t believe me? Go to a SQL conference and look...
2018-03-29
425 reads
The best overlooked addition to SQL 2016
Many of the widely advertised and talked about features of SQL Server or other software products focus exclusively on the...
2018-03-07
365 reads
Classifying your data in Azure SQL DB for GDPR
Azure SQL DB is a robust data platform that’s cloud native and can be managed from SQL Server Management Studio...
2018-03-06
422 reads
How to classify your data for GDPR
The right to be forgotten. It’s a concept that sounds great for people who are concerned about their personal information...
2018-03-05
494 reads
Blogs
From Data Custodian to Innovation Catalyst: The Evolving Role of the CDO
By Chris Yates
There was a time when the Chief Data Officer lived in the shadows of...
Down the Rabbit Hole: Dealing with Ad-Hoc Data Requests
By Rayis Imayev
"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...
Adding a Local Model to Ollama through the GUI
By Steve Jones
I saw some good reviews of the small gemma3 model in a few places...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
SQL Server Advanced Troubleshooting and Performance Tuning: Best Practices and Techniques
Comments posted to this topic are about the item SQL Server Advanced Troubleshooting and...
T-SQL Fundamentals
Comments posted to this topic are about the item T-SQL Fundamentals