TSQL Challenge 36 - Create a graph/Chart with TSQL
This challenge invites you to create a graph/chart using T-SQL
SQL Server restart validation checklist
Many times there is the need to restart the SQL Server services, this could be a reboot of the server after patching, service pack installation or due to some other reason. Sometimes we may face issues after the restart for example the SPN is not registered, a database is offline etc... For the solution you can use the below standard SQL Server validation checklist after you restart your SQL services.
Million Dollar Challenge, The Sequel
Red Gate Software is having another million dollar challenge. If you work for a small software company, or have a software product of your own, read about the challenge.
SQL Q&A: Shrinking, Growing and Redesigning Databases
SQL databases come in all shapes and sizes and schemas. This month, our SQL expert helps with condensing, growing and redesigning databases.
Vote For The PASS SQLRally Logo
Take a moment and vote on the new SQL Rally logo that will be used for the event next spring.
'Just Google It'
A short editorial explaining the pitfalls of using search engines as reference for DBA's.
Using T-SQL to Verify Tables Row Counts in Transactional Replication
This article will help you to use T-SQL to verify that the Subscribers have the same number of rows of replicated data as the Publisher in transactional replication
Migrating VLDB with Log Shipping
You just had a great weekend. You go grab your coffee and before you take a sip a manager grabs you and says, "we need your help." We need to migrate a very large database to our new data center. We need to keep the data in sync and have a short period of downtime when we cutover.
Counting Servers
Which big tech company has the most servers? It doesn't matter, but how you show the data can matter. Steve Jones talks about a skill data professionals should develop.
Creating Holidays and Special Dates
A way to save holiday records that can be created as needed into a search-able calendar table.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA KCP Surabaya CSTelpon : 0853-73737551
Jl. Surabaya No.88 B-C, Ps. Baru, Kec. Medan Kota, Kota Medan, Sumatera Utara 20212
BCA KCP Katamso Medan Telp/WA.0821°3111°179
Telp/WA.0821°3111°179 Jl. Brigjend Katamso No.56 B-C, A U R, Kec. Medan Maimun, Kota Medan,...
BCA KCP Pantai Indah Kapuk Telpon/wa.085373737699
BCA KCP Pantai Indah Kapuk Telpon/wa.085373737699.Jl. Pantai Indah Selatan Blok DF No.1 & 2,...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers