The Power of Hadoop
Hadoop is an open source framework for working with data, and one that Microsoft has adopted. Is it worth using in your environment? Steve Jones thinks you should investigate it.
2012-02-27
790 reads
Editorials
A Break from Databases
A Friday poll that's a break from work, and should be a bit of fun. Today Steve Jones asks about movies, and what's been interesting from the last year.
2012-02-24
160 reads
Future Virtual Machines
What's the benefit of virtual machines and hypervisors? Steve Jones has a few comments on them and their future.
2012-02-23
341 reads
2012-02-21
160 reads
Putting JSON on an equal footing to XML
In SQL Server, we treat XML with a reverence that is disproportionate to its importance. The SQL Server team have indeed gone big on XML, as Michael Cole’s book reveals. The industry has gone big in another direction: JSON.
2012-02-20
628 reads
Programmers v Salespeople
This Friday Steve Jones asks whether you think the salespeople or the technical people are more important to the success of a company. And if they should be better compensated.
2012-02-17
246 reads
Use Your Tools
It's easy to get stuck in a rut and not learn to use the new features and capabilities of your tools are they evolve. Steve Jones reminds you it's worth a little time investment to learn about your tools.
2012-02-15
222 reads
A Valentine for the Community
This Valentine's Day Steve Jones wants to thank everyone in the community for their efforts.
2012-02-14
96 reads
Anonymous Research
Anonymizing data is hard, and Steve Jones talks about some of the problems with trying. Is this something we should be more concerned about this with our corporate data?
2012-02-13
118 reads
Upgrading Your Career
Certification is on Steve Jones' mind this week after quite a few training opportunities have popped up lately.
2012-02-13
279 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