SQLskills Immersion Events - Deep SQL Server Training!
SQLskills is offering a number of intense SQL Server training events later this year. A new class has been added in Chicago in May along with a London event in June.
2011-03-18
2,424 reads
Training
From Zero to SSIS in 5 Days
Learn Integration Services from SSIS expert and MVP, Andy Leonard in March. This 5 day class will be held on Mar 21-25, 2011 in Farmville, Virginia.
2011-02-10 (first published: 2011-01-25)
6,075 reads
Master Immersion Events from SQLskills.com
A new series of courses is available from SQLskills to help you better learn to manage and tune your SQL Server instances. These classes are designed to help you complete the MCM certification, but are also valuable for anyone that wants to become a better SQL Server DBA.
2011-01-27 (first published: 2011-01-10)
2,087 reads
Learning Sharepoint, SSIS and SSAS
Steve Jones outlines some ways that you might look to get additional training that can help move your career along.
2010-11-15
3,716 reads
SSIS Training Live and In-Person
MVP and author of our Stairway Series on SSIS, Andy Leonard, is holding an SSIS class this December in northern Virginia. If you are interested in top notch SSIS training, read on.
2010-11-19 (first published: 2010-11-02)
5,610 reads
April Webinar: MVP Series
Free webinar training brought to you by Pragmatic Works, WROX, SQL Server Central, and SQL Server Magazine. The April Series will run from April 20 - April 29, 2010. Register now to reserve a place.
2010-04-21
789 reads
SQL Server Central launches online training for SQL Server Developers, DBA’s, and Analyst’s
Build your SQL Server skills without leaving your desk.
2010-03-15 (first published: 2010-03-11)
7,112 reads
Learn about SQL Server without leaving your desk
SQL Server Central, with Pragmatic Works, is offering a new option in learning: high-quality training at a fraction of the usual cost with work absence slashed to zero. Our classes are done online with the same type of quality instructor you would receive from our private classes but done at your own desk. Even though you're doing the class online, the instructor can still hear you while you ask questions and optionally see your screen. Because the class is done in half-day increments, you also still have time to do your job.
2010-02-01
2,379 reads
Get SQL Server Training in the UK
Kalen Delaney has a series on internals and performance taking place in Hertfordshire soon. If you register today, you can still save 20%
2008-10-20
1,121 reads
Hands-on SQL Server from SQLSkills
In San Francisco, Kimberly Tripp and Paul Randal of SQLSkills will be presenting a two and a half day, hands-on workshop covering database infrastructure and scalability.
2008-09-11
2,440 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Forums
Split Large Queries in Athena with a Simple Modulo Trick
Comments posted to this topic are about the item Split Large Queries in Athena...
Finding Trailing Spaces
Comments posted to this topic are about the item Finding Trailing Spaces
Question of the Day
Finding Trailing Spaces
I have some data in a SQL Server 2025 database. It looks like this for the dbo.Customer table:
CustomerID CustomerName PreferredName 1 Steve Steve 2 Andy Andy 3 Brian Brian 4 Allan Allan 5 Devin Devin 6 Steve Steve 7 Sally SallyI want to detect which names have a single trailing space. The CustomerName is a varchar() and the PreferredName is a CHAR(). Does this query detect the problem rows?
SELECT
CustomerID,
CustomerName,
PreferredName
FROM Customer
WHERE CustomerName <> RTRIM(CustomerName)
OR PreferredName <> RTRIM(PreferredName); See possible answers