Using Out-GridView To Pick Parameters–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-01-18
664 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-01-18
664 reads
2017-01-18
1,231 reads
Many of our security issues come down to not patching software when there are updates available.
2017-01-17
125 reads
I got a tweet after my SQL Prompt formatting piece that said a user would be interested in upgrading from...
2017-01-17
541 reads
2017-01-17
958 reads
I’m hosting a new webinar on the DLM tools from Redgate Software and database DevOps. Tomorrow, Tues, Jan 17, at...
2017-01-16
600 reads
This week Steve Jones looks at hardware and the ways in which you might assemble a set of computers for building software.
2017-01-16
66 reads
Redgate produces some great software, and I’m glad that I get to use all of them as a developer and...
2017-01-16
501 reads
Making simple mistakes in queries can have far reaching consequences.
2017-01-16
181 reads
I was trying to get SQL Clone working recently and had an issue with the Agent. If you haven’t looked...
2017-01-13
648 reads
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
The Joyful Craftsmen has become the new owner of Revolt BI. The merger creates...
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
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