SQL Saturday #43 - Redmond
If you are in the Redmond, WA area, join in for a free day of SQL Server training on June 12, 2010.
2010-06-03 (first published: 2010-04-28)
1,238 reads
Press Release
Kalen Delaney at the Denver SQL Users Group
Sponsored by Dell, Kalen Delaney is coming to the Denver Marriot Tech Center on June 9.
2010-06-01 (first published: 2010-05-18)
1,079 reads
Free e-book: Introducing Microsoft SQL Server 2008 R2
For a limited time, you can download this 10-chapter e-book: Introducing Microsoft SQL Server 2008 R2, by Ross Mistry and Stacia Misner.
2010-05-31
5,703 reads
TSQL Challenge 31 - Managing multiple overlapping date intervals.
This challenge is adapted from a budgeting system used in a large company to perform quarterly analysis of what kind of work will be done and where it will be done. Project Managers make plans and the estimated hours of work required from each employee each month end up in a central database. Top managers want to see a synthesis of this by department and profession
2010-05-31
2,449 reads
SQL Saturday #22 - Pensacola
A free one day training event from SQL Saturday and the Pensacola SQL Server groups. Come join Steve Jones and Brad McGehee if you are in the area on Jun 5, 2010.
2010-05-28 (first published: 2010-05-10)
2,335 reads
SQL Server MasterClass with Kimberly Tripp and Paul Randal
If you will be in London on June 17th, this is an event you do not want to miss.
2010-05-26
2,090 reads
1st New England Business Intelligence Code Camp
This is a major Business Intelligence community event for Developers and IT professionals that focus on building real-world BI solutions using the Microsoft Business Intelligence Platform tools and technology on May 22nd 2010! May 22 in Waltham, MA
2010-05-20
1,422 reads
TSQL Challenge 30 - A Matrix Transposition challenge in TSQL
This is a matrix transposition challenge. Your job is to change the position of the numbres in a 5x5 matrix.
2010-05-17
2,132 reads
SQL Lunch #19-Configuring, Deploying and Scheduling SSIS Packages
May 10, 2010, 11:30CST. Now that you have created your SSIS packages it’s time to add some configuration files that will ease your deployments. Wait how do you deploy one or two or three SSIS packages? Uh oh, now that they are deployed how do you schedule them? Well join Patrick LeBlanc in his discussion on how to Configure, Deploy and Schedule your SSIS packages.
2010-05-10 (first published: 2010-05-07)
5,200 reads
SQL Saturday #38 - Jacksonville
Come attend this great one day free event on the Florida coast on May 8, 2010. There are a number of great speakers that make this worth attending.
2010-05-05 (first published: 2010-04-20)
2,639 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