A while back, I wrote an article calledCreating a date dimension or calendar table in SQL Server. I have used this pattern repeatedly and, based on the questions I get from the community, many of you are using it, too. Some of the questions I get are along the lines of “how do I...
In the "Report Data" pane, Right-click on the "Datasets" folder to bring up a context menu. We select "Add Dataset…" to open the "Dataset Properties" dialog from the context menu. We select the "Use a shared dataset" option. A list of shared datasets should show in the list box....
To list all contained database users, use the following query: SELECT DP.name, DP.type_desc FROM sys.database_principals AS DP WHERE DP.authentication_type_desc = 'DATABASE'; USER ROLES AND PRIVILEGES The review of user roles and privileges is a critical aspect of any MSSQL audit proce...
DataGridView to DataTable DataGridView: Dynamically add column and set column type at runtime (Unbound) Datareader.Read() IS SLOWER THAN EVER DataSource.Error: ODBC: ERROR [HYC00] [Microsoft][ODBC Driver Manager] Driver does not support this parameter DataTable Column to List(of Integer) ...
Configure the Database Table or View settings Configure the Lansweeper settings Configure the Microsoft SMS/SCCM settings Configure the NCM, NPM, and SAM settings Configure the Discovery Engine (WMI) settings Install the MySQL JDBC Driver Install the OpenBase JDBC driver Sync and discover assets Manua...
For a list of reserved words in Oracle, see the Oracle9i SQL Reference, Release 1 (9.0.1). Table Design Considerations This section discusses the many table design issues that you need to consider when converting Microsoft SQL Server and Sybase Adaptive Server databases to Oracle. These issues ...
Table 2. List of vNICs vNIC Template Name vNIC-Mgmt-A vNIC-Mgmt-B vNIC-vMotion-A vNIC-vMotion-B vNIC-VMNetwork-A vNIC-VMnet-work-B Purpose ESXi Host Management via Fabric-A ESXi Host Management via Fabric-B vMotion Traffic via Fabric-A vMotion Traffic via Fabric...
Select an existing database or input a new database name (click the 'Refresh' button to list all databases). If the target database does not exist, this tool will automatically create it during the migration process. In "Select source Tables(s) & View(s)" dialog; Select the tables or...
The cluster setup used is the same as detailed in Table 3 . The details of the VM configuration and workload are list in Table 6 . OLTP workload with 70:30 read write ratio was exerted on each guest VM. The workload stressed each VM with up to 55-60% of guest CPU utilizati...
In this tip you will find a more detailed explanation about the maximum row size in a SQL Server table:Row sizes exceeding 8060 bytes in Sql 2005. Check out theSQL Server Data Types Tips Categoryfor more tips.