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,804 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,192 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,778 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,470 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,700 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,745 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
Prime Day Recommendations
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
Fabric for Operational Reporting & SQL Endpoint Trap
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
Crawl, Walk, Run with Agentic Development of Power BI Assets
If you’ve been watching AI roll through the data community and thinking, “this seems...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat Kontak BCA KCP Comal Tlp,Cs:0821-8154-393
WA:08218154393 Grand Comal Residence, Jl. Raya Ahmad Yani No.20 Blok EA A19, Dusun II,...
Concurrency and Baseline Control: Level 5 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Question of the Day
Multiple Values Inserted
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers