Cleaning up Query Store data after database restore
Query Store is a very powerful tool for performance tuning, if you are not using it already you should!! It...
2018-08-29 (first published: 2018-08-13)
2,056 reads
DBA Mastery
Enable SQLCMD Mode on SSMS
I really like Microsoft philosophy nowadays, they are putting a lot of time developing good open source tools like SQLCLI,...
2018-08-10 (first published: 2018-08-07)
3,458 reads
First time speaker at Denver’s SQL local group
06/21 was the date that marked my career as data professional, for the first time ever I decided to participate as...
2018-08-01
233 reads
Is your SQL Server environment ready for GDPR? Part 1
Unless you have been living under a rock lately, you have not heard about GDPR. This has been hot topic...
2018-05-25
124 reads
SQL Vulnerability Assessment
Vulnerability assessment is probably one of the most underrated new security features in SSMS 17. This feature is not new...
2018-05-21
129 reads
Reviewing the SQL Server ERROR log
The SQL Server ERROR log is the best source to understand what’s wrong with your SQL Server instance, think this...
2018-05-10
102 reads
ITIL certification for DBAs – Part 2
In my previous post I did my best explain a little bit what ITIL is and how important is for...
2018-04-13
215 reads
ITIL certification for DBAs – Part 1
In some point of your career as DBA you might have interacted with ITIL or at least your heard about...
2018-04-13
233 reads
SQL Saturday #695 Guatemala
This is probably a very delayed post, but I have been really busy lately.
As mentioned in my previous post, I...
2018-03-23
97 reads
Speaker at SQL Saturday’s Guatemala city 2018
I’m very thrilled to announce that I will be participating as speaker in this year’s SQL Saturday event in Guatemala city!
Here...
2018-01-04
92 reads
Blogs
SQL Server Logins vs. Users: Why You Really Need to Know the Difference
By Kevin3NF
The Two-Layer Model Explained “We added them to the database, but they still can’t...
Using AI to Test a SQL Query
By Steve Jones
Someone sent me this code. WITH p AS ( SELECT ID, ROW_NUMBER() OVER (ORDER...
Your SQL Starting Line: Best Free Databases for Beginners
Wondering which database to tackle first? I’ve got the lowdown on the top free...
Forums
can ssrs detect rls and cls thru proxy like user ids?
Hi we often use non expiring windows and sql accounts to actually run (credential...
Changing the Paradigm of Work
Comments posted to this topic are about the item Changing the Paradigm of Work
Removing a File
Comments posted to this topic are about the item Removing a File
Question of the Day
Removing a File
I attempted to use ALTER DATABASE to remove a file from my filegroup in SQL Server 2022. There are 4 files in this filegroup, but I don't need them all. However, I received a message that the file was not empty. How do I empty this file so it can be removed?
See possible answers