Coding for the Future
Writing code that solves problems and adapts to the future is a challenge, but it's something we should think about.
2022-01-12
276 reads
Editorials
Teams Security Issues
There are a few security issues in the Teams application from Microsoft, and Steve notes that some of the push for new features can be a problem in this area.
2022-01-10
295 reads
Where the World Takes You
We're launching into a new year and there are lots of "looking into the future" articles out there. Personally, I'm pretty jazzed for the coming year for any number of reasons (can you say "SQL Server 2022"?). However, I also get a little retrospective at times like this. Now, I'm not going to talk about […]
2022-01-08
174 reads
What Were Your 2021 Wins
The first poll question of the year has Steve asking you to look back at 2021 and pick something good that happened.
2022-01-07
177 reads
Challenging Trends
Steve notes the changes in the world might affect how to view and use data in our work.
2022-01-05
275 reads
Data Cleanup
Steve wishes we could do some data cleanup and archival every year. Or even more often.
2022-01-03
324 reads
Education to solve the tech skills shortage
I’ve been teaching T-SQL to groups of students since 2014 at the non-profit LaunchCode in St. Louis. LaunchCode provides free tech training, paid apprenticeships, and career support to hundreds of people who have the ability and interest but not always the opportunity to land tech careers. For example, not having a college degree can eliminate […]
2021-12-31
401 reads
2021-12-31
58 reads
2021-12-29 (first published: 2017-03-24)
160 reads
2021-12-27
231 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