Organisations and Technical Apartheid
Today we have a guest editorial that looks at DevOps and the need for your culture to promote collaboration.
Tips for Better Presentations
Brent Ozar gives some advice to those of you who give presentations to user groups and conferences.
The Road to Better Data Handling
As data becomes more valuable and regulations require safer processing, it is important we become more careful in our daily work.
What’s the Difference Between PERCENT_RANK and CUME_DIST?
Learn a bit about the different results you get from the PERCENT_RANK and CUME_DIST aggregate functions.
How can we close the tech skills gap?
One of the most profound challenges faced by technology companies today is talent. According to the latest Harvey Nash survey, 65% of CIOs believe that a shortage of tech skills is affecting their ability to respond to change.
Improving Tech with Compassionate Code
There is quite a bit of suffering within tech and caused by tech, from poorly commented code to shaming someone who asks a question on a forum. In this article, Samuel Nitsche explains why compassionate coding is a better way to go.
Collect SQL Server Index Usage Information for all Instances with PowerShell
In this tip we look at a PowerShell script you can use to collect index information for all of your SQL Server instances that you manage.
Data breach notifications don’t need to be scary
Ever since the GDPR was introduced, the subject of data breach notifications has worried a lot of people. How do you write one? What do you need to include? What will the ramifications be? Will it make your customers run for the hills? Will it get you fired?
All flash vs adaptive flash storage - which is right for my organisation?
Many data professionals might not worry about hardware, but someone needs to watch for changes and improvements in technology. Learn about how flash storage technology has changed and how this might be useful if you still need to build a fast database server.
Blogs
Modify Power BI page visibility and active status with Semantic Link Labs
Setting page visibility and the active page are often overlooked last steps when publishing...
T-SQL Tuesday #190–Mastering a New Technical Skill
By Steve Jones
It’s time for T-SQL Tuesday again and this time Todd Kleinhans has a great...
Getting Started with the MSSQL AI Agent in VS Code
By Steve Jones
Recently I was working in VS Code and I saw a walkthrough for the...
Forums
Password Guidance
Comments posted to this topic are about the item Password Guidance
Using table variables in T-SQL
Comments posted to this topic are about the item Using table variables in T-SQL
Azure elastic query credential question
I am trying to check out elastic query between two test instances we have...
Question of the Day
Using table variables in T-SQL
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers