There are any number of small, annoying or tedious things in SQL Server and Steve Jones makes a case for getting them fixed. Today's editorial was originally published on Nov 11, 2008. It is being re-run as Steve is out of town.
2013-02-21
151 reads
Things on the ranch inspire Steve Jones in the rest of his life. He's one you might not have thought about. Today's editorial was originally published on Nov 3, 2008. It is being re-run as Steve is out of town.
2013-02-20 (first published: 2008-11-03)
206 reads
It is late evening. Something is wrong with a database. You narrow down the possibilities, getting more frustrated and puzzled. Stay calm. Check the inputs systematically. No! The data going into that table is right, but when you then read it in the table, it's wrong. Why did I stop believing in the supernatural? Then it hits you. Every time it comes as a surprise. They're using triggers. (This editorial was originally published on Nov 10, 2008)
2013-02-19 (first published: 2008-11-10)
624 reads
Our desktop OSes have evolved to support group accounts, but much of the ecosystems around them do not and many mobile and tablet devices do not. Why don't they?
2013-02-13
86 reads
There are a lot of regulations around data in the medical field. Most of the exceed HIPAA, but end up causing confusion and problems. Steve Jones thinks simplication is important if our technology systems are to support future regulations.
2013-02-11
93 reads
This week Steve Jones notices some good advice from Brent Ozar and the fastest query in your database.
2013-02-11
223 reads
Steve Jones is up in the Redmond area at Microsoft's HQ looking for SQL Server developers. This editorial was originally published on April 17, 2008. It is being re-published as Steve is on holiday.
2013-02-08 (first published: 2008-04-17)
677 reads
IBM is sending a Watson supercomputer to college. We don't know what will happen with this experiment, but it is exciting for those of us looking forward to interacting more with computers in the future.
2013-02-07
103 reads
Data Journalism is a new idea that is bringing us a new way of reporting on the world. Steve Jones thinks this might be useful inside of all kinds of organizations.
2013-02-06
91 reads
There are a lot of advantages for small companies in using cloud services, but is that the case for large IT groups? Steve Jones has a few thoughts.
2013-02-05
172 reads
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
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
exec etl.GettheProduct
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