A Look at SQL Server CE
An introductory article from Microsoft on the newest version of SQL Server: SQL Server CE designed for Windows CE devices. Includes some ideas for where this version fits in your architecture.
2001-05-30
1,721 reads
Articles
ANSI Joins
Are you confused by all this inner join style syntax that is becoming more and more prominent lately? This article by Neil Boyle will help you find your footing in the ANSI join syntax.
2001-05-29
10,246 reads
SQL Server 7.0 and 2000 Clustering Resources
A good place to start before clustering. Written by Brad McGhee, the founder of sql-server-performance.com.
2001-05-29
1,816 reads
Your Friend the Computer
You know it is time to reassess your relationship with
your computer when....
2001-05-28
1,593 reads
Removing NT Administrators as Sysadmins
By default, all NT administrators of the domain that your SQL Server is installed in, have SA rights in every database. This presents interesting challenge for DBAs, political and technical. Does your NT administrator group need SA rights to every database? The answer is no.
2001-05-25
4,054 reads
2001-05-25
3,985 reads
Quickly Enabling and Disabling Constraints and Triggers
In some cases, you may have to be able to quickly disable all the constraints and triggers in a database. This article shows you how to do this with a few lines of T-SQL.
2001-05-24
9,923 reads
Simplifying Instead Of Triggers
Instead of triggers are a new feature in SQL Server 2000 which greatly extend the functionality of triggers. This article covers a basic introduction to Instead of Triggers and illustrates possibilities for their use.
2001-05-24
8,842 reads
2001-05-23
2,172 reads
Using FileSystemObject with DTS
This article will show you how to use the FileSystemObject to determine the existence of a file inside DTS.
2001-05-23
8,325 reads
Blogs
What I actually do at Microsoft
I started working at Microsoft in January 2022. I enjoy it. I even wrote...
Talkie - a simple, private, responsive interface for LLMs
By Bert Wagner
Watch this video on YouTube I like using ChatGPT. But I don't like the $20/month...
System Views in Microsoft Fabric – Query references an object that is not supported in distributed processing mode
I have a metadata-driven ELT framework that heavily relies on dynamic SQL to generate...
Forums
Using USE does not set DB context
Hi Experts, I have a Sql file with a bunch of DDL statements (Create...
deploying datafactory using YAML script - Error
Hi All, First foray into deploying adf using YAML scripting from Azure Devops from...
blocking due to cuncurrency problem.
hi, CREATE TABLE [dbo].[bridge]( bridgeid [bigint] NOT NULL, [idpool] bigint NULL, status int null...
Question of the Day
Is date zero valid and if so what day is it?
You run this code in SQL Server
select datename(weekday, 0);What is the result? See possible answers