I wrote a SQL Server auditing whitepaper!
I recently collaborated with Idera to produce a short whitepaper on the top 5 things to audit in SQL Server...
2016-07-27
1,020 reads
Databases – Infrastructure – Security
Not More Than 16 Characters?!?
Microsoft, you’re killing me. This is the warning I received when typing in a password for Office 365:
I blinked when...
2016-06-16 (first published: 2016-06-10)
4,074 reads
Protecting Against Delete without Where
If I’m doing any manual work with T-SQL, I always begin every set of data change operations with BEGIN TRAN...
2016-06-13 (first published: 2016-06-09)
3,629 reads
A Different Type of Currency
Recently, a member of the community lamented that folks weren’t willing to provide an email address for free training. This...
2016-06-09
445 reads
Slides from 2016 Techno Security & Mobile Forensics Conference
I’ve completed both of my presentations at the 2016 Techno Security and Forensics Investigation Conference (#technosecurity). If you were able...
2016-06-07
514 reads
Sights that just scream, “No!”
I’m at a conference, specifically a security conference. So I looked at the available WiFi connections. Among the conference and hotel specific...
2016-06-07
454 reads
Congrats to MSSQLTips on 10 Years!
MSSQLTips has posted about their 10 years as a resource to the SQL Server community. It’s where I do the...
2016-06-06
548 reads
On Software and OS Lifecycle Management
An Important Rule:
If you’re trying to convince someone to your viewpoint, insulting them generally doesn’t work. If it does anything,...
2015-04-30 (first published: 2015-04-17)
5,134 reads
On Software and OS Lifecycle Management
An Important Rule:
If you’re trying to convince someone to your viewpoint, insulting them generally doesn’t work. If it does anything,...
2015-04-17
300 reads
On PowerShell
I use PowerShell a lot and I write about using it to solve problems quite frequently. The fact that I...
2015-04-10
672 reads
Blogs
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
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.
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
exec etl.GettheProduct
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