SQL Saturday #731 Athens 2018
This will be my first SQL Saturday ever both as speaker and attendee outside Portugal so I’m especially thrilled and excited to be part of it!
I will be presenting...
2018-06-04
Cláudio Silva
- Website: https://claudioessilva.eu
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,901 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 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
354 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,967 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
54 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
481 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
6 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,654 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
500 reads
Blogs
A New Word: Foilsick
By Steve Jones
foilsick – adj. feeling ashamed after revealing a little too much of yourself to...
Accelerated Database Recovery for tempdb in SQL Server 2025
Accelerated database recovery was introduced in SQL Server 2019 and provides fast recovery, instantaneous...
Measuring What Matters: Operationalizing Data Trust for CDOs
By Chris Yates
Trust is the currency of the data economy. Without it, even the most advanced...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
count the number of NULLs in a row
Hi everyone I have a SP that finds the average based on 3 tables. ...
Deleting data in large table
I have a large table with 17M+ rows for our package record audits. I've...