South Africa Finance

Sep 7 2018

What is SQL Azure? Definition from, sql azure tools.#Sql #azure #tools

# SQL Azure Share this item with your network: SQL Azure is Microsoft’s cloud database service. Based on SQL Server database technology and built on Microsoft’s Windows Azure cloud computing platform, SQL Azure enables organizations to store relational data in the cloud and quickly scale the size of their databases up or down as business needs change. Data is hosted, managed and provisioned in Microsoft data centers. SQL Server Import Export Wizard Step-By-Step Tutorial In this expert-led tutorial, senior DBA and technical trainer Basit Farooq provides a step-by-step guide for using the SQL Server Import and Export Wizard to transfer …

May 15 2018

How to make SQL Server 2008 redundant? Server Fault

#redundant #sql #server # At the moment I’d like to combine my departmental SQL Server into one big SQL Server 2008 instances spread across two servers (for redundancy reason). How/what is the best way to approach this. is it through clustering or Log shipping or VMware (hypervisor) High Availability features ? Note: this DB server cannot go down as it is hosting the VCenter DB and also server monitoring database too. the SQL Server is spread across several smaller servers 3-4 SQL Server 2000 and 2005 with the total of 70 DB inside those servers, what I’d like to do/build …

Mar 22 2018

SQL SERVER – Restore Database Backup using SQL Script (T-SQL) – Journey to SQL Authority

#sql #restore #database # SQL SERVER Restore Database Backup using SQL Script (T-SQL) In this blog post we are going to learn how to restore database backup using T-SQL script. We have already database which we will use to take a backup first and right after that we will use it to restore to the server. Taking backup is an easy thing, but I have seen many times when a user tries to restore the database, it throws an error. Step 1: Retrive the Logical file name of the database from backup. Step 2: Use the values in the LogicalName …

Mar 19 2018

SQL Tutorial – Learn SQL Query Programming Language, sql dbo.#Sql #dbo

# SQL Tutorial – Learn SQL Query Language SQL (Structured Query Language) is a computer language aimed to store, manipulate, and query data stored in relational databases. The first incarnation of SQL appeared in 1974, when a group in IBM developed the first prototype of a relational database. The first commercial relational database was released by Relational Software (later becoming Oracle). Standards for SQL exist. However, the SQL that can be used on each one of the major RDBMS today is in different flavors. This is due to two reasons: 1) the SQL command standard is fairly complex, and it …

Mar 13 2018

Execute Query

#takis #diakoumis, #sql, #select #table, #sql #queries, #sql #query #tool, #sql #query, #query #tool, #database #query #tool, #jdbc, #execute #query, #sql #scripts, #query #tools, #sql #query #builder, #sql #tool, #database #query #sql, #sql #server #tools, #sql #database, #oracle, #mysql, #postgresql, #db2, #sybase, #hsqldb, #h2, #sql #server, #java #swing, #erd, #persistence, #statement, #query, #execute #sql, #result #set, #data #export, #import #csv, #underworldlabs, #database, #xml # Execute Query now on Google Groups We have set up Execute Query on Google Groups to consolidate queries and issues as well as provide an indexed support forum and mailing list. Please visit us at http://groups.google.com/group/executequery. …

Jan 10 2018

Transparent Data Encryption FAQs

#transparent #data #encryption, #tde, #security #aes, #3des, #database #encryption #key, #dek, #ssl, #security, #microsoft #sql #server # Transparent Data Encryption FAQs If nothing else, the recent security scandals about the NSA and its PRISM surveillance program have raised everyone s awareness about the importance of data protection. Databases are some of an organization s most important assets, and they often contain sensitive information. SQL Server has several built-in data protection technologies, and one of the most important is Transparent Data Encryption (TDE). Here are some of the most common FAQs about TDE. Q: What is TDE and why would I …

Dec 24 2017

Microsoft SQL Server Reporting Services Error

