Profiler - Logging Results to a Table
SQL Profiler lets you log the results of a trace directly to a table, yet would you believe you can't save the trace as a script to do the exact same thing? Find out why and get some ideas on work arounds.
50 Ways to Confuse, Worry, or just Scare People in a computer lab.
Things your non-technical friends don't want to hear in the lab...
Analyzing Requirements and Defining Solution Architectures
Andy says it's not the greatest book for preparing for the 70-100 exam, but the case study is worth reading for it's explanation of the Microsoft Solution Framework. Read the full review!
SQLXML 3.0 Beta
SQLXML 3.0 beta adds new functionality to SQL Server 2000, giving developers the capability to expose stored procedures and XML templates as Web Services. It also includes all the features of SQLXML 1.0 and 2.0.
Fixing Your Identity
If you use identity values, chances are that at some point you will need to find more information about the next value or reset the seed. This article looks at how you can accomplish this.
nternet Data Center 1.5 - Reference Architecture Guide
This document (divided in chapters for your convenience) describes how to design a secure, scalable, highly available, and manageable Internet data center that is based on Microsoft products. This documentation examines the major challenges to consider when designing an Internet data center architecture and how this design addresses these challenges.
Support WebCast: Microsoft SQL Server: Rapid Blocker Script Analysis
This webcast is scheduled for Tuesday, January 15, 2002 at 10:00 AM Pacific time.During this session, we will show a practical approach to analyze performance tuning problems that involve Microsoft SQL Server lock monitoring data. We will briefly discuss sp_who2, sysprocesses, and syslocks.
70-100 MCSD Architectures Exam Cram
Should you use this book to prepare for the 70-100 exam? Read the review and find out!
Enforcing Security in Multi-Tier Applications
The major part of the article, however, is dedicated to a topic that often confuses people and leads to some of the strongest disagreements among IT professionals and developers: the benefits and drawbacks of enforcing security in the middle (or business) tier versus the data tier.
Security Alert : SQL Server Security Bug and Patch
Happy Holidays database administrators! As a parting present before you go home for your year-end break, Microsoft has announced a security problem in SQL Server 7.0 and 2000.
Blogs
AI Step 1
By Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
Beginner’s Guide: Building a Dockerized Todo App with React, Chakra UI, and Rust for Backend
In a containerized app, React and Chakra UI provide a robust and accessible user...
A New Word: Nachlophobia
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
Forums
Cannot install development version.
A while into install I get a Microsoft OLE DB Driver for SQL Server....
More Funny SELECTs
Comments posted to this topic are about the item More Funny SELECTs
Reducing the Cycle Time
Comments posted to this topic are about the item Reducing the Cycle Time
Question of the Day
More Funny SELECTs
What does this code return?
SELECT
( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder
FROM Sales.SalesOrderHeader AS soh
WHERE
soh.OrderDate > '01/01/2011'
AND soh.OrderDate < '01/01/2012') AS OrdersIn2000
, ( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder
FROM Sales.SalesOrderHeader AS soh
WHERE
soh.OrderDate > '01/01/2012'
AND soh.OrderDate < '01/01/2013') AS OrdersIn2001
, ( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder
FROM Sales.SalesOrderHeader AS soh
WHERE
soh.OrderDate > '01/01/2013'
AND soh.OrderDate < '01/01/2014') AS OrdersIn2002;
GO See possible answers