Stairway to Advanced T-SQL Crossword
This crossword puzzle is based on the contents of the Stairway to Advanced T-SQL.
SQL Server Graph Databases – Part 3: Modifying Data in a Graph Database
Modifying data in Graph Database tables is similar to working with traditional tables, but there are several things to consider. Robert Sheldon explains how to insert, update, and delete rows of Graph Database tables and explains how to use several new helper functions.
Cloud Snake Oil
The Cloud isn't always what it seems and Steve notes that paying attention to finances might be the most important thing.
Packaged-Application Database Nightmares - A Horror Story
The business decides on a packaged application and buys it. After installation, you look at the schema and realize that is is a nightmare. How do you manage this nightmare?
Alerts and Notfications for SQL Server Login, Database User and Role Membership Changes
Check out these scripts to create SQL Server jobs and Alerts when a login is created or dropped, a database user is added or dropped and when logins are added or removed from server roles or users are added or removed from database roles.
Spring into the Latest Features at the Luxemborg User Group
The next meeting of the Luxemborg SQL Server User Group has some great sessions planned.
SQL Community
Back in my early days as a database administrator, almost 16 years ago, I happened upon a web site called SQL Server Central. Because I found so many useful articles and forum posts, the site was open in my browser at work every single day. It was a great source of information, and eventually, I […]
How to Programmatically Identify When Your SQL Server Was Last Started
Greg Larsen shows you a quick trick to programmatically script a way to identify when SQL Server was last started.
Keep It All
We could use more intelligence in our backup systems, since we don't need to keep all those files.
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
What Did Healthy Look Like?
Comments posted to this topic are about the item What Did Healthy Look Like?
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers