Review : Rent A Geek Book with IQReference
If your bookshelf looks like most in the technology field, you tons of tech books. This new product by IQ Destination allows you to virtually rent books.
2001-09-26
2,583 reads
Brian Knight
Update: Funny Windows Error
Thanks to all of you who have sent us your funny SQL Server and Windows errors. Here are a few more contributed by Sergei Yakovlev.
2001-09-26
253 reads
Funny SQL Server Error Messages
This is the funniest error message Brian Knight has ever seen in SQL Server.
2001-09-18
7,316 reads
Death of the Production DBA
If you see a priest outside your cubical, beware! He could be trying to read you your last rites. If he hasn't showed up yet, don't worry, he'll be over shortly because the production DBA is dead or will be shortly.
2001-09-10
9,691 reads
Review: Loading Sample Data with DataTect 1.6
So, you've created a database and application and want to see how it operates with a substantial load of data In this product review of Datatect 1.6, you can learn how this third-party product could help you benchmark you database with a lot of sample data.
2001-08-15
3,943 reads
Database Growth Monitor
The script will monitor the growth of the databases on your server. It is really meant to just get you started on a more detailed solution.
2001-08-08
5,379 reads
Kill All Users in A Given Database
This script will kill all users in a given database. Before disconnecting, it can optionally send the user a NET SEND Message giving them a warning to disconnect. To run, simply call it like usp_killusers 'dbname'. Make sure the @dbname parameter is not the master database.
2001-08-08
4,544 reads
Quickly Enable/Disable Triggers and Constraints
When loading data, nothing can be more frustrating than having to deal with stubborn constraints and triggers. This is especially true when you know your data is fine but the constraints are too prohibitive for a mass initial load. Here's a technique I use to disable the constraints and triggers temporarily during a mass load. […]
2001-08-08
3,131 reads
Optimizing DTS Data Loads
In this article, Brian Knight shows you the different ways to load data in DTS and how to optimize the Data Pump task for data loads. He also examines performance numbers on other data loading tasks in DTS.
2001-08-02
7,505 reads
FAQ : Why can't I see my text field's data when using ADO?
In this FAQ of the week, you'll see one of the most common bugs that programmers run into when programming using ADO against a SQL Server.
2001-07-06
46 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
What Did Healthy Look Like?
Comments posted to this topic are about the item What Did Healthy Look Like?
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers