Modern businesses are data-driven. Many business leaders will tell you it is the “lifeblood” of their company. Good data helps us provide outstanding service to our customers, identify potential...
2018-11-07
5 reads
How often have you felt like you need an extra pair of hands? When you’re planning a party? Maybe. When...
2018-11-01 (first published: 2018-10-24)
2,471 reads
“We don’t want to know that it’s broken, just that it’s working.” “We want our database to always be available.”...
2018-10-08
413 reads
SQL Treeo’s founder and CEO, Danny Riebeek, reflects on his 20+ years in the IT industry. Q: What prompted you...
2018-09-19
275 reads
Situation SQL Server registers every missing index. Here is how you retrieve that information from the missing index DMV’s [crayon-5c335dbc1c266788449988/]...
2018-07-07
382 reads
Situation Good index management is key to success. Having too many unused indexes around slows down your system. It is not...
2018-07-07
496 reads
You have an Office 365 mailbox. You want to use C# to read those mails and save them to SQLServer.
The...
2018-05-20
1,735 reads
Extracting pieces of information from a string can be a daunting task. This is an example of a REVERSE technique.
The...
2018-05-19
1,350 reads
Extracting pieces of information from a string can be a daunting task. This is an example of a REVERSE technique.
The...
2018-05-19
112 reads
Enable dark-theme for SSMS Purpose Guide to enable dark-theme in SQL Server Management Studio(SSMS). Reading time +/- 10 minutes References www.sqlserver.info...
2018-03-14
338 reads
By Steve Jones
ghough – n. a hollow place in your psyche that can never be filled;...
I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...
Widgets provide a way to parameterize notebooks in Databricks. If you need to call...
When ASCII(Column) is null, what does it represent? Is this some kind of special/control...
Hello, I created the below script to output 999 rows from SQL Server table...
I have a database on SQL 2019 in an Availability Group (AG) and I...
Ask SSC