forked from gwalkey/SQLTranscriptase
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathchangelog.txt
114 lines (89 loc) · 2.33 KB
/
changelog.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
Changelog
May 6, 2016
=Changes=
Fixed WMI Calls in 01_Server_Appliance
=Added=
CompatibilityMode and Collation to 30_Database_Objects Database_Summary.html
March 31, 2016
=Changes=
01_Server_Storage & 01_Server_Shares
Added Cant Connect Message
09_Packages_from_SSISDB
Handle Issue with catalog Installed but no folders found
14_Service_Broker
Skip offline Databases
March 30, 2016
=Changes=
03_NET_Assemblies
Skip offline Databases
March 29, 2016
=Changes=
09_SSIS_Packages_from_SSISDB
Replaced Invoke-SQLCMD with .net Data Adapter code
March 28, 2016
=Changes=
24_Plan_Guides
23_Database_Diagrams
32_Database_Recovery_Models
04_Agent_Schedules
Replaced Invoke-SQLCMD with .net Data Adapter code
01_Server_Appliance
Fixed Bug getting the Powershell version
Mar 18, 2016
=Added=
SQLT_GUI.ps1
Winforms GUI for all the scripts
=Changes=
01_Server_Appliance
Changed Query for SQL Install Date - SID User method (NT Anon) not reliable
Embedded the CSS
06_Top_25_Worst_Queries
Embeded the CSS
31_DataBase_Export_Table_Data
Fixed the Output and Import CMD file
Mar 3, 2016
=Added=
31_DataBase_Export_Table_Data
Dumps Table Data out in BCP format
=Updated=
01_Server_Appliance
SQL Engine Last Start Time
Feb 28, 2016
=Updated=
01_Server_Logins
Added Logins with Hashed Passwords and SIDs
Feb 25, 2016
=Added=
34_User_Objects_in_System_Databases.ps1
=Fixed=
Removed dependency on external CSS file for all scripts with HTML Output
01_Server_Logins - New logic to determine 3 Login Types and always use AD Module installed and on a Domain
Feb 22, 2016
=Added=
32_Database_Recovery_Models
33_VLF_Counts
Feb 15, 2016
=Added=
Network Adapter Configs to 01_Server_Appliance.ps1
Feb 6, 2016
=Added=
Top 25 Worst performing Queries - as HTML table
Entire Live Query Plan Cache - ummm that was fun, but useful?
Feb 3, 2016
=Added=
Table Order Creation Hints File -
Tables are listed in the right order for Declarative Referential Integrity PK/FK Table dependencies
==Added New 2016 Objects==
Database-Scoped Credentials
Database Query Store Settings
Database Security Policies
Database XML Schema Collections
External Data Sources
External Tables
External File Formats
Always Encrypted Objects
Column Master Keys
Column Encryption Keys
=Fixed=
CREATE Database statement -
fixed for 2016 (Scripter Object doesnt work, but the SMO object's script() method does - go figure)