Pages

▼
Thursday, 25 April 2024

Report Server Configuration Manager: Unable to connect the the Report Server

›
Credit: Pedro Salinas-Ruiz - https://businesswintelligence.com/content/139/configuration-manager-ssrs-error  Sometimes the WMI RS integratio...
Thursday, 2 December 2021

›
For those of you that have come up against the problem in SSIS packages where you cannot use an Execute Package Task to run a Package t...
Thursday, 17 June 2021

Find Allocation Unit Size of Disk Using Powershell

›
Everything in SQL Server is stored on disk in 8K pages.  The Microsoft recommended best practice is to format using a 64K allocation unit si...
Friday, 5 February 2021

SSMS: The Query Window Keyboard Shortcuts

›
  Taken from https://www.red-gate.com/simple-talk/sql/sql-training/ssms-the-query-window-keyboard-shortcuts/ SSMS …Toggle the full-...

SSMS Shortcut Key to fill in Parameters

›
 [Ctrl] + [Shift] + [M]
Wednesday, 10 May 2017

Create Table structure from another table in DB2 AS400

›
CREATE TABLE SCHEMA.NEW_TB AS ( SELECT * FROM SCHEMA.OLD_TB ) WITH NO DATA   There is no way of copying the table structure and th...
Tuesday, 2 May 2017

SQL Agent Job Schedules

›
Friday, 18 November 2016

FIX: The request does not contain a certificate template extension or the CertificateTemplate request attribute

›
Scenario: You are trying to generate an SSL Certificate from your Enterprise CA using the MMC Snapin using a CSR File and you get the erro...
Thursday, 7 April 2016

Check Articles on a Publication Database

›
This needs to be run against the Publication Database: This script came from Stack Overflow User Davmos: http://stackoverflow.com/users/...
Friday, 4 March 2016

List users with roles on a Database

›
SELECT         [UserType] = CASE membprinc . [type]                          WHEN 'S' THEN 'SQL User'       ...