Database Fundamentals #7: Create a Table Using T-SQL
The syntax for creating a table logically follows many of the same steps that you did when using the GUI,...
2017-08-07
282 reads
The Scary DBA
Database Fundamentals #7: Create a Table Using T-SQL
The syntax for creating a table logically follows many of the same steps that you did when using the GUI,...
2017-08-07
181 reads
There Is a Magic Button, a Rant
OK guys. I think it’s way past time. A bunch of us have been keeping a secret from the rest...
2017-08-01
478 reads
There Is a Magic Button, a Rant
OK guys. I think it’s way past time. A bunch of us have been keeping a secret from the rest...
2017-08-01
221 reads
Being a Positive Influencer
I read a lot of self-help and improvement information. I’m always trying to hack my brain or my attitude to...
2017-08-18 (first published: 2017-07-31)
1,912 reads
Being a Positive Influencer
I read a lot of self-help and improvement information. I’m always trying to hack my brain or my attitude to...
2017-07-31
351 reads
Database Fundamentals #6: Create a Table with the SSMS GUI
The whole idea behind databases is to store information, data, in order to look at it later. The place where...
2017-07-24
527 reads
SQL Cruise: Alaska 2017
We’re weeks away from another SQL Cruise. If you’ve never heard of this before, follow the link to read more....
2017-08-01 (first published: 2017-07-19)
1,785 reads
Thoughts on the State of Data Management
I was given the opportunity to do a little online interview. It’s primarily about promotion, but I thought I’d share...
2017-07-18
299 reads
Database Fundamentals #5: Database Properties
Don’t let the ease of creating databases lull you into a false sense of security. They actually can be very...
2017-07-31 (first published: 2017-07-17)
2,267 reads
Blogs
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Forums
Windows logins for users migrated from DomainA to DomainB
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers