2014-03-19
468 reads
Editorials
Getting Started with Azure
Many people have been unsure of cloud computing and what it means for your particular application. Steve Jones notes there's a great new demo that can help you get started exploring the Azure offerings.
2014-03-17
170 reads
How Many Passwords?
How many passwords do you have? Steve Jones has a lot and while he notes there are some new ways for us to authorize ourselves for servers, they aren't necessarily making things more secure or less complex.
2014-03-17
137 reads
Squeezing the DBA
What do you do as a DBA if you get asked to cook the books? With the economy doing poorly, some executives will be tempted to mis-report earnings and they might ask the technical people to help. Steve Jones has a few thoughts.
2014-03-14 (first published: 2009-09-03)
334 reads
#sqlhelp
The #sqlhelp hashtag on Twitter is a great way to interact with the SQL Server community and get help.
2014-03-13
237 reads
A True SQL OS
SQL Server is so large and complex that it's like an operating system. In fact, there the core engine is often referred to as the "SQL OS" by Microsoft developers. Steve Jones would like to see SQL Server as it's own OS at some point.
2014-03-12 (first published: 2009-08-26)
525 reads
Developers, developers, developers
A survey of developers on Stack Overflow has some interesting results that Steve Jones notes. Some of them might just impact our careers as data professionals.
2014-03-11
298 reads
An Integrated Process for Software Delivery.
Developers, enamored of the integrated approach to Software Delivery, would like to be able to respond to business need in business time, adding functionality when the need is recognized, instead of 6-9 months later after it's gone through the sclerotic IT purchasing and configuration process.
2014-03-10
87 reads
Continuous Delivery
The practice of continuous software development is growing, with continuous integration, deployment, and delivery being topics that Steve Jones is learning about. Today he talks about delivery.
2014-03-10
156 reads
Mini-Me
This Friday Steve Jones asks if you build your own mini-me's to help you manage your database systems.
2014-03-07 (first published: 2008-11-21)
590 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
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
JSON Has a Cost
Comments posted to this topic are about the item JSON Has a Cost, which...
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