I’ve imported and migrated a tremendous amount of databases into SQLServer versions 2012 and above. Finding and identifying old owners as they would be orphans now or users that should not have access can be made easier by running or fully automating an import workflow by adding this script to the process. 375 more words
Tags » SQLSERVER
I’m just sharing with you guys a script to find all implicit data type conversions associated with mismatched data types in a specific database.
It’s pretty handy when you are either developing or coding reviewing. 217 more words
— by Lori Brown @SQLSupahStah
I recently ran into someone who swears that shrinking database files on a production server is a good thing and proudly said they did it on all systems they work on. 443 more words
Este error me salió luego de instalar el SQL SERVER 2014 sobre una máquina donde ya tenía previamente SQL SERVER 2008R2, al abrir el Sql Server Configuration Manager sale este error: 42 more words