Should We Lead or Follow?
Microsoft used to lead the way and teach us about their products. But it seems that perhaps the tide is turning and they are looking for us to lead them. Steve Jones has a few thoughts on the topic.
2010-03-18
82 reads
Editorials
Security Regulations
There have been calls for governmental security regulations for IT. Is that a good thing? Steve Jones comments today.
2010-03-17
157 reads
Stop, Don't Panic
Your response in a crisis situation can be critical to how quickly you solve the issue. Steve Jones reminds you to stay calm in today's editorial.
2010-03-16
162 reads
Database Documentation: Joining up the Dots
This week, a guest editorial from Phil Factor on how SQL Server database documentation falls woefully short of what is required and expected by most development teams.
2010-03-15
452 reads
The Corporate Borg
A new type of application looks to collate and integrate knowledge from workers all around a company. Steve Jones is reminded of the Borg for today's editorial and says it might be good for data professionals.
2010-03-15
218 reads
Friday Afternoon
This Friday's poll asks when types of distractions you might like to have at work that would let you recharge. Answer and let everyone else know what would help you enjoy your job more.
2010-03-12
132 reads
Separate Styles
Does it make sense to publish multiple articles on the same subject? Steve Jones talks about the reasoning behind how SQLServerCentral chooses content.
2010-03-11
135 reads
Code Writing Code
Do you write code that writes code? Steve Jones thinks this is one of those milestones that marks the maturity of a DBA.
2010-03-10
418 reads
Taking Advantage of SQL Server Tools
How many of you are taking full advantage of SQL Server tools? Brad McGehee thinks the answer is "Surprisingly few", and suggests you take the time to learn, and eventually master, the tools which already come with SQL Server.
2010-03-08
483 reads
Too Tipsy To Work
We all need time to relax and unwind, but what happens if that time is interrupted by a work call? Should you respond? Steve Jones reminds us that you can say no if you are not prepared to work.
2010-03-08
236 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