Sneak Preview: Start to Finish Guide to SQL Server Performance Monitor
Get a sneak peak of some of the sections from Start to Finish Guide to SQL Server Performance Monitor. Find out what counters to watch and what their thresholds are.
How to troubleshoot orphan users in SQL Server databases?
This article explains how orphan users get created, and provides you with troubleshooting information. A bonus stored procedure called ShowOrphanUsers is included, that goes and searches all the databases and generates a complete list of orphan users.
Generating HTML Tables
In this article Andy looks at one way you can separate your presentation code from your data when you generate HTML tables for simple reports. Lots of code examples so you can see how it works.
Working with email addresses in SQL Server!
This article shows you how to design the storage for email addresses, how to validate email addresses, how to retrieve demographic information from email addresses efficiently, using computed columns and indexes. It also covers the security aspect of dealing with email addresses.
Review: Microsoft Baseline Security Analyzer
A look at a new security tool from Microsoft for analyzing your SQL (and other) servers.
Free SQL Server 2000 Certifications
Certy.com has just released SQL Server 2000 certifications. These certifications are 100% free and a must for any DB developer & DBA.
Relational Database Without Relations
The strength and holy grail of relational databases lies in the very name: relations. Microsoft has put a good deal of intelligence and cunning into query optimizations, caching, indexing and execution plans to make the process of finding related records even smoother and faster. This small article, however, will try to shatter the very sacred notion of relational databases.
Unauthenticated System Compromise of SQL Server 2000
Microsoft has released a patch to fix two buffer overflow vulnerabilities in SQL Server 2000. No UserID or password is required by the attacker to exploit these issues. The problem is exacerbated by the fact the attack goes over UDP.
Understanding Execution Plans Part 1
The purpose of this article is to give you a working knowledge of how to view and understand query execution plans for SQL Server. This is part 1 in a series of articles that will walk you through understanding execution plans to help you improve your queries.
SQLClean 2.0 Released
SQLClean is a SQL Tool that automatically creates a dependancy analysis of your SQL Server Database including tables, views, triggers, defaults, procedures etc. SQLClean will also analyze a client application for depenandies on SQL Objects allowing you to detect and eliminate unused SQL objects that are unreferenced by either the client app. or database itself.
Blogs
A New Word: Incidental Contact High
By Steve Jones
incidental contact high – n. an innocuous touch by someone just doing their job...
Azure PostgreSQL Flexible Server and Entra Groups
My company is moving from an Azure PostgreSQL single server to a flexible server....
Take the 2025 State of Database Landscape Survey
By Steve Jones
The survey is out now and you can share your experiences for a chance...
Forums
GIT Configuration and Automated Release for Azure Data Factory
Comments posted to this topic are about the item GIT Configuration and Automated Release...
How to Add a New Shared Disk to a WSFC as a SQL Resource
Comments posted to this topic are about the item How to Add a New...
Knowing What You Don't Know
Comments posted to this topic are about the item Knowing What You Don't Know
Question of the Day
Am I on Synapse?
How can I tell from T-SQL if I'm connected to SQL Server or Synapse Analyics?
See possible answers