The Problem with Users
Users cause lots of security issues, and we ought to try to work within that framework, with the understanding the we can't prevent all problems.
Worst Practices - Objects Not Owned by DBO
Last week Andy launched a new series about Worst Practices by talking about why the Hungarian naming convention is bad for column names. This week he's at it again, declaring that the practice of having objects owned by anyone other than dbo is BAD! Agree or disagree, we think you'll enjoy reading this article and adding your thoughts to the discussion!
Worst Practices - Part 1 of a Very Long Series!
Andy starts a new series about Worst Practices - come find out why and read about the first one on his list - using Hungarian Notation for column names!
3 ways Managed Services Providers can offer more value
Redgate's Will Sharman explores ways that database MSPs can save time, minimize effort and work more efficiently, while at the same time providing more value to their customers.
Polling and Survey Data Transparency
Polls and surveys are increasing in use. If you are a DBA, developer, or data scientist, then it is good to understand how to structure your systems for transparency and proper use.
Stairway to U-SQL Level 21: Exporting Data with Azure Data Factory
Learn how you can move data from your Data Lake to Azure SQL Database with Azure Data Factory.
Fill In Missing Dates for SQL Server Query Output
In this tip we look at how to fill gaps in dates and times for SQL Server query output when no data exists for specific dates or times.
SQL Change Automation Scripting: Getting Data into a Target Database
Your strategy for loading a freshly built database with data will depend on how much you need. If just a few rows, then single-row INSERT statements will be fine, but for more than that you'll need to build insert the rows using native-format BCP. Fortunately, SQL Change Automation (SCA) can be used with either strategy, as Phil Factor demonstrates.
Scaling SSRS Support for SQL Azure with Containers
In this article, see one of the ways in which a container can be created and used for in SSRS as the source for reports.
Working with People
One of the more important things that we can do as a professional is learn to work we well with others.
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
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
How to Calculate Distance Between Coordinates in SQL Server
Comments posted to this topic are about the item How to Calculate Distance Between...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers