Adding a column to the primary key.
Every now and again you realize that the primary key for a table does not uniquely describe a row. Not...
2014-11-13
1,118 reads
Every now and again you realize that the primary key for a table does not uniquely describe a row. Not...
2014-11-13
1,118 reads
SQL Server Database Mirroring is fantastic HA solution developed by Microsoft. Microsoft lunch database mirroring with SQL Server 2005. Database...
2014-11-13
1,532 reads
Calculated measures are visually identifiable
If you have access to a cube, it’s quite easy to find all the calculated measures.
The...
2014-11-13
1,488 reads
By Steve Bolton
…………There are apparently many subtle variations on Z-Scores, a ubiquitous measure that is practically a cornerstone in the...
2014-11-13
2,599 reads
This post is mainly to test the syndication still works correctly from my heavily updated web/blog site so apologies for...
2014-11-12
159 reads
This post is mainly to test the syndication still works correctly from my heavily updated web/blog site so apologies for...
2014-11-12
429 reads
I recently blogged about how good I thought Trello was and shortly afterwards I found out that they did provide...
2014-11-12
325 reads
It has been a pretty long time since my last blog post but with good reason!
The last month and a...
2014-11-12
454 reads
This blog post digs into the details of shaping the data with Power Query and Power Pivot in order to...
2014-11-19 (first published: 2014-11-12)
8,127 reads
There are lots of little tricks that you can use to become more proficient, and efficient, at writing T-SQL. Here’s...
2014-11-12
1,059 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