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,594 reads
I came across an issue today while trying to create a WMI alert for a mirroring state change. The error...
2013-08-15
1,594 reads
SQL Server 2014 CTP is available for download and evaluation and it contains a couple of exciting performance enhancements. One...
2013-07-08
2,535 reads
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,623 reads
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,061 reads
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,083 reads
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,131 reads
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,369 reads
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,425 reads
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,618 reads
A question that a DBA will often be asked is what databases are actively being used on my SQL Server?...
2012-10-17
3,388 reads
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Comments posted to this topic are about the item Going Native with Fabric Spark...
Which of these are valid OPENQUERY() uses?
See possible answers