Business Analysis: A Guide to Better Business Requirements
This article presents ten business analysis guidelines, representing best practices from successful projects.
2007-12-03
3,044 reads
Articles
SQL Server 2005 Bug Alert: Merge Replication Could Mean Data Loss
The SQL Server 2005 merge replication engine introduced breaking changes that can cause data loss for both MSDE and SQL Server Express subscribers. Find out how this bug manifests itself in a real-world scenario.
2007-12-03
2,048 reads
SQLonCall: Mock Interview, Part I
The first part of a great video series from Chris Shaw of SQL Oncall that walks you through a mock interview and gives advice on how you can present yourself in the best light.
2007-12-03
2,081 reads
Source Control in SQL Server
One of the most requested features from SQL Server developers is the integration of source control with T-SQL code. SQL Server Management Studio brings some integration with Visual Source Safe and longtime SQL Server author Raj Vasant explains it to us.
2007-11-30 (first published: 2006-12-04)
14,226 reads
Accessing and Updating Data in ASP.NET 2.0: Handling Database NULL Values
Dealing with NULL database values in ASP.NET.
2007-11-30
2,302 reads
Custom check-in policies with VSTS
In this column, I'll dig into check-in notes and policies. You'll learn how check-in notes work and how to write your own custom policy implementations.
2007-11-30
1,335 reads
Under the Hood: How Dependency Probability is Computed by Naïve Bayes
This tip provides insight into the inner workings of the Microsoft Naive Bayes algorithm, showing how the algorithm computes the score used to filter out correlations.
2007-11-30
1,620 reads
Developers and DBAs
The battle between developers and DBAs can be a rough one at times. However DBAs are often outnumbered by developers and need to be sure they fit in. DBA Janet Wong brings us one of her experiences about how you can better go with the flow.
2007-11-29 (first published: 2006-12-05)
8,936 reads
The DBA Routine
What's the routine of a normal DBA job? Too many people work alone and don't get feedback or comments on what they should be doing from other DBAs. Andy Warren has jotted some notes down on what you should make sure is a part of your job.
2007-11-29
12,482 reads
Microsoft Windows PowerShell and SQL Server 2005 WMI Providers – Part 1
Learn how to perform administrative tasks by accessing the SQL Server 2005 WMI Providers using Window PowerShell.
2007-11-29
2,575 reads
Blogs
Using AI for Git Hooks
By Steve Jones
Recently I had someone internally ask about whether SQL Source Control supports Git Hooks....
Flyway Tips: AI Helps with Commit Messages
By Steve Jones
At Redgate, we’re experimenting with how AI can help developers and DBAs become better...
Startup scripts in SQL Server containers
I was messing around performing investigative work on a pod running SQL Server 2025...
Forums
SQL Agent job running gMSA cannot backup to NAS target
I'm running a group MSA for the database engine and SQL Agent in a...
sys.query_store_query question
All, My query is as follows: SET DATEFORMAT dmy SELECT p.query_id, DATEADD(MICROSECOND,-rs.max_duration,rs.first_execution_time) AS starttime,...
Encoding Strings
Comments posted to this topic are about the item Encoding Strings
Question of the Day
Encoding Strings
I have this code in SQL Server 2025. What is the result?
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(@message); SELECT @encoded AS EncodedResult;See possible answers