25 Years of Redgate
I’m in Austin today, ready for the Redgate Software 25th Birthday celebration. The company started in 1999 and this is their 25th birthday. All of our offices are celebrating,...
2024-07-17
69 reads
I’m in Austin today, ready for the Redgate Software 25th Birthday celebration. The company started in 1999 and this is their 25th birthday. All of our offices are celebrating,...
2024-07-17
69 reads
Microsoft Copilot is an app that uses AI to help you find information, create content, and get things done faster (see What Is Copilot? Microsoft’s AI Assistant Explained). Copilot is...
2024-07-17 (first published: 2024-07-10)
499 reads
Are you ready to take your SQL skills from theoretical to tactical? If you've been yearning for a risk-free environment to test, experiment, and refine your SQL queries against...
2024-07-17 (first published: 2024-07-06)
371 reads
I’ve been to quite a few of the SQL Saturday Baton Rouge events. There have been 10 with the 11th coming in a couple weeks. The crew down there...
2024-07-17
17 reads
The post Jan Vaněk: Na podpis smlouvy jsem přišel v kiltu a teď vedu SWAT tým appeared first on Joyful Craftsmen.
2024-07-16
35 reads
2024-07-16
22 reads
I love QuickieStore, but I wanted some columns to be at the front end of the results returned. Namely, I wanted top_waits, query_sql_text, and query_plan right after database name....
2024-07-15 (first published: 2024-07-03)
307 reads
I recently received a complaint that Query Store for a particular database was turned off, which was strange as that particular database has seen quite a few performance issues...
2024-07-15 (first published: 2024-07-04)
710 reads
Working with SQL Server over the past 25 years for various organizations all over the world, I usually always find a database server that is well outside of support....
2024-07-15
43 reads
fitching – v. intr. compulsively turning away from works of art you find frustratingly, nauseatingly good – wanting to shut off the film and leave the theater, or devour...
2024-07-12
34 reads
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Comments posted to this topic are about the item Spending Time in the Office
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