Quick tip: Using DBCC SQLPERF(‘LogSpace’)
A lot of a DBA’s time is spent managing and investigating transaction log files.
A commonly used tool is the command:
DBCC...
2012-09-10
2,794 reads
Following good practice saves wasted time down the line.
TweetG’day,
Sometimes I come across what I call unusual coding practices. Developers usually have pressure on them to deliver and this...
2012-09-12 (first published: 2012-09-10)
2,394 reads
EXECUTE AS USER = ‘Somebody else’
As a database administrator I get lots of security requests. “Please grant me read authority on this table, write on that table,...
2012-09-10
748 reads
Change file logical name for mirror database
Today I encountered a interesting issue when rename logical name for mirror database.
We have a database which has been setup...
2012-09-14 (first published: 2012-09-09)
3,080 reads
Upcoming Fall Events
During September/October I’ll be presenting at several in-person events:
Tampa IT Pro Camp
Join system administrators and IT professionals for the Tampa...
2012-09-09
1,143 reads
SQLSaturday Metrics
A recent article in the PASS Connector called out some interesting stats about SQLSaturday for 2011 and 2012. I’m including...
2012-09-09
703 reads
SQL Server:Output Clause
Couple of days back, one of my colleague came to me asking for help. He is inserting multiple record from a...
2012-09-09
1,502 reads
SQL Saturday 162
SQL Saturday 162 was a great event, kudos to the team involved and I took a lot of pleasure in...
2012-09-09
754 reads
Reading Reviews, Ordering a Laptop, and Lenovo
Since earlier this year I’ve been thinking to replace my aging but still useful laptop, mostly to get something lighter,...
2012-09-13 (first published: 2012-09-08)
1,880 reads
5 Performance Killers When Working With Linked Servers
When working with linked servers, the most expensive factor to consider is the amount of data that will have to...
2012-09-08
579 reads
Blogs
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Forums
RegEx Functions III
Comments posted to this topic are about the item RegEx Functions III
Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Finely Tuned Models
Comments posted to this topic are about the item Finely Tuned Models
Question of the Day
RegEx Functions III
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers