The DBA Office
The environment in which we work can have an affect on the way in which we work. Steve Jones asks today if you have a preference for your environment.
2013-04-12
218 reads
Editorials
Don't Accept Defaults
All software has default values, some of which might not suit your environment. This is especially true with regards to security settings.
2013-04-11
93 reads
The IT Employee Benchmark
What's important in an IT employee? Steve Jones talks about the skills and measurements CIOs want today and tomorrow. Today's editorial was originally released on July 22, 2008. It is being re-published as Steve is at SQL Intersection.
2013-04-10 (first published: 2008-07-22)
585 reads
Driving Value
Does your IT organization bring value to your company? Steve Jones takes a look at some of the ways you can do this. This editorial was originally published on July 2, 2008. It is being re-published as Steve is at SQL Intersection.
2013-04-09 (first published: 2008-07-02)
156 reads
Double Compliance
Sometimes auditing for one certification might help you pass another, but don't count on it.
2013-04-08
139 reads
The Memory Cube
A new memory technology has the potential to dramatically speed up access for computer systems.
2013-04-08
161 reads
Development, Operations, or Accounting
Cloud services need to have a much higher quality of work than their in-house equivalents if corporations are to take them seriously according to Steve Jones.
2013-04-04
106 reads
Data Darwinism
Data could be the way that more decisions are made, separating the competent from the incompetent in the future. Steve Jones isn't sure this is the best way to make decisions if we don't include a human element in the decision process.
2013-04-03
118 reads
Salaries in 2013
The release of an extensive salary report for Information Technology shows some good trends in it for 2013.
2013-04-02
447 reads
Google Glass Your Database
A new idea from a small startup may revolutionize the way that you search for data.
2013-04-01
326 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