Do you have DBA syndrome?
Sometimes DBAs become resistant to change. When they lose focus on their full purpose they may have DBA syndrome.
Pattern Matching : More Fun When I Was a Kid
Aaron Bertrand runs some tests to challenge an assertion that CHARINDEX is always faster at pattern matching than LEFT and LIKE.
PowerShell Solutions - Working with files
When we administer a SQL Database, we always have to work with files. This new article shows how to handle them using PowerShell.
Questioning the Interviewer
Asking questions in an interview is important, but there can be issues. Steve Jones talks a little about how to approach this.
Managing SQL Server Backup and Restore History Information
Greg Larson explains that SQL Server provides a couple of different ways to delete backup and restore history. If you want to remove backup and restore information for all databases based on a date you can use the sp_delete_backuphistory system stored procedure. Or you can use the system stored procedure named sp_delete_database_backuphistory if you want to remove all backup and restore history for a specific database.
Coming Attacks
What happens if we can't access the Internet? We should be prepared, at home and work. Steve Jones has a few comments.
Constant Data Types
Data types are an important part of how tables and variables work. Did you know that constants have databases too?
Intelligence from Data
This week Steve Jones looks at the idea of using AI and machine learning with your data to develop amazing new insight.
Predicates With Subqueries
The ALL, SOME and ANY predicates aren't much used in SQL Server, but they are there. You can use the Exists() predicate instead but the logic is more contorted and difficult to read at a glance. Set-oriented predicates can greatly simplify the answering of many real-life business questions, so it is worth getting familiar with them. Joe Celko explains.
The Exciting World of Data
Steve Jones gave a keynote, and has a little fun this week with the topic of his talk.
Blogs
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Forums
cons for a dev machine in a different version of sql from our prod server
hi, im not a dba. For a couple of years our dev sql server...
Inquiry – Enforcing ApplicationIntent=ReadOnly via GPO
Hello, I would like to ask whether it is technically possible to redirect a...
Calculating Geometric Mean in Power BI
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers