Quick tip: WMI alerts and SQL Server Agent permissions.
I came across an issue today while trying to create a WMI alert for a mirroring state change. The error...
2013-08-15
1,617 reads
Matt
In Memory OLTP with SQL Server 2014
SQL Server 2014 CTP is available for download and evaluation and it contains a couple of exciting performance enhancements. One...
2013-07-08
2,565 reads
Wildcards and Indexes
I was asked a good question the other day, one that I wasn’t sure of the answer. The question was...
2013-05-22
1,750 reads
Quick tip: Using sp_server_diagnostics
In SQL Server 2012 a new procedure sp_server_diagnostics returns a payload of information about server health and performance. The sproc...
2013-04-11 (first published: 2013-04-03)
4,084 reads
SQL Server 2008 Statistics: What does a DBA need to know?
I’ve been looking into the behaviour of statistics in SQL Server 2008 – so I’d like to present an overview from...
2013-02-20 (first published: 2013-02-14)
7,126 reads
Restore database permissions
Introduction:
I came across a couple of subtle gotchas around the permissions required to restore a database in SQL Server 2008+...
2013-01-10
6,403 reads
Migrating SQL Server Databases that use Database Master Keys
There’s a lot of things to consider when migrating databases between SQL Server instances. I want to provide some tips...
2012-11-26 (first published: 2012-11-13)
4,443 reads
Don’t believe everything you read: Truncate table is not logged
Actually I’m not sure if anyone still believes this anymore. If you read the BOL description carefully it states that...
2012-11-02 (first published: 2012-10-31)
4,451 reads
Quick tip: Count table rows in a database, and locate those rows in the data files.
Here are a couple of quick database and table level queries that I have found useful lately.
How many rows in...
2012-10-30
1,632 reads
Querying database usage
A question that a DBA will often be asked is what databases are actively being used on my SQL Server?...
2012-10-17
3,603 reads
Blogs
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Why companies use Palantir and how we help implement it in the Czech Republic
Palantir is an American software platform that brings together business data from different sources...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Kantor Batik Air Surabaya | Telp.08557033334
Hub Admin Batik Air Telp/wa 08557033334 Jl. Jaksa Agung Suprapto No.5, RT.002/RW.08, Ketabang, Kec....
Kantor Batik Air Yogyakarta | Telp.08557033334
Hub Admin Batik Air Telp/wa 08557033334 Jl. Laksda Adi Sutjipto Km. 7, Flyover, Janti,...
Question of the Day
SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers