SQL Saturday #161 - East Iowa
A free day of SQL training in Iowa City o Aug 11. Come meet other SQL Server professionals in the area.
Set Up Grouping Intervals for Excel (SQL Spackle)
So you want to group your data for charting in Excel? Here's how, the easy way!
The DBA Database
One very handy item Steve Jones found as a DBA was a DBA only database on each instance. Today he asks you if you have one and if not, why not. There are good reasons to have one, and security is usually not a problem.
Implement Continuous Integration In Your Software Project
Continuous integration, or CI, brings developers closer to delivering error-free software flawlessly. Find out how to implement it.
Better Bosses Needed
These days it seems there's no shortage of bad managers out there. However the bad ones do more than hurt morale, they actually can impact productivity. Steve Jones wonders why companies don't do more to fix this.
Don't Share Passwords Across Sites
There is a rippling effect from the hack on Yahoo. Those users and passwords are being used on other sites. Steve Jones reminds us that we shouldn't be sharing passwords, and we should educate our users to do the same thing.
Track source dates when loading a data warehouse
A primer on how to reduce network and source system load when reading a relational source into the data warehouse.
An Introduction to SQL Server Service Broker
Service Broker is a technology built into SQL Server and utilized by the engine for its internal asynchronous processing. The great thing about Service Broker is that its functionality is exposed so we can build our own custom data integrations. Deanna Dicken introduces you to the concepts needed to create a service broker integration.
Performance Data
Great DBAs collect all kinds of metrics on their instances and let them manage themselves. However many administrators need help monitoring and interpreting the data. Today Steve Jones asks if you think this data needs extra security or is it less of an issue than other PII data.
Summarizing Imported Data
This article shows a few simple techniques to summarize table data using T-SQL.
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 Arundina Cibubur Hubungi Cs.0851•8812•0691
BCA KCP Arundina Cibubur Hubungi Cs.0851•8812•0691 Blk BA, Jl. Cibubur Indah Jl. Pangkuan. Tembak...
BCA KCU MANGGA DUA RAYA CS.Tlpn/wa0853.7373-7551
Tlpn/wa0853.7373-7551 Jl. Mangga Dua Raya Jalan Kavling No.1 Blok C-5, RT.11/RW.5, Ancol, Kec. Pademangan,...
BCA KCP Tebet Timur Tlp/WA.(+62 821°3111°179
Tlp/WA.(+62 821°3111°179 Jl. Tebet Timur Dalam Raya Blok GG No. 97, Tebet Tim., Kec....
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers