Learn Spark SQL Date and Time Functions
This article covers how to use the different date and time functions when working with Spark SQL.
2023-12-08
Additional Articles
Cardinality Estimation Feedback in SQL Server 2022
Cardinality estimation (CE) is a process used by the query optimizer to estimate the number of rows returned by a query or sub-part of a query. These estimates rely on two underlying things: statistics about the data and a set of assumptions—known as the model.
2023-12-06
Plansplaining, part 20. SQL Graph (part 1)
Welcome to part twenty of the plansplaining series. It has been a long time since I last wrote a plansplaining post, partly because of my health, but also for a large part because I was out of ideas. But recently I decided to dig a bit deeper into a feature that was released in SQL Server 2017 and that I had so far not played with: SQL Graph.
2023-12-06
Championing DevOps: A Panel Webinar
If you aspire to drive Database DevOps at your company, regardless of the sector you work in, this webinar provides a unique opportunity to learn from experts in the finance sector who have successfully paved the way. Join us December 6th.
2023-12-04
PowerShell Commands to Administer Virtual Machines on Amazon AWS - Part 2
Learn about various PowerShell commands that can be used to administer virtual machines on Amazon AWS.
2023-12-04
Accelerated Database Recovery enhancements in SQL Server 2022
We are excited to share that there are several Accelerated Database Recovery enhancements in SQL Server 2022.
2023-12-01
Why Haven’t You Disabled SA? Wrong Answers Only.
On social media, I asked folks, “Why haven’t you disabled the SA account in your SQL Servers? Wrong answers only.” The results were pretty funny:
2023-12-01
TABLOCK Hint can Negatively Impact SQL Server Concurrency
In this article, we look at how using the Tablock hint in SQL Server could impact concurrency and block other sessions.
2023-11-29
Working with Azure DocumentDB: SQL & NoSQL Together
Updating and deleting documents, creating queries, and managing query results in Microsoft's new NoSQL database-as-a-service.
2023-11-29
Time Series Data Mining Example with T-SQL when Adding New Data
Learn about working with time series data using T-SQL code and how to add additional data to the data set for more in-depth data mining.
2023-11-27
Blogs
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Forums
reaching ftp thru winscp but erroring in ssis ftp task connection
Hi, below i show various results trying to reach our ftp site (a globalscape...
Finding Motivation
Comments posted to this topic are about the item Finding Motivation
The Last Binary Value of the Year
Comments posted to this topic are about the item The Last Binary Value of...
Question of the Day
The Last Binary Value of the Year
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers