TSQL Spam-killer
In which Phil takes a break from a tedious bit of routine coding to build a Spam Filter in SQL.
2008-04-25
2,452 reads
Additional Articles
Retrieve XML data values with XQuery in SQL Server 2005
Use XQuery scripting language to retrieve specific XML data type values in SQL Server. Learn to script and use Value() and Query() to retrieve single and multiple XML values.
2008-04-24
4,234 reads
UPSERT Functionality in SQL Server 2008
This article illustrates the functionality of UPSERT via the MERGE command in SQL Server 2008.
2008-04-24
6,046 reads
Reading the SQL Server log files using T-SQL
One of the issues I have is that the SQL Server Error Log is quite large and it is not always easy to view the contents with the Log File Viewer. In a previous tip "Simple way to find errors in SQL Server error log" you discussed a method of searching the error log using VBScript. Are there any other easy ways to search and find errors in the error log files?
2008-04-23
4,240 reads
Same Report but Different Methods in SQL Server Reporting Services
In Reporting Services in SQL Server 2005 there are several ways of achieving the same result. This article introduces how we can create the same report using several different methods.
2008-04-23
3,128 reads
SQL Server 2005 log shipping setup using the wizard
Along with some best practices, SQL Server MVP Hilary Cotter shares a log shipping setup process from start to finish.
2008-04-22
2,862 reads
SQL String User Function Workbench: part 1
Robyn and Phil go back to basics and hammer out some basic String-handling User Functions in TSQL, based on Python examples. Plenty of sample code, and TSQL programming tricks.
2008-04-22
4,839 reads
2008-04-22 (first published: 2008-02-22)
3,212 reads
Identify SQL Server 2005 Standard Login Settings
Gaining insight into my SQL Server standard and Windows logins has historically been a challenge in terms of determining password changes, failed login attempts, etc. I have noticed that you have experienced the same issue with your tip entitled 'When was the last time the SQL Server sa password changed' and I have noticed some information in the forums on the topic as well.
2008-04-21
3,407 reads
SQL Server 2005 Express Edition - Part 20 - Authenticating Merge Web Synchronization
We have been discussing SQL Server 2005 Express Edition replication-specific features, investigating authentication mechanisms that are available in order to accommodate connection attempts from remote clients interacting with SQL Server-based distributor via Internet Information Services. We will continue coverage of this topic here.
2008-04-21
1,679 reads
Blogs
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Forums
Windows logins for users migrated from DomainA to DomainB
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers