|
|
|
|
-
Eric Bradford Posted 2 Months ago through Ask
It seems the following feature will be removed in futur versions of SQL: EXEC sp_change_users_login 'Report' Does anybody know how to produce this report using sys.database_principals?Thanks!...
|
-
Eric Bradford refreshed 2 Months ago through Blogs
ISV Vendors may supply a copy of their data files instead of a full database backup/scripts. Attempting to attach the database requires the use of CREATE DATABASE...ATTACH_REBUILD_LOG option. Re-creating the log file resets the recovery model of the dat...
|
-
Eric Bradford learned 2 Months ago through Blogs
While DMVs are some of the most powerful features of Microsoft SQL Server, they are still under-utilized due to the lack of awareness around them. Nevertheless, each release of Microsoft SQL Server comes with a new set of DMVs being introduced & existin...
|
-
Eric Bradford Liked 2 Months ago through Blogs
While DMVs are some of the most powerful features of Microsoft SQL Server, they are still under-utilized due to the lack of awareness around them. Nevertheless, each release of Microsoft SQL Server comes with a new set of DMVs being introduced & existin...
|
-
Eric Bradford Liked 2 Months ago through Blogs
ISV Vendors may supply a copy of their data files instead of a full database backup/scripts. Attempting to attach the database requires the use of CREATE DATABASE...ATTACH_REBUILD_LOG option. Re-creating the log file resets the recovery model of the dat...
|
|
|
-
Eric Bradford Solved 7 Months ago through Puzzles
Remove Pivot
Find matching ColumnValue
Find day difference
Perform Tie breaker using Day Difference column
|
|
|
|
|