Automatically Gathering Server Information Part 7
The seventh part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-27
4,908 reads
Articles
Invisible Comments
I ran into a dilemma when I was told that I should not allow potential competitors to view my JavaScript comments. If they want to figure the code out; make them work for it.
2001-04-26
3,540 reads
Automatically Gathering Server Information Part 6
The sixth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-25
5,624 reads
Computer Problem Report Form
This humorous form was originally desgined for Network Admins, but it works for DBAs as well.
2001-04-25
3,450 reads
Keeping Your Developers Under Control
Everyone needs a stable environment. This article discussed ways to keep your team on the same page.
2001-04-25
5,793 reads
Automatically Gathering Server Information Part 5
The fifth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-24
6,944 reads
Stuff Computer Support People Love
For anyone who supports desktops, this document shows how to sarcastically please your IT department.
2001-04-24
3,671 reads
Using InterDev's Toolbox
If you've ever played around with the toolbox, you may have discovered one of InterDevs hidden gems. Did you know that the InterDev Toolbox allows you to add you own custom tabs? This feature allows you to access frequently used snippets of code in an instant
2001-04-24
3,059 reads
Introduction to DSN's
This article by Andy Warren is an introduction to DSN's; what they do, how they work, and where they are stored. Also pick up some ideas about how using a File DSN might save you a lot of administration!
2001-04-23
8,416 reads
Analysis Services Enhancements
In SQL Server 2000, Microsoft has closed the gap between its multidimensional database offering, OLAP Services, and the rest of the market place.
2001-04-22
4,377 reads
Blogs
Redgate Summit Comes to the Windy City
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
Non-Functional Requirements
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
Techorama 2024 – Slides
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on...
Forums
AG listener cant be removed
Testing with AG on Linux with Cluster=NONE. it was all going ok and as...
Remove comma inside Comma Delimited File csv in SSIS Using Script task
Hi, I have two tables: one for headers with 9 fields and another for...
Inserting 100K rows Performance - Baseline Performance
We're trying to understand how quick new versions of SQL server can be. Obviously...
Question of the Day
The "ORDER BY" clause behavior
Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records:
create table t1 (id int primary key, city varchar(50)); insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);If we execute the following query, how will the records be sorted in both environments?
select city from t1 order by city;See possible answers