Microsoft Announces a New Security Program
Microsoft has announced a new security program to help system administrators secure their sites. Worth a read.
2001-10-19
4,120 reads
Articles
Understanding the Implications of ANSI SQL92 SET Options
Have you ever experienced a T-SQL query, a stored procedure, view or a trigger returning unexpected results. In this article by Raj Gill, he shows you how ANSI DEFAULTS may be to blame.
2001-10-18
10,904 reads
New Certification - MS System Administrator
Microsoft has announced a new certification for system administrators. This is below an MCSE, but includes an elective which may be SQL Server.
2001-10-18
1,223 reads
A Few Meta Data UDFs
Alexander Chigrik presents a few UDFs he has developed for getting meta data about your database objects.
2001-10-17
4,138 reads
Executing a script from SQL Server
Running a script automatically from SQL Server is easier than you think. Here are a few methods you can use.
2001-10-17
17,693 reads
2001-10-15
4,000 reads
2001-10-15
1,880 reads
2001-10-12
3,627 reads
Common SQL Server and Windows Clustering Questions and Problems
This article covers some of the common issues and questions when you cluster SQL Server 2000 and Windows 2000.
2001-10-11
13,694 reads
Review: Total SQL Analyzer
Total SQL Analyzer is a new product that can help document your SQL Server. This review examines the product and some of it's features.
2001-10-10
8,233 reads
Blogs
T-SQLTuesday 204: Are blogs still relevant?
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
Enforcing Unique Customer Emails When Duplicates Already Exist
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
Question of the Day
Switching Schemas I
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers