Changes are Coming to the SQLServerCentral Forums
SQLServerCentral is getting an upgrade, and Steve Jones has a few words.
2017-01-09
142 reads
SQLServerCentral is getting an upgrade, and Steve Jones has a few words.
2017-01-09
142 reads
It’s a new year, and the perfect time for you to start blogging about your SQL Server work. I think...
2017-01-09
732 reads
I ran across Chocolatey years ago when Scott Hanselman wrote about it in his power tool list. At the time,...
2017-01-09 (first published: 2017-01-02)
3,220 reads
2017-01-09
1,777 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-01-06 (first published: 2016-12-29)
1,836 reads
2017-01-06
96 reads
2017-01-06
1,097 reads
Numbers are both very useful and also susceptible to all sorts of attacks when their domain is limited. Steve Jones looks at some issues occurring in today's world.
2017-01-04
112 reads
One of the things that I often do is create stored procedures. The syntax for doing so is simple, but...
2017-01-04
512 reads
I was rehearsing a demo with someone recently and we had some stored procedure code that looked like this:
CREATE PROCEDURE...
2017-01-03
3,750 reads
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
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...
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