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,019 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,064 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,627 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
443 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
513 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
451 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
546 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,131 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
296 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
670 reads
Blogs
The Book of Redgate: We Value Teams
By Steve Jones
This value is something that I still hear today: our best work is done...
Troubleshooting TempDB Log Full Errors When SSMS Won’t Connect
By gbargsley
Have you ever received the dreaded error from SQL Server that the TempDB log...
Accelerating AI with Confidence: Why Microsoft Purview is Key to Responsible Innovation
By Chris Yates
Artificial intelligence is no longer a distant concept. It is here, embedded in the...
Forums
Is there a way for SP to know who called it?
Hi everyone I am writing an SP where there is logic inside the SP...
Planning for tomorrow, today - database migrations
Comments posted to this topic are about the item Planning for tomorrow, today -...
Bottlenecks on SQL Server performance
We have a BI-application that connects to input tables on a SQL Server 2022...
Question of the Day
The Tightly Linked View
I try to run this code on SQL Server 2022. All the objects exist in the database.
CREATE OR ALTER VIEW OrderShipping
AS
SELECT cl.CityNameID,
cl.CityName,
o.OrderID,
o.Customer,
o.OrderDate,
o.CustomerID,
o.cityId
FROM dbo.CityList AS cl
INNER JOIN dbo.[Order] AS o ON o.cityId = cl.CityNameID
GO
CREATE OR ALTER FUNCTION GetShipCityForOrder
(
@OrderID INT
)
RETURNS VARCHAR(50)
WITH SCHEMABINDING
AS
BEGIN
DECLARE @city VARCHAR(50);
SELECT @city = os.CityName
FROM dbo.OrderShipping AS os
WHERE os.OrderID = @OrderID;
RETURN @city;
END;
go
What is the result? See possible answers