Not many data professionals get a personal Learning and Development (L&D) budget that we can use at our discretion. This is something I encourage you to negotiate when you are considering a job or at your annual review. We all need to learn and a budget signifies your boss cares about you.
2024-08-23
In this article, we examine the effect of local variables on T-SQL queries and how these could potentially cause performance issues.
2024-08-23
In this next installment, John performs the research you might do if your management asked you to examine Fabric.
2024-08-21
3,314 reads
This section gets into detailed SQL Server configuration details. This is less relevant in a cloud environment, but there are still items to confirm.
2024-08-21
Lean how to implement linear regression in SQL Server by running Python code on your data in SQL Server using Machine Learning Services.
2024-08-19
3,244 reads
This article explores how enabling READ_COMMITTED_SNAPSHOT on your SQL Server database might ease excessive blocking.
2024-08-19
Learn how you can recover a database that is in suspect mode.
2024-08-16
5,182 reads
What are the challenges to implementing a successful test data management strategy? In our recent webinar ‘Harnessing the Power of Test Data Management: Strategies for Success’, Redgate’s Steve Jones was joined by Hamish Watson (DevOps Consultant) and Daniel Watkins (Director/Principal Consultant) to talk all things TDM and how to implement it efficiently and effectively. Here are 10 key tips and takeaways from their conversation in a short blog post.
2024-08-16
I’m not the first person to write about cleaning up unused or redundant indexes.
2024-08-16
To help mark Redgate’s 25th Birthday, the company has launched a new initiative to foster knowledge and skills in the data industry.
2024-08-14
One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved...
By Kevin3NF
Flexibility and Scale at the Database Level When SQL Server 2012 introduced Availability Groups...
Setting page visibility and the active page are often overlooked last steps when publishing...
i have subscription of github copilot which i can access in vs 2022 comunity...
Comments posted to this topic are about the item Password Guidance
Comments posted to this topic are about the item 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