Second Chances: PASS Community Choice Sessions
Recently I found out that my PASS presentation submission ‘Policy-Based Management’ has a second chance to be accepted for the...
2011-07-18
789 reads
sqlchicken
Make It Simple With Policy-Based Management
At work recently, I explained to a coworker the reasons and benefits of having databases in Simple mode in your...
2011-07-13
921 reads
Automating Web App Deployments with SSIS
This is just a quick note to let everyone know I’ve uploaded the project files from my Pragmatic Works webinar...
2011-07-12
607 reads
SQL Server Denali CTP3: Policy Based Management
Whether you know it or not, Policy-Based Management is an integral part of the new release of SQL Server “Denali”....
2011-07-12
1,383 reads
LulzSec: Why You Should Care
Updating Resume is NOT Lulz
Wow, it’s been a crazy last couple of months with LulzSec running around doing what they...
2011-06-26
1,515 reads
Pragmatic Tools: DTSxChange (Or DTS Must Die!)
Ah DTS packages…they suck. Seriously, it’s 2011. It’s been over a decade and we still have SQL 2000 and DTS...
2011-06-07
850 reads
Pray For Me…I’m Writing the Bible!
Prayer Cat Prays
Well not THE Bible, but rather the SQL Server Bible! I’m incredibly excited and proud to say I’ll...
2011-05-24
546 reads
Pragmatic Tools Week: Task Factory
If you've ever spent any time doing SSIS development work, you'll eventually come to a point when developing something and...
2011-05-11
1,423 reads
SQLRally Overdrive: Birds of a Feather Discussions Event
Just wanted to post a quick note/invitation to everyone to come join us on Thursday, May 12th from 5:45-7:00 for...
2011-05-11
363 reads
Pragmatic Tools Week: BIxPress
Much like Tim “The Toolman” Taylor had his themed weeks, we’re going to do something similar. This week we salute:...
2011-05-09
642 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