SQL in the City Goes Mobile
This week is the kickoff of the third year of SQL in the City from Red Gate. As we have...
2013-06-17
966 reads
Natural Born Killers (The series)
To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL...
2013-06-17
714 reads
Pivoting weird data in SSIS – Sort of…
Sometimes we get data in some bad forms. For example look at the below table:
The names and the amounts are...
2013-06-18 (first published: 2013-06-17)
2,082 reads
ORDER BY the numbers
Have you ever needed to order by a calculated column? You might have written it something like this:
SELECT LoginID, YEAR(HireDate)...
2013-06-19 (first published: 2013-06-17)
2,790 reads
Sql Server 2014…….What!!!
Yes, its true. Microsoft vice president has announce that new version of sql server 2014, will release on 2014… do...
2013-06-17
1,078 reads
PASS Data Architecture VC presents Steve Simon–Challenges Designing Finance Data Warehouse
Steve Simon will join us on Thursday June 20th at noon central to help us understand some challenges with designing...
2013-06-16
576 reads
Tracing Introduction
SQL Server tracing is essential for troubleshooting performance issues, yet it can put loads on your server that would cause...
2013-06-16
1,081 reads
Shifting of the Tides and my Career
Watching my career progression over the last year, an outside observer would think that I’m playing career path hop-scotch, or...
2013-06-15
552 reads
Reblog: June 7 to June 13
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-06-14
878 reads
Presentation Slides for Building an Effective Data Warehouse Architecture
Thanks to everyone who attended my session “Building an Effective Data Warehouse Architecture” for Pragmatic Works. There were over 500 attendees! The abstract...
2013-06-14
1,279 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Training the next generation
Comments posted to this topic are about the item Training the next generation
Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)
Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...
PostgreSQL psql Meta Commands: Databases
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers