Happy Halloween 2011
It's Halloween day, the night for dressing up in costume and being a little silly. Hopefully it's also a fun day without anything going wrong for you at work.
2011-10-31
71 reads
Editorials
Employee Slurping
This editorial was originally published on Oct 21, 2006. It is being re-run as Steve is out at SQL in the City today. This one talks about the security of USB devices and the potential problems of employees copying data.
2011-10-28
174 reads
Virtualization for Security
This editorial was originally published on Nov 7, 2006. It is being re-run as Steve is at SQL in the City today. Today Steve talks about security using virtualization.
2011-10-27
52 reads
The Good Job
Today Steve Jones talks about jobs, and how life is too short to stick with a crappy job.
2011-10-26
223 reads
The HR Scorecard
If you are looking to gain some BI experience or tackle a project that might help your company, Steve Jones suggests you consider doing something for HR.
2011-10-25
346 reads
Don’t Economize on Processors for Database Servers
In this guest editorial, Glenn Berry argues that, when designing your servers, you need to budget for processing power as your primary concern.
2011-10-24
290 reads
The Cost of Architecture
What's the cost of those architectural decisions that you make? It can be substantial if they aren't good ones, but is that a problem? Steve Jones talks a little about the implications
2011-10-24
159 reads
Which Versions of SQL Server Do You Have?
This week Steve Jones asks about the versions of SQL Server that you have to support in your daily job. Answer this week's poll and let us know the width and breadth of support that you are responsible for maintaining.
2011-10-21
209 reads
Not Only SQL
Steve Jones talks NoSQL today, which should stand for Not Only SQL, according to Dr David DeWitt. The final keynote last week discussed SQL alternatives and their impact on our data world.
2011-10-20
169 reads
Protecting Data
How hard is it to anonymize data? According to some research, it might be close to impossible. The problem is that we are gathering so much data that cross referencing data sets becomes a problem. Steve Jones talks today about the implications of this for security.
2011-10-19
126 reads
Blogs
Getting Your Data GenAI-Ready: The Next Stage of Data Maturity
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
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...
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