Few days ago I received a request to restore a dozen of tables because someone have deleted more data than it was supposed. I immediately thought about dbatools for...
2019-06-04 (first published: 2019-05-17)
1,212 reads
Probably you had the need to script out some objects from a SQL Server instance/database and this is quite easy. You just need to right click on the object...
2019-05-29 (first published: 2019-05-15)
1,869 reads
Few days ago a client requested the configuration of MSDTC (Microsoft Distributed Transaction Coordinator). NOTE: If you want to know more about it here is a nice FAQ from...
2019-05-21 (first published: 2019-05-10)
4,893 reads
Few days ago I received a request to restore a dozen of tables because someone have deleted more data than it was supposed. I immediately thought about dbatools for...
2019-05-17
One of the good things, when we have new clients, is that sometimes they have needs that you never heard before. This does not necessarily mean that they are...
2019-04-11 (first published: 2019-03-29)
1,125 reads
This post is to answer the question: “You are used to seeing in the format of yyyy-MM-dd right?” that I...
2018-09-12
412 reads
This month’s T-SQL Tuesday is brought by Steve Jones (b | t) and he wants to know if triggers causes headaches or happiness to us.
This is the 106nd edition...
2018-09-11
This month’s T-SQL Tuesday is brought by Steve Jones (b | t) and he wants to know if triggers causes headaches...
2018-09-11
234 reads
On 29th September we will have SQL Saturday Porto and I’m proud to announce that I will be speaking!
I will...
2018-09-05
255 reads
On 29th September we will have SQL Saturday Porto and I’m proud to announce that I will be speaking!
I will be speaking about dbachecks PowerShell module - dbachecks -...
2018-09-05
1 reads
I spend my days working on and managing SQL Server instances—working days at least,...
Want to learn SQL and get some real practice this December? Check out the...
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
Hello All, I am using TRY_CONVERT to parse character data into a decimal column....
Hi I am trying to assign the value of the variable using the output...
Comments posted to this topic are about the item Merry Christmas 2025
How many reindeer does Santa have pulling his sleigh? (according to the famous song) Hint, the answers are not base 10.
See possible answers