The Industry Problem
We have less people studying technical subjects and an apparent shortage of technical talent in the IT field. Steve Jones thinks we might have an industry wide problem.
2011-11-14
226 reads
Editorial
Don't Criticize Code
For anyone eager for a long-term career in IT Development, humility and tact are probably more important habits to acquire than demon coding-skills. Phil Factor explains why.
2011-11-14
315 reads
First Impressions
Today we have a guest editorial from Andy Warren that examines the first impressions that you create when you meet someone.
2011-11-11
125 reads
Watching the Watchers
This editorial was originally published on Jan 16, 2007. It is being republished today as Steve is on vacation. This one looks at the potential issues with data mining when data might be shared between companies.
2023-03-13 (first published: 2011-11-10)
153 reads
License By Core
Microsoft recently announced changes in the licensing for SQL Server 2012 and Steve Jones has a few thoughts on the topic.
2011-11-09
295 reads
Real Time Dangers
Steve Jones notes that our expert systems might not handle every situation well, and the quest to move towards more real time decision making can involve dangers if a human is not in the loop.
2011-11-08
134 reads
Going Green in Software Development
Today Steve Jones talks about the impact of better software programming on the energy use in your company's data center.
2011-11-07
96 reads
Never offend a captive audience
Write what you choose to when the reader can, in turn, choose not to read your work; but when you are writing about Technology, you have a captive audience. They need to read your work to keep abreast of the technology. Don't gratuitously offend them. It is not the action of a gentleman, D____it!
2011-11-07
117 reads
ETL
Today we have an editorial that was originally published on Aug 31, 2006 as Steve is traveling at DevConnections. It still seems relevant, so answer the poll this week.
2011-11-04
209 reads
Laptop Boy Scouts
This editorial was originally published on Jan 10, 2007. Steve is at DevConnections, so it is being republished. This piece talks about laptop security when you are working in a public place.
2011-11-03
89 reads
Blogs
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...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
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