Late June 2010 PASS VC Presentations
PASS BI and DBA Virtual Chapters have free training available on Wednesday June 23rd.
2010-06-23
475 reads
PASS BI and DBA Virtual Chapters have free training available on Wednesday June 23rd.
2010-06-23
475 reads
Providers
What are Providers? Providers in PowerShell are a hierarchical namespace way flattening out an infrastructure to make it accessible and...
2010-05-20
807 reads
Providers
What are Providers? Providers in PowerShell are a hierarchical namespace way flattening out an infrastructure to make it accessible and...
2010-05-20
1,273 reads
Providers What are Providers? Providers in PowerShell are a hierarchical namespace way flattening out an infrastructure to make it accessible and traverse-able just like a directory structure hard drive....
2010-05-20
16 reads
Cmdlets, Functions and Snapins
So far we’ve learned how to open up PowerShell and add on to it with some modules;...
2010-05-19
1,066 reads
Getting Started With PowerShell Variables
Yesterday we laid the ground work for PowerShell Week. Today we will learn about Variables in PowerShell. You will...
2010-05-18
994 reads
Welcome to PowerShell Week at SQL University. For regulars at SQLvariant, SQL University is something Jorge Segarra organized to get...
2010-05-17
1,056 reads
To finish up the month of April we’ve got sessions from AppDev and DBA and I’m even including one from PASS on ‘Intro to Speaking At PASS’.
2010-04-26
452 reads
I promise to make this worth your time. (Oops, I better make this quick.)
Alright so with PowerShell if you open...
2010-02-22
1,270 reads
By Brian Kelley
Following the advice in Smart Brevity improves communication.
By John
Microsoft has released SQL Server 2025, bringing big improvements to its main database engine....
By Steve Jones
A customer was asking about what certain items in Redgate Monitor mean. They have...
Comments posted to this topic are about the item Which Table I
Comments posted to this topic are about the item Using Python notebooks to save...
Comments posted to this topic are about the item Your AI Successes
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
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