#microsoft #sql #reporting # I have installed SharePoint 2010 and selected to create a New Site. I am using the Contacts Web Databse template. All works fine except for the SQL Server reports that are built in. On the Contact Card tab, I get the error below where it should be posting the Comment for the Contact. I found a post that suggested changing the tags in the report http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/30f7a33f-4513-4498-8dc9-c4f0470081e7?prof=required. This just produced a new error concerning missing parameters. Any help is greratly appreciated. Microsoft SQL Server Reporting Services Report viewer failed to set the report parameter defaults for this …

Dec 7 2017

Software Development Pty Ltd #brisbane, #software #development, #software #development, #website #design, #software #solution, #website #development,

# SOFTWARE DEVELOPMENT Software Development Pty Ltd Customised Solutions Todays Technology Services About Us YOU’LL BE PART OF A SELECT FEW Portfolio DataTrap Desktop Solution. February 2012-2016 Heilig and Partners came to Software Development to develop some geo referencing based packages that allowed monitoring of explosion and vibration data for construction sites in real time. This involved both a web interface and windows based desktop software. Software Development designed additional software allowing the calculation of explosive weights and other construction methods. The system outputs files in KML/DXF/DWG format. The solutions are used in construction of notable projects such as the …

Nov 3 2017

FTP Task #sql #ftp

# FTP Task The FTP task downloads and uploads data files and manages directories on servers. For example, a package can download data files from a remote server or an Internet location as part of an Integration Services package workflow. You can use the FTP task for the following purposes: Copying directories and data files from one directory to another, before or after moving data, and applying transformations to the data. Logging in to a source FTP location and copying files or packages to a destination directory. Downloading files from an FTP location and applying transformations to column data before …

Oct 26 2017

SQLCourse – Lesson 4: Creating Tables #sql #new #line #character, #database #professional #creating #tables #sql

# Creating Tables The create table statement is used to create a new table. Here is the format of a simple create table statement: Format of create table if you were to use optional constraints: Note: You may have as many columns as you’d like, and the constraints are optional. To create a new table, enter the keywords create table followed by the table name, followed by an open parenthesis, followed by the first column name, followed by the data type for that column, followed by any optional constraints, and followed by a closing parenthesis. It is important to make …

Oct 2 2017

