The INSERT statement in SQL Server is versatile. It now allows the insertion of multiple rows of literal values. It also provides the output clause that solves a number of common problems such as ascertaining the value of identity fields, and other calculated fields in tables, or for auditing the rows that are added to tables. Robert, once again, gives a clear introduction.
Today Steve Jones wraps up this week of editorial topics looking at women's issues with his own views on men and women in the workplace.
As a DBA, we often need a way to track what events are occurring (changes that are being made) on SQL Server or at the database level. So what is a way to track these changes without much impact on SQL Server performance?
Another weekend, another new city, another SQL Saturday. This was my first trip to Kansas City, and it was a...
Today we have a guest editorial from MVP Jessica Moss that talks about the gender differences in the workplace, and how you can work to get beyond them.
In this article Mohammad Meimandi explains an issue faced while using SQL-DMO to copy database objects.
Part 2 of the series on using MAP 5.0 looks at using the toolkit to inventory servers, preparing audit reports and server virtualization planning.
As I discussed in my first part of replication SQL Server 2008 Replication: High Availability Solution Part One, replication is...
Today we have a guest editorial from Jen McCown, one half of the Midnight DBAs. Jen wonders why we are still talking about women in technology? Women do the same jobs as men in this field.
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Comments posted to this topic are about the item The New Wave of Security...
Comments posted to this topic are about the item There's Too Much to Learn
Comments posted to this topic are about the item How to Calculate Distance Between...
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers