2016-08-23 (first published: 2015-05-01)
1,407 reads
2013-04-17 (first published: 2013-04-03)
1,445 reads
2013-03-19 (first published: 2013-03-01)
1,040 reads
Get Detach or Attach all user databases script
Script to generate script to detach or attach user databases
2013-02-15 (first published: 2013-01-29)
5,349 reads
Reorganize indexes for all tables in all user databases
Script to reorganize all indexes on all tables in user databases
2013-02-14 (first published: 2013-01-31)
3,234 reads
2013-02-06 (first published: 2012-12-27)
1,832 reads
Change database compatability level of all databases
Changes the database compatibility level of all databases to the given level.
2013-01-31 (first published: 2013-01-07)
923 reads
2012-12-03 (first published: 2012-11-07)
2,009 reads
2012-10-04 (first published: 2012-04-10)
2,007 reads
2012-07-25 (first published: 2012-07-12)
2,489 reads
Blogs
Can I Change a Primary Key Value? #SQLNewBlogger
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
SQL Server Index Primer
By Kevin3NF
Indexes 101: What, Why, and When? “What Is an Index?” I get this question...
Secure Azure SQL Server Backups Using Managed Identities
By Arun Sirpal
I do believe most people know about the ability to backup your SQL server...
Forums
Just a rant about the SQL Server 2022 upgrade
Upgrading an instance of SQL Server 2019 to SQL Server 2022 - I am...
Report Server Configuration Manager - The target principal name is incorrect SSL
SQL Server SSRS 2022. Running into ' SSL Provider, error: 0 - The target...
Report Server Configuration Manager - Change Database - SSL Error
SQL Server SSRS 2022. Running into ' SSL Provider, error: 0 - The target...
Question of the Day
Getting the TEXTSIZE
How can I check what value I used for TEXTSIZE? I ran this code:
SET TEXTSIZE 8096But then deleted the code and couldn't remember. Is there a way to check this? See possible answers