This isn't really a first look, per se. I've seen Erin Stellato present on this a few times in MVP sessions and at the PASS Data Community Summit. However, this is a look on my machine, where I'm in control. The new version preview was announced recently, and this looks at the new process to […]
Starting at 4pm PST on Thursday, November 28th, SQLskills will be offering our lowest prices ever for our signature Blackbelt bundle with more than 158 hours of top-quality training.
My last two months have been packed full of activity. I’ve had the amazing opportunity to be with PostgreSQL friends in New York, Greece, and Seattle. In between, it was a treat to be back in Pittsburgh for the first SQL Saturday since before the pandemic. The strength of the database community at each event […]
Bob Ward announces the next version of SQL Server, now in private preview.
There were a number of T-SQL functions added in SQL Server 2022. Today Steve asks if you are using any of these in your work.
BULK INSERT and BCP are powerful, high performance tools for importing text files. SQL Server MVP Jeff Moden gives us several nifty tips in this introduction to BULK INSERT and BCP Format Files including "Skipping Columns" and the sequestration of bad rows while still loading all the good data.
By now, pretty much everyone has heard the stories about the first computers. They were huge, cost a fortune, required incredible amounts of air conditioning, and perhaps more importantly, ran batch jobs submitted on punched cards and magnetic tape. But even before we had these dinosaurs, there were E.A.M (electric accounting machine) units.
There is no shortage of mundane tasks at work. Steve Jones notes that you might not want to depend on those to fill your day in the future.
Snowflake has its own CLI tool: SnowSQL. In this level of the Stairway Series learn how to work with this dialect in Snowflake and Visual Studio Code.
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
The post When is the perfect moment to build a data strategy in a...
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
I have a disagreement with the programming team on an app that I designed....
I have a table dbo.tblPresentationStatus (sql script attached - table script.txt) I have to...
We are planning to migrate our on-premises SQL Server to an AWS PostgreSQL database...
If I want to rename the OldSales database to ArchiveSales, how can I do this? (choose 2)
See possible answers