How to fix Orphaned Users
To view if there are any orphaned users, run this query against the DB;
sp_change_users_login ‘report’
To fix;
sp_change_users_login ‘update_one’, ‘dbUser’, ‘sqlLogin’
2010-08-31
1,888 reads
Blog Posts
Interview with SQL Server MVP Glenn Berry
This is a first of a series of interviews with speakers presenting at the SQLServerCentral.com track at SQL Server Connections...
2010-08-31
2,506 reads
Maintenance Plan "No description found" error
for Sql server 2005, It was a bug when you modify maintainance plan you may get the error “no description...
2010-08-31
2,770 reads
Positioning SQLRally in the PASS Event Universe
Prior to creating SQLRally the world of PASS consisted of the PASS Summit which is our annual mega-event, the European...
2010-08-31
1,832 reads
Project Phoenix: Late August Awards Announced
Two more eligible developers and deserving projects have been selected. Any proposals submitted but not selected this time will be...
2010-08-31
1,484 reads
Replication Gotcha - Including An Article In Multiple Publications
When administering replication topologies it's common to group articles into publications based on roles that subscribers fulfill. Often you'll have...
2010-08-31
10,668 reads
Return top 20 queries by Average CPU
I’ve recently used this when troubleshooting some unexplained high CPU load on my server:
select top 20st.objectid, st.dbid, total_worker_time/execution_count AS AverageCPUTime,CASE statement_end_offsetWHEN -1...
2010-08-31
4,243 reads
SELECT, Deconstructed
Today let’s expand on the logical processing order of SELECT that I mentioned in last week’s N Things Worth Knowing...
2010-08-31
2,561 reads
SQL Saturday #48 - Columbia - Call for Speakers Ending
This is a reminder for those who might be considering submitting a session but haven't yet. The call for speakers...
2010-08-31
1,404 reads
SQLRally Pre-Con Selection Process – Draft for Comment
Hopefully you’ve heard by now that PASS is launching a new event format called SQLRally in May 2011 in Orlando....
2010-08-31
1,894 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
Forward Deployed Engineers
Comments posted to this topic are about the item Forward Deployed Engineers
TRY_PARSE vs TRY_CONVERT in SQL Server: From Basics to Practical Usage
Comments posted to this topic are about the item TRY_PARSE vs TRY_CONVERT in SQL...
DBCC CHECKDB Limits II
Comments posted to this topic are about the item DBCC CHECKDB Limits II
Question of the Day
DBCC CHECKDB Limits II
I have a SQL Server 2025 database that I want to check for corruption every night. One of the things we do is disable indexes used for ETL loads during the weekend and re-enable them on Monday morning. If we run DBCC over the weekend, are our disabled indexes checked for consistency?
See possible answers