Reporting – Tools Specialist (Junior #reporting #tools #for #sql

# Reporting Tools Specialist (Junior / Grad) – Excel / SQL / Data Reporting Tools Specialist (Junior/Grad) – Excel/SQL/Data Recruiting immediately and on a permanent basis, for a fantastic client close to Theale, who are looking for a Junior or Graduate level Reporting Tools Specialist, with excellent ability across Excel and SQL. Essentially, this person will be providing analytical support across all major company initiatives, turning data into information for the management teams. Ensure development and use of correct analytical tools and techniques that are most appropriate to the objectives of the analysis Support processes and governance within with the …

Sep 13 2017

The exact meaning of – Executions #sql #server #min

# We are having issue understanding the Executions/Min in the Recent Expensive Queries section of Activity Monitor in SQL Server 2008. Also, I used the following SQL: total_worker_time / execution_count AS [Avg CPU Time] , total_logical_reads, total_logical_writes, total_physical_reads,total_elapsed_time, *, CASE WHEN deqs.statement_start_offset = 0 AND deqs.statement_end_offset = -1 THEN ‘– see objectText column–‘ ELSE ‘– query –‘ CHAR(13) CHAR(10) SUBSTRING(execText.text, deqs.statement_start_offset / 2, ( ( CASE WHEN deqs.statement_end_offset = -1 END ) – deqs.statement_start_offset ) / 2) END AS queryText FROM sys.dm_exec_query_stats deqs CROSS APPLY sys.dm_exec_sql_text(deqs.plan_handle) AS execText where datediff(mi, deqs.last_execution_time, GetDate()) 1 order by 5 desc The total of …

Aug 22 2017

Master Data Management #sql #server, #database #administration, #business #intelligence

# Master Data Management In Implementing Supertypes and Subtypes (November 2006), I discussed using supertypes and subtypes for data modeling and how to implement the design objects. Now you re probably waiting for me to give you a real reason for adopting the supertype-subtype design concept. I will. Whether you realize it or not, your company is failing to capitalize on business opportunities and is losing revenue because it doesn t have a single source of accurate data, or data truth. And you re well aware of the time you and your colleagues spend trying to reconcile the discrepancies in …

Aug 14 2017

SQL Server 2008 hardware and software requirements #sql #hardware #requirements

# SQL Server 2008 hardware and software requirements CD or DVD drive as needed for given installation media. CD or DVD Drive as needed for given installation media. The following is the terminology used in relation to the 64-bit platform: IA64 refers to Itanium-compatible hardware architecture. This architecture can run IA64 software and 32-bit software using the Windows-On-Windows (WOW64) software emulator. The Itanium CPU cannot natively run 32-bit x86-compatible instructions and uses instruction emulation as a part of WOW64 processing. x64 refers to Extended Memory Technology support-compatible architecture and includes systems based on Opteron, Athlon 64, Intel Xeon EM64T, and …

Aug 8 2017

How to Backup a Table #sql #server #backup #table

# There is not standard method for backing up a table in SQL Server. A common request I receive from clients is to only backup specific tables within a database. Well, unfortunately there is no out of the box method for doing this akin to a database backup so we need to roll our own way. It is usually done one of two ways. The first is to use a select into method to copy the table. The other way is to script the table out using the Generate Scripts Tasks. Both methods have positives and negatives. First off, the …

Aug 7 2017

How Do I #restore #database #sql

# How Do I. Restore a SQL Server database to a new server? This blog entry is also available as a TechRepublic gallery and as a TechRepublic download . As a DBA, I have been in many situations where I had to move databases to a new server due to old hardware, failed hardware, failed drives, etc. You have two options you could use to carry out this task: SQL Server Management Studio (GUI) T-SQL (Command line) The method I prefer is T-SQL. It is simple and easy and avoids clicking the mouse all over the screen. This How do …

Aug 6 2017

What does the colon sign: do in a SQL query? Stack Overflow #sql #sign

# What does “:” stand for in a query? A bind variable. Bind variables allow a single SQL statement (whether a query or DML) to be re-used many times, which helps security (by disallowing SQL injection attacks) and performance (by reducing the amount of parsing required). How does it fetch the desired value? Before a query (or DML) is executed by Oracle, your program will create a cursor. Your program issues the SQL to be parsed for that cursor, then it must bind values for each bind variable referred to by the SQL. How this is done depends on the …

Aug 5 2017

Microsoft SQL Server Developer Edition is now free #ms #sql #server

# Microsoft SQL Server Developer Edition is now free This post was authored by Tiffany Wissner, Senior Director of Data Platform Marketing Exciting news! Starting today, SQL Server 2014 Developer Edition is now a free download for Visual Studio Dev Essentials members (you will be prompted to sign in to Visual Studio Dev Essentials before you can download SQL Server 2014 Developer Edition). We are making this change so that all developers can leverage the capabilities that SQL Server 2014 has to offer for their data solution, and this is another step in making SQL Server more accessible. SQL Server …

Aug 2 2017

SQL – INSERT INTO SELECT Statement #select #into #temp #table #sql

SQL INSERT INTO SELECT The INSERT INTO SELECT statement is used to add multiple new records into a database table at one time. Syntax The syntax for INSERT INTO SELECT is as follows: INSERT INTO table1 ( column1 , column2 . ) SELECT column3 , column4 . FROM table2 ; Note that this is the simplest form. The SELECT statement can easily contain WHERE . GROUP BY . and HAVING clauses, as well as table joins and aliases. Please note the number of columns specified in the SELECT statement must be the same as the number of columns specified in …

Jul 26 2017

Difference Between SQL and T-SQL #difference #between #sql #and #sql #server

# Difference Between SQL and T-SQL The Structured Query Language or SQL is a programming language that focuses on managing relational databases. This is used mainly in controlling and manipulating data and is very important in businesses where large amounts of information are stored about products, clients, and the ensuing transactions. SQL has its own limitations which spurred the software giant Microsoft to build on top of SQL with their own extensions to enhance the functionality of SQL. Microsoft added code to SQL and called it Transact-SQL or T-SQL. Keep in mind that T-SQL is proprietary and is under the …

Jul 22 2017

How to Backup a Database using Management Studio #sql #server #backup #table

# Intellect Connect If you are a VPS or Dedicated Server customer running SQL Server on your Server, this article will walk you through how to backup a database and make a copy of a database using Management Studio Express. Step 1 You will first need to connect to your database server, using SQL Server Management Studio Express. Please see our article How to connect to a database using SQL Server Management Studio Express if you require assistance with this. For this example, we will backup the database named backmeup to our C:\backup folder. Once connected to your database server, …

Jul 22 2017

Резервное копирование и восстановление данных (Команды RMAN) #oracle #backup, #recovery #manager, #rman, #резервное #копирование #и

# // Резервное копирование и восстановление данных (Команды RMAN) Лучше посмотреть материал, который находится здесь . Там постепенно обновляется информация согласно появления новых знаний. FRA – Fast Recovery Area – область на диске для бекапов и архивных журналовRMAN – Recovery Manager (утилита для резервного копирования и восстановление данных) В большинстве случаев, рекомендуется настроить работу базы данных в режиме работы ARCHIVELOG. ARCHIVELOGи и BACKUPы хранятся в FRA, необходимо, чтобы база данных имела возможность записи данных в эту область, иначе возникнет ошибка и база перестанет принимать команды пользователей. Поэтому, по мере заполенения FRA, необходимо ее очищать (исключительно средствами RMAN). Посмотреть данные FRA: …

Jul 21 2017

How To: Use a Non-SQL Server Monitoring Database #sql #server #database #monitoring #tools

# How To: Use a Non-SQL Server Monitoring Database The following procedure shows how to use a non-SQL Server monitoring database within Microsoft AppFabric 1.1 for Windows Server. If using a SQL Server database, these views and the staging table are created by the AppFabric configuration process. With a non-SQL Server database, you will have to create these database entities using whatever functionality of the non-SQL database program allows you to accomplish this. Configuring a Non-SQL Monitoring Database Implement the monitoring staging table and public views. Choose a non-SQL Server database specific mechanism from the database vendor to create the …

Jul 7 2017

Unable to bring database online from recovery pending – Database Administrators Stack Exchange #sql #server

# I am trying to bring a SQL Server database online and accessible that is in Recovery Pending state. The SQL Server service uses an Active directory account that is a domain administrator and a member of sysadmin on sql server. The SQL Server account should have rights in the SQL file folders as it is a domain admin. It is however not a local administrator in the SQL Server. The error messages are: Msg 5120, Level 16, State 101, Line 1 Unable to open the physical file “F:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\DBName.ndf”. Operating system error 5: “5(Access is denied.)”. Msg …

Jun 24 2017

SQL exclude a column using SELECT * except columnA FROM tableA? Stack Overflow #sql #select

# We all know that to select all columns from a table, we can use Is there a way to exclude column(s) from a table without specifying all the columns? The only way that I know is to manually specify all the columns and exclude the unwanted column. This is really time consuming so I’m looking for ways to save time and effort on this, as well as future maintenance should the table has more/less columns. Simply genius! I had to implement a trigger, which would throw an error instead of inserting in case of unsuitable data . In MS …

Jun 17 2017

Backup and Restore Your SQL Server Database from the Command Line #backup #database #sql #server

# Backup and Restore Your SQL Server Database from the Command Line The most important part of a SQL Server maintenance plan is backing up your databases regularly. To backup a database, you cannot simply copy the respective MDF and LDF files of the database as SQL Server has a lock on these. Instead, you need to create a true backup file through SQL Server. While this can be done by developing a Maintenance Plan inside of SQL Management Studio, the free Express editions of SQL Server do not offer this interface. To work around this, you can easily backup …