Useful links/resources on pulling AD data through SQL Server: Active Directory SSIS Data Source OLE Provider for Microsoft Directory Services MS OLE DB Provider for Micrsosoft AD Service Querying AD Records Distributed Query Query AD through SQL Server
Click here for a download link for this useful SQL Server 2012 System Views Map – in PDF and XPS file format(s)
On a server running SQL 2014 SSIS with SSISDB configured, one of the SQL Agent jobs configured to run using a proxy account kept failing with the error below. Message Unable to start execution of step 1 (reason: JobOwner domain\domainuser doesn‘t have permissions to use proxy 1 for subsystem SSIS). The step failed. Solution that […]
Two very useful commands l use to create a Virtual machines VHDX virtual disk, and resize an existing VHDX virtual hard drive. These were used on a Windows 2012 R2 Server running Microsoft Hyper-v Import-Module Hyper-V New-VHD –Path C:\ClusterStorage\Volume2\HyperV\MyServer\MyServer1_Drive_C.vhdx –Fixed 207GB resize-vhd –Path C:\ClusterStorage\Volume2\HyperV\MyServer\MyServer1_Drive_D.vhdx –sizebytes 507GB Click here for much more Hyper-V powershell commands […]
Below is a sample configurationfile.ini which can be used for an unattended/automatic installation of SQL 2012/2014 This file is usually found here [for SQL 2012 installs]: C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log For 2014 Installations, change 110 to 120 in the above path. To generate this, run the GUI setup almost to the end, answering installation […]
Right clicking on a SQL server database using SQL Server Management Studio, click tasks, copy database and follow the wizard. Below are major screenshots for opening up the primary firewall ports, using the inbound rules node of the windows firewall with advanced security node, in order to achieving this.
Transferring logins and passwords between separate SQL Server instances eg SVR1\DEV to SVR1\DEV2 can be done by scripting out the encrypted passwords using the stored procedures sp_hexadecimal and sp_help_revlogin which can be found by following this detailed link by clicking here.
“A contained database is a database that is isolated from other databases and from the instance of SQL Server that hosts the database. SQL Server 2014 helps user to isolate their database from the instance in 4 ways. Much of the metadata that describes a database is maintained in the database. (In addition to, or […]
Running the SQL Server 2014 upgrade advisor is a good idea when say planning an in-place upgrade from a previous version of SQL Server. To do this, run setup from the installation disc, go to planning, run install upgrade advisor. You might get a pop up such as below, this is resolved by downloading and […]
Useful links on package deployment using Microsoft SQL Server 2012/2014: Deployment of projects and packages SSIS package deployment model in SQK Server 2012/2014 Part 1 SSIS package deployment model in SQK Server 2012/2014 Part 2