Data Analysis Without a Server
The ability to analyze lots of data on a workstation can be a way to test things without overloading server systems until you are sure your code works.
2020-08-25
136 reads
Hardware
2020-08-12
262 reads
2020-07-25
382 reads
Better Laptop Life
Intel is building hybrid processors, combining the power of the regular CPUs most of us use with Atom power saving technology.
2020-07-08
125 reads
Secure Enclave Concerns
A new security flaw in Intel SGX is found by researchers. This may or may not be a problem, but you should be aware.
2020-03-14
123 reads
Better Protection from Hardware
Today Steve looks at a research project from Microsoft that provides some better protection from firmware security issues.
2019-12-17
162 reads
2019-10-18
396 reads
Grounded
Some laptops are being banned from flights. This could be a hassle, but more, how can anyone tell if you have a banned one?
2019-08-29
418 reads
Lots of data in RAM
I remember buying my first computer after college. At the time I was working part time and in graduate studies part time. My aging high school era Apple II wasn't capable of handling the load, not to mention its 300baud modem wasn't a lot of fun. I could likely have gotten a faster modem with […]
2019-08-17
247 reads
Changing Hardware
AMD has new chips coming out and Glenn Berry changes his recommendation against using AMD in SQL Servers.
2019-07-20
192 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...
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...
Spending Time in the Office
Comments posted to this topic are about the item Spending Time in the Office
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