Creating A SQL Server 2008\2008 R2 Failover Cluster
Details how to install a SQL Server 2008\2008R2 Failover Cluster Instance
2013-12-23 (first published: 2011-01-19)
18,551 reads
Perry Whittle
Repairing a Broken Log Shipping Plan From a Differential Backup
This article details how to reinitialise a Log Shipping scenario from a primary differential backup
2013-12-20 (first published: 2012-09-27)
4,025 reads
Moving Database Files in SQL Server
A short article that talks about the isues with moving SQL Server database files around on your storage subsystem.
2013-02-11
8,639 reads
Combining AlwaysOn Groups With Failover Cluster Instances
This article discusses failover cluster instances and AlwaysOn groups
2012-09-04
12,364 reads
AlwaysOn Availability Groups in SQL Server 2012
This article discusses and demonstrates AlwaysOn Availability groups in SQL Server 2012, a new feature for high availability.
2012-08-28
9,927 reads
2012-08-16
7,006 reads
Implementing Microsoft iSCSI Initiator Policies & Multi Pathing
Impementing iSCSI multi-pathing and redundancy policies
2012-03-09
3,992 reads
SQL Server Log Shipping Between Standalone\Workgroup Computers
This article describes the requirements to log ship databases between workgroup computers
2012-01-30
5,459 reads
Using and Creating Mount Points in SQL Server
This article talks about the use of mount points on Windows server for SQL Server installations and shows how you can create them.
2011-11-10
19,462 reads
Creating a 2 Node SQL Server 2008 Virtual Cluster Part 3
This article continues the series on how to create a 2 node Windows\SQL Server 2008 cluster with a look at slipstreaming the service pack and cumulative updates needed.
2011-08-12
5,678 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