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,509 reads
Ctrl-alt-geek
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,525 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,503 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,036 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,065 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
5,892 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,235 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,413 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,613 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,131 reads
Blogs
A New Word: Immerensis
By Steve Jones
immerensis – n. the maddening inability to understand the reasons why someone loves you...
Deploy a Dockerized Python TODO App to Azure Container Apps Using Pulumi and Azure Key Vault
In this post, I will guide you on how to deploy a dockerized simple...
Using a Local Large Language Model (LLM): Running Ollama on Your Laptop
You can now run powerful LLMs like Llama 3.1 directly on your laptop using...
Forums
Connect with Corporate Gatekeepers through Executive Assistant Email List
In the fast-paced world of B2B marketing and corporate sales, one of the biggest...
Understanding CROSS APPLY and OUTER APPLY in SQL Server
Comments posted to this topic are about the item Understanding CROSS APPLY and OUTER...
Database Files on Shares I
Comments posted to this topic are about the item Database Files on Shares I
Question of the Day
Database Files on Shares I
I want to store database files on a file share for a SQL Server 2017 instance. Can I use \\fileserver\D$ as a location?
See possible answers