Search this blog
The Current Book – Do Hard Things
MVP Award
Tags
- administration
- AI
- auditing
- Azure
- backup
- Backup/Recovery
- blogging
- business
- career
- career2
- car update
- Cloud Computing
- conferences
- containers
- continuous delivery
- continuous integration
- coping
- data
- data analysis
- database design
- databases
- Database Weekly
- data privacy
- dbatools
- DevOps
- disaster recovery
- DLM
- encryption
- Friday Poll
- GDPR
- Git
- goals
- hardware
- high availability
- Humor
- life
- Linux
- machine learning
- mcm
- Microsoft
- misc
- monitoring
- networking
- NoSQL
- PASS
- Performance
- powershell
- presentations
- Redgate
- republish
- sabbatical
- security
- software development
- software development
- speaking
- SQL Compare
- SQL in the City
- SQLNewBlogger
- SQL Prompt
- SQL Saturday
- sql server
- SQLServerCentral
- SSMS
- syndicated
- T-SQL
- T-SQL Tuesday
- Tesla
- testing
- travel
- tsqlt
- vacation
- version control
- webinar
- windows
- work
Search this blog
Steve’s Tweets
- @sqlmal Thanks 1 hour ago
- Has SQL Server Performance Improved? voiceofthedba.com/2023/04/01/has… 5 hours ago
- RT @Hugo_Kornelis: I just blogged, with an update on my Pluralsight course on Relational Database Design: sqlserverfast.com/blog/hugo/2023… 22 hours ago
- A Woman in SQL 2023 debthedba.wordpress.com/2023/03/31/a-w… via @dgmelkin 22 hours ago
- Interesting to see multiple ChatGPT or CoPilot articles on our internal site in the last couple weeks. I am going t… twitter.com/i/web/status/1… 23 hours ago
- @leila_etaati Glad you are doing better. Best of luck improving and looking forward to meeting again somewhere. 23 hours ago
- RT @jaxssug: Just over 24 hours left until Speaker Call closes for #SQLSatJax #SQLSaturday! If you still need to submit your sessions, go t… 1 day ago
- Nice to see more pictures of the new @redgate office. Can't wait to visit: Redgate’s new Cambridge HQ oozes high-cl… twitter.com/i/web/status/1… 1 day ago
- administration
- AI
- auditing
- Azure
- backup
- Backup/Recovery
- blogging
- business
- career
- career2
- car update
- Cloud Computing
- conferences
- containers
- continuous delivery
- continuous integration
- coping
- data
- data analysis
- database design
- databases
- Database Weekly
- data privacy
- dbatools
- DevOps
- disaster recovery
- DLM
- encryption
- Friday Poll
- GDPR
- Git
- goals
- hardware
- high availability
- Humor
- life
- Linux
- machine learning
- mcm
- Microsoft
- misc
- monitoring
- networking
- NoSQL
- PASS
- Performance
- powershell
- presentations
- Redgate
- republish
- sabbatical
- security
- software development
- software development
- speaking
- SQL Compare
- SQL in the City
- SQLNewBlogger
- SQL Prompt
- SQL Saturday
- sql server
- SQLServerCentral
- SSMS
- syndicated
- T-SQL
- T-SQL Tuesday
- Tesla
- testing
- travel
- tsqlt
- vacation
- version control
- webinar
- windows
- work
Older Posts
Meta
Tag Archives: sql server
Has SQL Server Performance Improved?
I saw a very interesting blog post this week from Brent Ozar that asked if SQL Server 2019 More CPU-Intensive Than SQL Server 2016? You can read the post, but a client was having CPU issues and thought everything between … Continue reading
Capturing Data Changes
While working with a customer recently, I saw some code from them that used the OUTPUT and INTO clauses of an UPDATE statement to capture the changes made into another table. In this case, as users updated code strings in … Continue reading
Nested Transactions
One of the very common expectations from many SQL developers involves transactions. Many developers (database or application developers) think they can open a transaction, do something, open an inner transaction (nested), and then commit or rollback the inner transaction separate … Continue reading
The Top SQL Server Engine Errors
For many of us, SQL Server just works. We might get some syntax errors if we mistype things, but for the most part, SQL Server runs smoothly in many environments. However, there are some common situations that do occur regularly, … Continue reading