Different Ways to Format Currency Output in SQL
In this tutorial, we will show different ways to output different currency formats with the T-SQL language.
Be Prepared
I've been reading about the fires in Maui and the horrible loss of life there. My heart goes out to all involved. I hope, if you can, you donate to a good charity to help those poor people. It also inspired me to do another check on our emergency supplies and equipment. No, we don't […]
Removing Weak Security from SQL Server
The password options for BACKUP at deprecated, which Steve thinks is a good thing.
Managing the challenge of migrating to the cloud
Migrating to the cloud has many advantages … until you’re the one tasked with making it happen. For many data professionals, this will be a first step from the traditional, predictable challenges of managing on-premises servers to the many and varied databases and platforms in the cloud.
Screen Scraping with Python and BeautifulSoup Code Examples
BeautifulSoup (sometimes referred to as Beautiful Soup library) is one of several widely used screen scraping packages for a web page. It is highly regarded for its ease of use and power.
Screen scraping enables developers to create solutions that permit comparative analyses from all over the internet, such as web applications that look for the best price on an item from many different online stores.
Spot the Five Differences and Win a Summit Ticket
Spot all five differences below and enter our prize draw competition to be in with a chance of winning a 3-day pass to PASS Data Community Summit 2023.
How to secure legacy ASP.NET MVC against Cross-Site (CSRF) Attacks
CSRF is when an attacker submits unauthorized commands to a website user already logged in. In layman’s terms, When you click on a malicious hyperlink, it triggers scripts that perform actions on your behalf to your logged-in bank website. Viola, the attackers, have your money.
Sessions for Summit 2023 are now LIVE!
The wait is finally over. This year’s PASS Data Community Summit sessions are now live!
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers