What are Statistics in SQL Server?
Statistics are vitally important in allowing SQL Server to find the most efficient way to execute your queries. In this post we learn more about them, what they are...
2023-06-21
359 reads
Statistics are vitally important in allowing SQL Server to find the most efficient way to execute your queries. In this post we learn more about them, what they are...
2023-06-21
359 reads
Always Encrypted was a new encryption feature added to SQL Server with the 2016 version of the product. Initially it was just available in enterprise edition, but from SQL...
2023-06-21 (first published: 2023-06-05)
395 reads
In this short post we look at the ability to be able to have (or not) indexes on columns encrypted using Always Encrypted.
2023-06-20
173 reads
There are countless queries you can find on internet to get list of tables, size of database, tables, indexes etc... Here is a one that I have used for...
2023-06-20
462 reads
This month’s T-SQL Tuesday is hosted by Gethyn Ellis(t). Gethyn’s Invite to us is to write about the best piece of career advice you’ve received. One of the most...
2023-06-20
62 reads
Say, you have a query having performance issues and you decide to look it's graphical execution plan in SSMS (or other tools). If you are lucky, right off the...
2023-06-20 (first published: 2023-06-19)
207 reads
A customer asked about how they could organize their migration scripts in different ways to manage them and worried about it being complex. I decided to test a few...
2023-06-19 (first published: 2023-05-31)
170 reads
Let’s set the scene. You’ve built a wonderful, useful, and descriptive report for your stakeholders with a variety of tooltips that offer deeper insights. They love the tooltips, and...
2023-06-19 (first published: 2023-06-05)
288 reads
Hello Dear Reader! This past week was a busy one. As we've started to settle into the new house we are transitioning from eating out or having meals delivered,...
2023-06-19
78 reads
If you under promise and overdeliver then you will always have happy clients.
2023-06-19
53 reads
By Steve Jones
I wrote about Flyway Desktop Object History in a previous tip. This feature has...
By Arun Sirpal
AgentDBA (the database agent I have been building) has more than 1000 automated tests,...
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers