Investing In Your Career
Do you invest in your own career? Should you? Steve Jones asks the question in today's Friday poll.
2009-10-09
198 reads
Editorial
Are you looking to Hadoop?
Hadoop is an interesting new software project in the Linux world that deals with large data sets. Steve Jones wonders if anyone in the SQL Server world has started working with it.
2009-10-08
1,344 reads
Motivating the Team
It's easy to get excited if you work at a startup, or a software company. But for corporate workers that toil in IT departments all around the world, how do you keep them motivated? Steve Jones has a few thoughts about simple things that make workers feel better about their jobs.
2014-06-06 (first published: 2009-10-07)
295 reads
Is Your Server Vendor Providing the Quality, Innovation, and Support You Need?
We should get help from vendors, as well as support, but what about innovation? Today's guest editorial from Brad McGeHee asks if the third party tool vendors for SQL Server are doing enough to provide value for the cost of their tools.
2009-10-06
56 reads
Support The Boss
Providing support for your manager or boss in getting his or her job is a good thing. Steve Jones comments on what benefits you might get and why this could enhance your career.
2014-06-20 (first published: 2009-10-05)
279 reads
DBAs and the Fear of Maintenance Plans
The Maintenance Plan wizard offers a quick and simple route to make sure essential database maintenance tasks are performed and scheduled. However, it needs to be used with a lot of care, and is no substitute for the judgment, experience and common sense of a flesh and blood DBA.
2009-10-05
376 reads
The Incidental DBA
There are lots of technical people that are forced to be DBAs by necessity. However there is another class of DBAs, the Incidental DBAs. Andy Warren brings a guest editorial that reminds us about this group of people that work with SQL Server.
2009-10-02
180 reads
In Praise of Barebones Applications
The English voice of IT reason, Phil Factor, brings us a guest editorial. Today he waxes about the overbearing processes used to build internal corporate applications.
2009-10-01
190 reads
Generation X
Steve Jones is a part of Generation X, who surprisingly seems to be more Web 2.0 oriented than Generation Y.
2009-09-30
138 reads
Security Focus
Are IT administrators focusing on the wrong attacks when securing their systems? Should we as DBAs and developers care? Steve Jones argues that we want to be aware of these issues.
2009-09-29
104 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