SQL Server Management Studio Tips
A complete guide to the hidden gems of SQL Server Management Studio (SSMS), covering shortcuts, tips and tricks, useful scripts, and more.
SQL Server Security: Fixed Database Roles
Brian is back with a new security article, this time working through the details of the fixed database roles. There are some important concepts here. In particular if you're not totally clear on the difference between dbo and db_owner, read this article.
The Difference between Truncate and Delete in SQL Server
This article explains the differences between the Truncate and Delete commands in SQL Server.
Backup Techniques Available Exclusively When Using Azure VMs
Learn backup techniques available exclusively when using Azure VMs to host SQL Server-based workloads.
What You Should Know About Coding
Today Steve thinks about the skills and approach we ought to be taught before we start building software as a career.
Partitioning Data in SQL Server without using Partitioned Tables
In this we look at how we to quickly split up data from a SQL Server table into relatively equal size buckets.
SQL Server 2019 Graph Database and SHORTEST_PATH
With SQL Server 2019 on the way, it’s time to begin learning about all the new features. In this article, Dennes Torres demonstrates how to use the new SHORTEST_PATH function that is part of the Graph Database feature.
Managing SQL Server containers using Docker SDK for Python - Part 2
There are multiple ways to interact with the Docker daemon, as command line client API or GUI based tools like Kitematic. Docker also provides a SDK for Go and Python, this SDK can be used to create and manage Docker containers the same way it works with the Docker engine API.
The Crazy Times of Year
Do you have busy times of the year that recur regularly? In some positions I've held, we had certain events or processes that always caused additional stress and headaches for employees. As a bartender, certain holidays (New Years, Halloween) were extra crazy. In one company, every quarter was an adventure involving a late, or a […]
Working with React Components
The React library allows teams to work faster and with more consistency. In this article, Camilo Reyes explains how to get started using React components in a C# application
Blogs
Reading SQL Server File Headers with DBCC FILEHEADER
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
OpenClaw- Agentic Engineering
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Forums
Rethinking How We Approach Assignment Help
Assignments aren’t just tasks to submit—they’re opportunities to build understanding, discipline, and problem-solving skills....
What's new in R 4.6
Comments posted to this topic are about the item What's new in R 4.6
Interesting Changes in R
Comments posted to this topic are about the item Interesting Changes in R, which...
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers