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...
2018-05-10 (first published: 2018-05-02)
2,898 reads
Cláudio Silva
- Website: https://claudioessilva.eu
Learn, Evolve and Giving Back - TSQL Tuesday #102
This month’s T-SQL Tuesday is brought to us by Riley Major (b | t) and he encourage us to talk about how we are helping by giving back to...
2018-05-08
1 reads
Learn, Evolve and Giving Back – TSQL Tuesday #102
This month’s T-SQL Tuesday is brought to us by Riley Major? (b | t) and he encourage us to talk about...
2018-05-08
352 reads
dbachecks – Setting temporary configuration values
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,962 reads
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
29 reads
dbachecks – Going parallel – Cut off your execution times
On one of the last clients I have worked, I have implemented dbachecks in order to get the state of...
2018-04-26
477 reads
Is this command broken? I can't see some properties! - DefaultDisplayPropertySet, Get-Member and Select-Object *
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
4 reads
Did you know…you can’t do arithmetic operations with datetime2 like with datetime?
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,652 reads
dbachecks – A different approach for an in-progress and incremental validation
dbachecks is a new PowerShell module from the SQL Server Community! For more information, read introducing dbachecks. If you don't...
2018-02-22
494 reads
dbachecks – Using Power BI dashboards to analyse results
For the last couple of months, members of the dbatools team have been working on a new PowerShell module called...
2018-02-22
851 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Compare rows within the same table
I have a table. Structure in script below. I have to compare and see...
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers