SQL University: Precedence Constraints
Welcome back, class! In our last class, we setup a parent-child package configuration and showed how you can pass variables...
2011-05-06
2,104 reads
sqlchicken
SQLRally OverDrive Events!
So you’re going to SQLRally in Orlando next week? Want to take advantage of ALL of the awesome opportunities presented?...
2011-05-06
391 reads
Policy-Based Management and Local Password Policy
This post is based on an interesting question/situation that was posted over at ASKSSC.com today. The user asked how to...
2011-05-04
1,390 reads
Parents Just Don’t Understand
Welcome to the second week of SSIS this semester at SQL University. Today we’re going to talk about the relationship...
2011-05-02
646 reads
SQL University: Parents Just Don’t Understand
Welcome to the second week of SSIS this semester at SQL University. Today we’re going to talk about the relationship...
2011-05-02
599 reads
Be the Master of your Data Warehouse Universe at SQLRally!
Do you have a data warehouse initiative in your current organization and looking for a way to learn how to...
2011-04-14
845 reads
Find Table Heaps Using Policy-Based Management
This is just a quick post in regards to a conversation I just had via Twitter. If you don’t already...
2011-04-08
1,016 reads
Meme Monday: 11 Words or Less
Looks like time for another meme, this time from Tom LaRock (Blog | Twitter). He challenged us to write a blog...
2011-04-04
373 reads
24 Hours of PASS: Day 1
Yesterday was the first day of PASS’ 24 Hours of PASS event. For those not familiar, 24 Hours of PASS is...
2011-03-16
754 reads
SQL University Lecture Series: Women in Tech
This week SQL University is on Spring Break but we’ve lined up some activities to help keep students busy (you...
2011-03-16
645 reads
Blogs
How to Run Databases on Kubernetes: An 8-Step Guide
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
Episode 11 of Simple Talks: Oracle
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
A New Word: Mornden
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Forums
What is the best index strategy for a table that gets truncated?
Hi everyone My SSIS package does a bulk insert of csv files into a...
Blob Storage automated downloads
Dipping my toes into the waters of Azure and of course before I get...
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers