A Story of the Deleted Transaction Log
James DiMauro brings us a story of how a transaction log was deleted and then recreated. (from July 2008)
James DiMauro brings us a story of how a transaction log was deleted and then recreated. (from July 2008)
This Friday's poll asks you about having a fair set of benefits for extra time work. Steve Jones wants to know how your employer treats you.
This Friday's poll asks you about having a fair set of benefits for extra time work. Steve Jones wants to know how your employer treats you.
This Friday's poll asks you about having a fair set of benefits for extra time work. Steve Jones wants to know how your employer treats you.
This Friday's poll asks you about having a fair set of benefits for extra time work. Steve Jones wants to know how your employer treats you.
Many famous geeks work away at their programs without considering the wider implications of what they, and others, are doing. Richard Stallman isn't like that. Richard (rms) is one of the great brains behind Linux distros, as he wrote the GNU compilers and GNU debugger. He is driven by strong opinions about the nature of free software, and the restrictive nature of software copyright. We sent our intrepid reporter, Richard Morris, to find out if Richard Stallman really required journalists to read parts of the GNU philosophy before an interview, for "efficiency's sake".
Tim Mitchell presented at SQLSaturday #17 on Scripting in SSIS. I thought it was a really interesting presentation, and I’m...
Architect Bill Pearson leads the hands-on creation of a simple doughnut chart based upon an Analysis Services data source.
This article would help to solve a strange error dealing with compatibility issue while using CROSS APPLY
If you have trouble connecting to a busy server, you'll want to watch this installment of SQL School. MVP Andy Warren shows how you can use the dedicated administrator connection (DAC) in SQL Server 2005 and above.
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...
If you’ve been watching AI roll through the data community and thinking, “this seems...
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