Introduction to SQL Server sequence objects
SQL Server sequence objects can be used in place of identity columns. In this article, Greg Larsen explains how to set up and use sequence objects.
2021-11-17
Additional Articles
SQL Server Database Stuck in Restoring Stat
In this tip we look at different reasons why a SQL Server database will be in a restoring state and things that can be done to access the database.
2021-11-15
What we learned at PASS Data Community Summit
Join Steve Jones, Kathi Kellenberger and Grant Fritchey as they each reveal their highlights, learnings and key takeaways from their 2021 Summit experience.
2021-11-15
DBAs at work #1: The IT services provider DBA
Our series of ‘DBAs at work’ blog posts feature conversations with IT leaders and experts about the challenges of managing and monitoring their server estates. Episode 1 features Dennis Heitmann, Database Administrator at Atruvia, which provides IT services for banking clients in Germany.
2021-11-12
1,015 reads
Performance of querying blob storage with SQL
It’s possible to query blob storage using SQL, but what about performance? In this article, Dennes Torres compares several query methods to see which one performs the best.
2021-11-12
Handling an unknown number of parameters in SQL Server
In this article we compare performance differences when splitting comma separated strings using TVPs, TVFs, openjson, string_split and more.
2021-11-10
Managing Database Documentation during Flyway-based Development
Learn how to create and maintain a 'data dictionary' for your databases, in JSON format, which you can then use to add and update the table descriptions, whenever you build a new version using Flyway.
2021-11-10
State of Database Monitoring Report 3
Database professionals are spending 1/3 of their time on security tasks each day and say it’s their biggest professional challenge this year. Learn how 2500+ database professionals are reacting to these unprecedented demands in our third database monitoring insights report.
2021-11-08
Text Mining and Sentiment Analysis: Data Visualization in Tableau
Tableau is a popular visualization tool used by organizations around the world. In this article Sanil Mhatre demonstrates sentiment analysis with Tableau and Oracle data.
2021-11-08
Cosmos DB Data Migration Between Containers using Databricks and PySpark
In this article learn how to use PySpark scripts in Azure Databricks service to copy data between Cosmos DB containers.
2021-11-05
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Alamat BCA KCP Sambas Telp Cs 0817781222
WhatsApp:0817781222 Jl. Gusti Hamzah No.85, RT.02/RW.01, Pendawan, Kec. Sambas, Kabupaten Sambas, Kalimantan Barat 79465
Alamat BCA KCP Antasari Telp Cs 0817781222
WhatsApp:0817781222 Jl. P Antasari No.21, Tlk. Lerong Ulu, Kec. Sungai Kunjang, Kota Samarinda, Kalimantan...
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers