TSQL Challenge 36 - Create a graph/Chart with TSQL
This challenge invites you to create a graph/chart using T-SQL
2010-08-09
3,795 reads
Press Release
Million Dollar Challenge, The Sequel
Red Gate Software is having another million dollar challenge. If you work for a small software company, or have a software product of your own, read about the challenge.
2010-08-06
4,013 reads
Vote For The PASS SQLRally Logo
Take a moment and vote on the new SQL Rally logo that will be used for the event next spring.
2010-08-06
1,762 reads
Parallelism and Performance: Are You Getting Full Return on Your CPU Investment?
A webinar from the PASS Performance VC on Aug 3, 2010
2010-08-02
3,190 reads
Top Ten Reasons to Attend the 2010 PASS Community Summit
There are some good reasons to think about attending the 2010 PASS Community Summit.
2010-07-26 (first published: 2010-02-25)
3,777 reads
TSQL Challenge 35 - Find the total number of 'Full Attendees' in 24HOP
This challenge has a (fake) reference to the 24 Hours of PASS event and your task is to count the number of attendees who watched the complete presentation of each speaker.
2010-07-26
1,467 reads
TSQL Challenge 34-Search for two keywords within the maximum distance
This challenge is all about searching for two keywords in a string with a maximum distance of 'one word' between them.
2010-07-12
1,691 reads
Performance Impacts Related to Different Function Types
The July 2010 PASS Performance VC Presentation by Jason Strate on July 6th 12:00 PM EDT (GMT -4).
2010-07-06 (first published: 2010-07-01)
3,237 reads
Come Vacation on the SQL Cruise
This fall you have the chance to learn from a number of SQL Server experts and get a little vacation at the same time on a SQL Cruise.
2010-06-30
1,744 reads
TSQL Challenge 33 - Calculate list of bookings fully paid on the book
This problem is related to a reservation system where customers book a service and pay it in one or more transactions which may happen on different dates.
2010-06-28
1,598 reads
Blogs
The First Steps: Understanding the Basics of FinOps
By HeyMo0sh
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...
Monday Monitor Tips: AI Query Analysis
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
Forums
would it be so terrible to install ssms on a few user desktops?
Hi, ssms is free here. I can think of other reasons to do this...
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers