Using CAST() function with User-Defined Data Types...Did you know...
I’m converting some Firebird database code to T-SQL and I’m seeing a lot of code that doesn’t work in the same way that SQL Server. No surprise - I...
2018-05-02
16 reads
I’m converting some Firebird database code to T-SQL and I’m seeing a lot of code that doesn’t work in the same way that SQL Server. No surprise - I...
2018-05-02
16 reads
On one of the last clients I have worked, I have implemented dbachecks in order to get the state of...
2018-04-26
471 reads
dbachecks has seen the light about two months ago. As I'm writing this blog post, the module counts with more...
2018-05-03 (first published: 2018-04-24)
1,957 reads
Every now and again I see some people complaining about not getting the properties they want when using a PowerShell command.
For instance, someone was using the Get-Service command to...
2018-04-23
1 reads
I’m currently working on a SQL code migration from Firebird to SQL Server and I hit an error that I...
2018-04-11 (first published: 2018-04-06)
2,649 reads
dbachecks is a new PowerShell module from the SQL Server Community! For more information, read introducing dbachecks. If you don't...
2018-02-22
491 reads
For the last couple of months, members of the dbatools team have been working on a new PowerShell module called...
2018-02-22
849 reads
In two weeks from now, on 23rd of February, I will be speaking at SQLBits 2018! It’s my first time on the largest SQL Server conference in Europe for...
2018-02-09
1 reads
One of the main DBA's duties is to guarantee that SQL Server instances are up-to-date in terms of patches (Service...
2018-01-23
712 reads
Last night, I received Adam Machanic's (b | t) newsletter "Announcing sp_whoisactive v11.20: Live Query Plans". For those who don't know...
2017-12-15 (first published: 2017-12-05)
2,477 reads
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
Comments posted to this topic are about the item The Marked Transaction
Comments posted to this topic are about the item What happens when we drop...
I have a column that contains comma separated values. I'm trying to figure out...
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers