2005-07-28
1,879 reads
Kathi Kellenberger
- Interests: Walking, running, grandchildren!
2005-07-15
1,740 reads
2005-07-07
1,858 reads
Dynamic Properties
One of the most useful tasks in SQL Server 2000's DTS environment is the Dynamic Properties task. Author Kathi Kellenberger brings us a look at how this task can help you accomplish an unusal import task.
2005-06-20
14,695 reads
Restoring to a Point In Time
One of the lesser used features of SQL Server 2000, but the capability to restore your databases to a particular point in time can be a valuable skill. Kathi Kellenberger takes a moment to explain how this feature works and how you can use it in your environment.
2005-06-14
17,837 reads
Turbo for SQL Server
Searching data is an essential part of SQL Server applications, especially text searching. While Full Text Search in SQL Server 2000 works, it lacks some important features that Turbo for SQL Server can handle. Read this review of the product and see if this is a way you can enhance the search functions in your application.
2005-06-01
7,458 reads
SQL Backup 3.0
SQL Server 2000 has a rock solid backup process and one that many people have relied upon for years. However with the growth in database sizes and the constant load on many database servers, a third party backup utility is almost required in many environments. Kathi Kellenberger takes a look at Red-Gate Software's SQL Backup 3.0 and how it performs in her environment.
2005-04-27
12,400 reads
SQLH2: The Free Health, History and Performance Monitoring Tool
One of the strengths and powers of the SQL Server platform over others is the shear number of things that are available free from Microsoft besides the relational platform. DTS, Reporting Services, SQLAgent, and more are included with the product. One of the newer utilities is SQLH2, a performance monitoring tool that is reviewed here by Kathi Kellenberger.
2005-03-28
18,587 reads
Access to SQL Server: Getting Started with Access Projects
SQL Server 2000 and Access databases are two technologies closely linked with the new Access ADP format using SQL Server as the basis for the code. Access Projects are also a way to closely link the two products together and take advantage of each to produce an application very easily. Author Kathi Kellenberger brings us part 3 of her Access series with a look at Access Projects.
2005-02-24
10,023 reads
Blogs
Getting Your Data GenAI-Ready: The Next Stage of Data Maturity
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
Forums
Azure SQL DBA certification
Hello team Can anyone share popular azure SQL DBA certification exam code? and your...
Faster Data Engineering with Python Notebooks: The Fabric Modern Data Platform
Comments posted to this topic are about the item Faster Data Engineering with Python...
Which Result II
Comments posted to this topic are about the item Which Result II
Question of the Day
Which Result II
I have this code in SQL Server 2022:
CREATE SCHEMA etl;
GO
CREATE TABLE etl.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT etl.product
VALUES
(2, 'Bee AI Wearable');
GO
CREATE TABLE dbo.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT dbo.product
VALUES
(1, 'Spiral College-ruled Notebook');
GO
CREATE OR ALTER PROCEDURE etl.GettheProduct
AS
BEGIN
exec('SELECT ProductName FROM product;')
END;
GO
When I execute this code as a user whose default schema is dbo and has rights to the tables and proc, what is returned? See possible answers