Business Pressures
The business pressures can often change how we work, or even how we build our software. A few notes on Github from Steve Jones.
2019-09-10 (first published: 2015-08-12)
277 reads
Editorials
The Scientific Method: a call to action
Gail Shaw issues a rallying call for the SQL Community to adopt the Scientific Method when investigating and reporting on SQL Server behavior.
2019-09-09 (first published: 2015-05-25)
613 reads
Your chance to speak at PASS Summit
When I decided to switch careers about 25 years ago, I had no idea how far I would go in tech. I just wanted to leave the profession for which I had trained and become a developer. My goal was to make the switch by the end of 1998. It actually happened in the summer […]
2019-09-07
135 reads
Turn Out the Lights
Today we have a guest editorial from Andy Warren that looks at the costs associated with our behavior.
2019-09-06 (first published: 2016-01-18)
412 reads
The Ongoing Costs of Building Software
There are lots of costs to building your own software, which Steve Jones notes might not be what you want to spend over time.
2019-09-05 (first published: 2016-01-13)
312 reads
20 Years of Compare
When we started SQLServerCentral, there were originally 7 of us. We all decided to "invest" $50 to get the site going. With this seed money, we paid for a VM that hosted both SQL Server and IIS. This was enough money to run the site for 6+ months, and we set about building an online […]
2019-09-04
268 reads
2019-09-03 (first published: 2015-08-25)
269 reads
Too much information can be counter-productive
If you want to be an effective communicator focus on what your audience need to hear rather than what you want to say
2019-09-02 (first published: 2016-01-29)
375 reads
Always Check on the Basics
The basics are important, especially with regards to backup and restore in SQL Server.
2019-08-31
352 reads
Do You Deal with UTF-8?
UTF-8 is coming to SQL Server. Steve wonders today how many of you look forward to this, or if you are aware of potential issues.
2019-08-30
323 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