SQL Server 2012: Business Intelligence Edition
Well this was quite the little surprise this morning. Microsoft announced a new edition to the SQL Server lineup for...
2011-11-03
2,714 reads
sqlchicken
Deploying SSIS Packages with BIxPress
Same functionality but obvious differences
If you’ve worked with SSIS for any amount of time, you may quickly come to find...
2011-10-24
1,397 reads
We Are Community
Today I was planning on writing a summary post of PASS Summit experience but something happened last night that caused...
2011-10-19
1,137 reads
PASS Summit Keynote Day 1 Highlights
CLOUD! BIG DATA! EXCEL! CLOUD! CLOUD! Okay, recap done. Not really…sort of. In all honesty, while delivered in a fairly...
2011-10-13
702 reads
Expiring Databases and Policy-Based Management
Today on Twitter my friend Jes “Run Forrest Run” Schultz Borland (Blog | Twitter) asked the Community “How do you clean...
2011-10-06
1,254 reads
Small Business Hardware
[NOTE] My blog post scheduling-fu is weak, so this post didn’t go out Friday as planned. My apologies.
This is the...
2011-09-26
1,414 reads
SQL University: SQL Server Editions for Small Businesses
In our last session we talked a little bit about the different options you have in regards to SQL Server...
2011-09-21
1,088 reads
SQL University: Architecture for Small Businesses
Welcome back to SQL University! This week we’re going to be discussing architecture. In previous weeks we’ve discussed architecture at...
2011-09-19
820 reads
SQLSaturday #85 Orlando: Pragmatic Works BI Pre-Con!
I’m very proud to announce that Pragmatic Works will be presenting a Business Intelligence Workshop pre-con for SQLSaturday #85 in...
2011-07-27
683 reads
OMG I’m an MVP!
I can’t believe it, but I can finally say that I’m now officially a Microsoft SQL Server MVP! Last week...
2011-07-25
774 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