duplicates = multiple editions
A Classical Introduction to Modern Number Theory, Kenneth Ireland Michael Rosen
A Classical Introduction to Modern Number Theory, Kenneth Ireland Michael Rosen
Kin Shah TheRockStarDBA
🏠
TheRockStarDBA
/ ConvertSQLServerSIDToReadableString.sql
Created
November 16, 2015 14:46
convert an SQL Server login SID to a readable string
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| Ref: http://www.codykonior.com/2015/05/31/how-to-convert-an-sql-login-sid-to-a-readable-string/ | |
| Note that if you're doing this on the output from an Audit Login trace (http://www.safesql.com/2015/06/03/sql-server-security-and-renamed-logins/): | |
| Remove the first Case When | |
| Len needs to be replaced with Datalength | |
| sp.sid replaced with al.LoginSid |
TheRockStarDBA
/ GetSQLServerInfo.sql
Last active
December 9, 2015 20:17
This script outputs sql server service, start type, status, Service Account, installation location, start up time, uptime of sql server related services along with startup trace flags.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /************************************************************************************************************************************************* | |
| Author: ██╗ ██╗██╗███╗ ██╗ ███████╗██╗ ██╗ █████╗ ██╗ ██╗ | |
| ██║ ██╔╝██║████╗ ██║ ██╔════╝██║ ██║██╔══██╗██║ ██║ | |
| █████╔╝ ██║██╔██╗ ██║ ███████╗███████║███████║███████║ | |
| ██╔═██╗ ██║██║╚██╗██║ ╚════██║██╔══██║██╔══██║██╔══██║ | |
| ██║ ██╗██║██║ ╚████║ ███████║██║ ██║██║ ██║██║ ██║ | |
| ╚═╝ ╚═╝╚═╝╚═╝ ╚═══╝ ╚══════╝╚═╝ ╚═╝╚═╝ ╚═╝╚═╝ ╚═╝ | |
| Sr. DBA |
TheRockStarDBA
/ RenameDatabase_LogicalAndPhysicalFiles.sql
Last active
April 17, 2016 22:10
Rename database - logical and physical files
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| if not exists (select 1 from sys.objects where name = 'usp_rename_db' and type = 'P') | |
| exec ('create procedure dbo.usp_rename_db as SELECT 1') | |
| go | |
| alter procedure dbo.usp_rename_db | |
| @sourceDBName as sysname, | |
| @destinationDBName as sysname, | |
| @execute as int, | |
| @help as int | |
| as | |
| /************************************************************************************************************************************************* |
TheRockStarDBA
/ Deadlock Detector.sql
Last active
June 28, 2020 22:35
Get deadlocks in realtime - deadlock detector
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /*************************************************************************************************** | |
| Author: ██╗ ██╗██╗███╗ ██╗ ███████╗██╗ ██╗ █████╗ ██╗ ██╗ | |
| ██║ ██╔╝██║████╗ ██║ ██╔════╝██║ ██║██╔══██╗██║ ██║ | |
| █████╔╝ ██║██╔██╗ ██║ ███████╗███████║███████║███████║ | |
| ██╔═██╗ ██║██║╚██╗██║ ╚════██║██╔══██║██╔══██║██╔══██║ | |
| ██║ ██╗██║██║ ╚████║ ███████║██║ ██║██║ ██║██║ ██║ | |
| ╚═╝ ╚═╝╚═╝╚═╝ ╚═══╝ ╚══════╝╚═╝ ╚═╝╚═╝ ╚═╝╚═╝ ╚═╝ | |
| Sr. DBA | |
| -- http://dba.stackexchange.com/users/8783/kin |
TheRockStarDBA
/ springer-free-maths-books.md
Created
December 29, 2015 15:30
— forked from bishboria/springer-free-maths-books.md
Springer have made a bunch of books available for free, here are the direct links
TheRockStarDBA
/ Get_TDE_Information.sql
Last active
January 15, 2016 20:39
Get TDE (Transparent Data Encryption) Info - along with encryption state, certificate, etc
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /************************************************************************************************************************************************* | |
| Author : ██╗ ██╗██╗███╗ ██╗ ███████╗██╗ ██╗ █████╗ ██╗ ██╗ | |
| ██║ ██╔╝██║████╗ ██║ ██╔════╝██║ ██║██╔══██╗██║ ██║ | |
| █████╔╝ ██║██╔██╗ ██║ ███████╗███████║███████║███████║ | |
| ██╔═██╗ ██║██║╚██╗██║ ╚════██║██╔══██║██╔══██║██╔══██║ | |
| ██║ ██╗██║██║ ╚████║ ███████║██║ ██║██║ ██║██║ ██║ | |
| ╚═╝ ╚═╝╚═╝╚═╝ ╚═══╝ ╚══════╝╚═╝ ╚═╝╚═╝ ╚═╝╚═╝ ╚═╝ (@TheRockStarDBA) | |
| Sr. DBA | |
| Date : - Original Version created on 01.15.2016 |
TheRockStarDBA
/ CheckBackupRestoreProgress.sql
Created
March 23, 2016 19:34
Find Backup / restore progress
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- below script will help track down the backup / restore progress. | |
| SELECT command, | |
| s.text, | |
| start_time, | |
| percent_complete, | |
| CAST(((DATEDIFF(s,start_time,GetDate()))/3600) as varchar) + ' hour(s), ' | |
| + CAST((DATEDIFF(s,start_time,GetDate())%3600)/60 as varchar) + 'min, ' | |
| + CAST((DATEDIFF(s,start_time,GetDate())%60) as varchar) + ' sec' as running_time, | |
| CAST((estimated_completion_time/3600000) as varchar) + ' hour(s), ' | |
| + CAST((estimated_completion_time %3600000)/60000 as varchar) + 'min, ' |
TheRockStarDBA
/ ColumnstoreReorg.sql
Created
March 28, 2016 21:37
— forked from feaselkl/ColumnstoreReorg.sql
Run this to get a list of columnstore index partitions to determine which should be reorganized. This script also generates index reorg statements which could be run.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ------------------------------------------------------------------- | |
| -- Script Name: ColumnstoreReorg.sql | |
| -- | |
| -- Desc: Run this to get a list of columnstore index partitions | |
| -- to determine which should be reorganized. The script also | |
| -- generates index reorg statements which could be run. | |
| -- | |
| -- Notes: SQL Server 2016 is REQUIRED. SQL Server 2016 changed | |
| -- what index reorganization does to columnstore indexes, | |
| -- and this script takes advantage of those changes. |
TheRockStarDBA
/ DbaStackExchangeGroupedDailySchedule.sql
Created
April 27, 2016 19:08
— forked from anonymous/DbaStackExchangeGroupedDailySchedule.sql
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- See http://dba.stackexchange.com/questions/136235/group-daily-schedule-into-start-date-end-date-intervals-with-the-list-of-week/136571?noredirect=1#comment257069_136571 | |
| /***************************************************************** | |
| DATA: Create sample data | |
| *****************************************************************/ | |
| IF OBJECT_ID('tempdb..#src') IS NOT NULL | |
| DROP TABLE #src | |
| CREATE TABLE #src (ID int PRIMARY KEY, ContractID int, dt date, dowChar char(3), dowInt int); |
TheRockStarDBA
/ Get-SqlErrorLog.ps1
Created
April 29, 2016 22:12
— forked from sirsql/Get-SqlErrorLog.ps1
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <# | |
| .SYNOPSIS | |
| Get-SqlErrorLog is designed to quickly retrieve data from SQL Server error logs, negating the slowness of SSMS and awkwardness of manually crawling files. | |
| .DESCRIPTION | |
| Get-SqlErrorLog is designed to quickly retrieve data from SQL Server error logs, negating the slowness of SSMS and awkwardness of manually crawling files. | |
| It is designed to be quite light in it's process, and should be quick (loading SQLPLS being the exception. |