Phil Factor reflects on Microsoft's "handbrake turn" on OLE DB; Denali's successor will have to have all this plumbing ripped out to replace it with the older ODBC technology. It's a surprising move but makes a lot of sense, given the ubiquity of ODBC drivers for relational data access.
2011-09-12
285 reads
This Friday Steve Jones asks if we should reconsider the way we train developers and other computer professionals. Give us your opinion this week.
2011-09-09
135 reads
Today Steve Jones talks about a way to improve your skills, make yourself more marketable for that next job, and perhaps earn some money.
2011-09-08
181 reads
Steve Jones talks about the idea of an automated DBA and disputes the notion that it will come to pass anytime soon.
2011-09-07
238 reads
It seems that there are new types of hacker attacks, not looking to steal information for profit, but for disclosure as an embarrassment. Steve Jones talks about the potential downsides for DBAs.
2011-09-06
127 reads
It's a holiday in the US today and Steve Jones provides a little entertainment for those people still at work.
2011-09-05
72 reads
Do Agile IT projects have anything to learn from the organizational structures and laws used by pirates? Phil Factor is not convinced.
2011-09-05
118 reads
This week Steve Jones asks you what you think will make up the majority of your future databases? Will it be numerical data or will some other type come to dominate?
2011-09-02
138 reads
Today we have a guest editorial from Andy Warren. Most people work in an office and need to commute, which brings with it the inevitable fight for parking in many companies. How is it handled for you?
2011-09-01
164 reads
Amazon has built a cloud just for the US government. Will we see more specialized clouds in the future that might let us move some of our data to the cloud?
2011-08-31
125 reads
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Hello team Can anyone share popular azure SQL DBA certification exam code? and your...
Comments posted to this topic are about the item Faster Data Engineering with Python...
Comments posted to this topic are about the item 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