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
8 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,474 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
416 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
277 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
385 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
500 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,753 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,352 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
114 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
411 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers