The SSIS Catalog Rentention Period (days) defaults to 365. The SSIS database can quickly become very large (as a function of SSIS activity and logging levels). A stored procedure SSISDB.internal.cleanup_server_retention_window is executed by a job SSIS Server Maintenance Job on a nightly … Continue reading →
Statements to reveal Change Tracking settings. This query does not require VIEW DATABASE STATE permission, which is required to display the database properties page in SSMS. select [database_name] = DB_NAME(database_id) ,* from sys.change_tracking_databases
Continue reading →Is it worth the effort? Advantages Can encapsulate a set of defaults. Pre-configurations of a very general report, for example. Disadvantages Links between reports take users to the master source folder. (!) Dynamic parameter defaults don’t survive linking. Instead the … Continue reading →
SSSB Endpoint Authentication Certificate Don’t forget to give this a long lifetime (if security policy allows) by using EXPIRY_DATE, otherwise the certificate expires after a year. CREATE CERTIFICATE [BrokerCertificateDec15] WITH SUBJECT = N’certificate_subject’, EXPIRY_DATE = N’2025-12-31′; Expiry of the certificate … Continue reading →
This page could eventually save hours. SSRS Open Report Data toolbar. CTRL+ALT+D. (also on view menu if toolbar not in focus) View Hidden Datasets. Right-click the Datasets node.
Continue reading →Introduction Avoid all use of the Performance Monitor interface by using typeperf.exe (the oddest of names). Brent Ozar’s Tutorial on SQL Performance Monitoring – using performance monitor manually to gather SQL-relevant counters. Shaun J Stuart Baselining SQL Server Part 1 and … Continue reading →
Column Naming Convention I like lower case with underscores: company_id, first_name, telephone_nbr, booking_ref This is Uncle Joe Celko’s convention as stated in SQL Programming Style (Morgan Kaufmann, 2005), and I accept his justification that Invoices.invoice_nbr is more readable than Invoices.InvoiceNbr in a dense melee of … Continue reading →
I imagine that it’s a well trodden path seeking out a satisfactory code or syntax highlighter for wordpress. You can, just about, paste colour-formatted code from some editors into the wp text editor (e.g. SSMS to Outlook Email to WordPress), … Continue reading →