Who did what to my database and when…
One of the most popular questions on forums / SO etc is, “How can i find out who dropped a table,...
2016-08-30 (first published: 2016-08-22)
2,809 reads
One of the most popular questions on forums / SO etc is, “How can i find out who dropped a table,...
2016-08-30 (first published: 2016-08-22)
2,809 reads
If there is one process that should be simpler than it is out of the box, it is creating Excel...
2016-06-17
1,413 reads
Im not a big clustering/HA expert, but I obviously understand the need for such things to exist
However, the standard...
2016-03-24
1,070 reads
I haven’t gotten to involved in the whole “Big Data” movement to much, I’ve kept an arms length watch and...
2016-03-23 (first published: 2016-03-20)
1,836 reads
I’ve been developing T-SQL for about 20 years now and almost since day one there has been functionality that , IMO,...
2016-03-13
583 reads
Sometimes it does feel that a problem is a database problem until proven otherwise. When this does occur I have...
2016-03-03 (first published: 2016-02-28)
2,801 reads
Hi
Unfortunately due to matters outside of my control, SQL Saturday 502 in Edinburgh has been cancelled, I would like...
2016-02-14
478 reads
I’m happy, honoured and humbled to be able to say that I will be presenting pre-cons and both SQL Saturday...
2016-01-17
380 reads
Over the past few years one of the big drives and innovations in the SQL Server world, has been to bring...
2016-01-05
414 reads
Im not doing a tremendous amount of public speaking this year and concentrating on more professional matters, however im pleased...
2015-10-04
442 reads
In this post we're going to go through the steps to set up Always...
I’ve been using Azure SQL Database for quite some while and have set up...
From June 1, 2023, Microsoft Fabric (preview) capacities are available via the Azure portal....
In SQL Server database, there is a table InventDim with two indexes: Idx1 with...
In SQL Server database, there is a table InventDim with two indexes: Idx1 with...
The table InventDim has some indexes, we create one index idx1 which has index...