How to move the MSDB database
First we need to know the name and file location of the MSDB database files. When you change the location, make...
2011-07-13
961 reads
Blog Posts
Make It Simple With Policy-Based Management
At work recently, I explained to a coworker the reasons and benefits of having databases in Simple mode in your...
2011-07-13
958 reads
Simple Database User-Access Security Validation & Granting Elevated Access Temporarily Using the Execute As Statement
If you ever want to validate what level of access a user has within a database OR wish to temporarily...
2011-07-13
1,125 reads
SQL Server Codename “Denali” CTP3 Resources
SQL Server codename “Denali” CTP3 has been released to the public after much anticipation. You may ask yourself, “What happened...
2011-07-13
2,758 reads
SSIS package taking forever to load when you open it?
When you open a SQL Server Integration Services (SSIS) package in SSIS Designer or add components to a package, SSIS...
2011-07-13
2,592 reads
SSSOL July 2011 Reminder
This is just a quick note to remind anybody who may be interested of the upcoming Las Vegas User Group meeting. As I posted here, we will be learning...
2011-07-13
10 reads
SSSOL July 2011 Reminder
This is just a quick note to remind anybody who may be interested of the upcoming Las Vegas User Group...
2011-07-13
605 reads
We have a new contributor…
In order to keep the content fresh and the posts flowing here on my blog I have decided to publish...
2011-07-13
596 reads
Automating Web App Deployments with SSIS
This is just a quick note to let everyone know I’ve uploaded the project files from my Pragmatic Works webinar...
2011-07-12
618 reads
Copying parent-child rows and SQL Dependency Tracker
I was facing quite well-known issue today – I had to develop logic of duplicating (versioning) parent-child records. Because I was...
2011-07-12
2,130 reads
Blogs
SQL Server gMSA: Why So Many DBAs Still Aren't Using It in 2026
By SQLPals
SQL Server gMSA: Why DBAs Still Aren't Using It in 2026 ...
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Forums
Fulltext filter daemon host (FDHost) process has stopped abnormally
We have performed a side-by-side upgrade, from SQL Server 2016 to 2022 Developer Edition,...
Automating OSM Data Refresh in Power BI’s Azure Maps Reference Layer
Comments posted to this topic are about the item Automating OSM Data Refresh in...
Database Mail Configuration
Comments posted to this topic are about the item Database Mail Configuration
Question of the Day
Database Mail Configuration
If I want to get a list of the configuration settings for Database Mail using T-SQL, how can I do so?
See possible answers