The Push to Upgrade from SQL Server 2005
There's a push to upgrade those SQL Server 2005 instances with support ending this April.
Moved to the Cloud?
Are you thinking about the cloud yet? Redgate is conducting some research into cloud adoption to better understand both the drivers and the blockers. Whether or not you’ve taken the plunge yet, they would love to hear from you. Participate in the survey and be entered into a draw to win an Amazon gift card worth $100.
SQL Server System Views: The Basics
When maintaining or refactoring an unfamiliar database, you'll need a fast way to uncover all sorts of facts about the database, its tables, columns keys and indexes. SQL Server's plethora of system catalog views, INFORMATION_SCHEMA views, and dynamic management views contain all the metadata you need, but it isn't always obvious which views are best to use for which sort of information. Many of us could do with a simple explanation, and who better to provide one than Rob Sheldon?
Reasonable Timeframes
Steve Jones talks about the timeframes for updating and fixing security problems in applications.
SSIS: Case sensitivity may expose issues with change deployment
Because SSIS is case sensitive, random VS_NEEDSNEWMETADATA errors on case-insensitive databases may indicate issues in your database change management & deployment process.
Redgate Cloud Research
Are you thinking about the cloud yet? Redgate is conducting some research into cloud adoption to better understand both the drivers and the blockers. Whether or not you’ve taken the plunge yet, they would love to hear from you. Participate in the survey and be entered into a draw to win an Amazon gift card worth $100.
SQL Server 2016 Row Level Security Block and Filter Predicates Example
Rajendra Gupta takes a look at the additional enhancements made to Row Level Security in SQL Server 2016 CTP 3.1 and explores the new features with examples.
Cloud Adoption Survey
Are you thinking about the cloud yet? Redgate is conducting some research into cloud adoption to better understand both the drivers and the blockers. Whether or not you’ve taken the plunge yet, they would love to hear from you. Participate in the survey and be entered into a draw to win an Amazon gift card worth $100.
Enabling TDE on Databases in an AlwaysOn Scenario
Enabling Transparent Data Encryption on Databases in Always On Scenario
Blogs
From Couch-Potato to Triathlete – and What This Means for Your SQL Server
Do you know if your SQL Server is really running at its best? To...
Retro Data 2025 – Slidedeck
You can find the slides of my session on the €100 DWH in Azure...
The Book of Redgate: We Value Teams
By Steve Jones
This value is something that I still hear today: our best work is done...
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