Working with Very Large Tables
Recently I presented an online session with the title “Working with Very Large Tables Like a Pro in SQL Server 2016”....
2017-08-14 (first published: 2017-07-26)
4,748 reads
Blog Posts
PSDay.UK Tickets are on sale
Following a lot of hard work by the organising folks Gael Colas, Ebru Cucen, Daniel Krebs and Johnathan Medd, we...
2017-08-13
354 reads
Building Your Brand and Becoming a Thought Leader Session Materials
Thank you to everyone that attending my session today at SQL Saturday #649 in Jacksonville, Florida! It was a packed...
2017-08-12
590 reads
DevOps Basics–Git log
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-08-11 (first published: 2017-07-19)
1,809 reads
Just Say No to Social Engineering Memes
These memes, from a security and privacy perspective, are nothing but trouble. Here’s an example I just saw a friend...
2017-08-11
1,449 reads
Microsoft Azure – How to create a virtual machine (VM) with Reserved Public IP (VIP)
In my previous blog, we learnt that a Virtual IP (VIP) get lost or changed when we stop or deallocate...
2017-08-11
691 reads
Performance is bad. Did you change anything recently? No. Are you sure?
Ever have this conversation?
Dev: Hey, can you help me? The performance on my application is terrible all of a sudden.
DBA:...
2017-08-11 (first published: 2017-07-26)
3,207 reads
SQL Server vs Oracle: Convert string to date
Over this week we’ve looked at the difference between Oracle and SQL Server from a few different angles. We’ve looked...
2017-08-11
1,301 reads
SQLskills is Giving Away Free Training!
SQLskills is giving away free training for their performance tuning and optimization classes. My entry for the competition is below. If you decide to enter for yourself, entries are...
2017-08-11
15 reads
Training and tips to get certified with Microsoft (Part 3)
Welcome back, thanks for keep on reading me, and for the ones who read for the first time, welcome.With this third post I'll keep answering the question Where did...
2017-08-11
7 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Forums
It's Never Just One Thing
Comments posted to this topic are about the item It's Never Just One Thing
Calculating Min-Max Normalization in PowerBI
Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI
Checking the Error Log III
Comments posted to this topic are about the item Checking the Error Log III
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers