Teaching and Learning
You learn a lot when teaching someone else, whether that be writing articles or books or actually teaching a class....
2009-12-23
663 reads
Kathi Kellenberger
- Interests: Walking, running, grandchildren!
Introduction to Common Table Expressions
Learn how to use common table expressions to simplify your code. Replace temp tables and correlated subqueries with this cool T-SQL feature.
2009-12-08
15,226 reads
Back Home after PASS 2009
I got home Friday evening after spending several days in Seattle at PASS 2009. This was my seventh PASS Summit...
2009-11-08
435 reads
SQL Server 2008 cluster install and slipstreaming!
I was asked to set up a SQL Server 2008 cluster on Windows 2008 R2 this past week. One interesting...
2009-10-31
2,125 reads
Beginning T-SQL 2008
My book "Beginning T-SQL 2008" came out about two weeks ago. http://www.amazon.com/Beginning-T-SQL-2008-Kathi-Kellenberger/dp/1430224614/ref=sr_1_1?ie=UTF8&s=books&qid=1256604424&sr=8-1 It's a beginning book because I assume that the...
2009-10-26
793 reads
Thanks, Brian!
This past Tuesday, Brian Knight visited the St. Louis SQL Server User Group to present on SSIS. The day ended...
2009-06-14
559 reads
Submit your PASS abstracts now!
Hey, there are probably some other blogs here letting you know that the PASS call for speakers is open right...
2009-03-30
1,343 reads
Tagged again
Once again I was tagged to answer a question. This time by Chris Shaw http://chrisshaw.wordpress.com .
Here is the question: Do...
2009-03-05
575 reads
Chain Blog from Tom LaRock
I have been tagged by Tom LaRock to write about “what was your first computer and what were some of...
2009-02-19
427 reads
St. Louis Day of .Net
Yesterday I spoke on 2008 T-SQL and Data Types at the St. Louis Day of .Net event. This was an...
2008-12-14
420 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...
BCA KCU RAWAMANGUN Tlp,Cs:0821-8154-393
WA:08218154393 Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta Timur, Daerah Khusus...
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