Statistical Protection
Statistical databases contain lots of information that can be used in a variety of ways, but it can also be abused. Steve Jones talks about some of the problems and potential solutions.
2013-01-08
110 reads
Editorials
The $50,000 Laptop
The average value of a lost laptop has been found to be much more than you might expect. Steve Jones talks about a recent study.
2013-01-07
215 reads
What Counts for a DBA: Amnesia
Louis Davidson explains why DBAs often need a healthy dose of selective, enforced amnesia about the pain of previous failures.
2013-01-07
156 reads
DR Prep
This week Steve Jones asks how you might handle DR preparation or process differently in the new year.
2013-01-04
115 reads
All Flash
Should you think about using SSD storage in your SQL Server databases? Steve Jones thinks this might be something you should consider.
2013-01-03
222 reads
2013-01-01
275 reads
2012-12-31
220 reads
'At-Rest Data-Leakage': The Euphemism
If you let working drives leave the building in a readable state, you’re unintentionally in the publishing business.
2012-12-31
92 reads
2013 Goals
For the last Friday poll of the year, Steve Jones looks ahead to 2013 and the goals you might set for your career.
2012-12-28
188 reads
The Daily Routine
Steve Jones compares his daily routine now to that of being a DBA. This editorial was originally published on Mar 10, 2008. It is being re-run as Steve is on holiday.
2012-12-27 (first published: 2008-03-10)
589 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