SQLServerCentral - www.sqlservercentral.com

A community of more than 1,600,000 database professionals and growing

Featured Contents

Featured Script

The Voice of the DBA

One Size Does Not Fit All

Today we have a guest editorial as Steve is away at SQL Bits.

Have you ever had a discussion with your manager and he/she threw around phrases like “out-of-the-box” and “one-size-fits-all?” If you have, then hopefully you were able to maintain a poker face and not cringe too much.

These dangerous words were presented to me during a conversation about SQL Server and multi-site fail-over / replication. My boss wanted a single strategy which would perform optimally for all of our systems, be fully supported by Microsoft, and have zero impact to any of our development practices and database structure. A single, company-wide strategy might be possible for some companies that only have a single type of system, but my company deals with many different data processes. We have customer facing transactional systems, internal transactional systems, back-end high-volume processing systems, BI data warehouses / cubes, and every variation in-between.

With each of our types of data processing, I would normally recommend different disaster recovery or active-active strategies with varying data loss SLAs and RTOs. In addition, seamless implementation without impacting the development teams is unreasonable. Each strategy has the potential to induce constraints, or at least, change the existing procedures for dealing with failures.

With that said, there is no 100% out-of-the-box fail-over or active-active solution that comes in the form of a one-size-fits-all black box. For that matter, SQL Server doesn't have a good replication feature to support multiple masters at all. Attempting to implement a less than optimal method for the type of processing will produce nothing more than a less than optimally functioning system. Multi-site configurations need to be a part of the design of a system rather than an afterthought.

Derik Hammer from SQLServerCentral.com

Join the debate, and respond to today's editorial on the forums

ADVERTISEMENT
SQL Prompt

5 ways to code effortlessly

Discover the different ways you can make writing, exploring, and refactoring SQL code refreshingly effortless with SQL Prompt 6. Download a free trial.

SQL Compare

Free eBook: SQL Server Backup and Restore

With the tools, scripts, and techniques in this free eBook, you will be prepared to respond quickly and efficiently to disaster, whether it's disk failure, database corruption, or accidental data deletion. Download the free eBook.

SQL Doc

New! SQL Doc 3

Rapidly documenting your entire database schema just became even easier with SQL Doc 3. Includes a new UI, documentation of database- and server-level properties, and greater customization control. Download a free trial now.

Featured Contents

 

Stairway to SQL Server Security Level 3: Principals and Securables

Don Kiely from SQLServerCentral.com

What is a SQL Server principal? And what does it get a permission on? In this stairway level, you’ll learn about the various principals that can be authorized through permissions to perform actions and access securable objects in the SQL Server instance. More »


 

Free eBook: SQL Server Transaction Log Management

Press Release from Red-Gate

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works. More »


 

Automate Registering and Maintaining Servers in SQL Server Management Studio (SSMS)

Additional Articles from MSSQLTips.com

This tip looks at how to use a control file that lists the structure to use within SSMS and a PowerShell script that will automatically maintain the list of registered servers within SSMS. More »


 

SQL Saturday #302 - Albany

Press Release from SQL Saturday

SQL Saturday is coming to Albany, NY on July 26, 2014. This is a free full day of training and networking for SQL Server professionals. This event also features a paid-for precon session with Grant Fritchey on query performance tuning. The event is soon so register while space is available. More »

Question of the Day

Today's Question (by Phil Factor):

Is a Primary Key an index?

Think you know the answer? Click here, and find out if you are right.


We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: Database Design.

We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center.

ADVERTISEMENT

Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions

Optimize your queries—and obtain simple and elegant solutions to a variety of problems—using window functions in Transact-SQL. Led by T-SQL expert Itzik Ben-Gan, you’ll learn how to apply calculations against sets of rows in a flexible, clear, and efficient manner. Ideal whether you’re a database administrator or developer, this practical guide demonstrates ways to use more than a dozen T-SQL querying solutions to address common business tasks. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Jason Whitish):

What will the following query return?

select cast(cast(cast(-2 as varbinary) as tinyint) as int)

Answer: 254

Explanation:
This has to do with the size of your datatype. Tinyint is only 2 bytes, so when it looks at the varbinary value, it only sees part of the value.
You can see this more clearly if you use just the value:
-- -2, -2, and 254

select cast(0xFFFFFFFFFFFFFFFE as int)

select cast(0xFFFFFFFFFFFFFFFE as bigint)

select cast(0xFFFFFFFFFFFFFFFE as tinyint)


-- -2, 4294967294, 254 

select cast(0x00000000FFFFFFFE as int)

select cast(0x00000000FFFFFFFE as bigint)

select cast(0x00000000FFFFFFFE as tinyint)


-- 254, 254, 254

select cast(0x00000000000000FE as bigint)

select cast(0x00000000000000FE as int)

select cast(0x00000000000000FE as tinyint)
Data Type Conversion (http://technet.microsoft.com/en-us/library/ms191530(v=sql.105).aspx):
"You can convert int, smallint, and tinyint to binary or varbinary, but if you convert the binary value back to an integer value, this value will be different from the original integer value if truncation has occurred. For example, the following SELECT statement shows that the integer value 123456 is usually stored as a binary 0x0001e240:"

» Discuss this question and answer on the forums

Featured Script

Create MERGE statements with data!

Jason Selburg from SQLServerCentral.com

Let’s say you want to quickly provide a script to someone that will populate a particular table with data from your database. What if you have 200 tables? This could take some time unless you're using Red Gate's SQL Data Compare, but what if you have no access to the target database? You could certainly use the MERGE statement, but that’s a lot of code to write. What if you could run a script that created a SQL file containing all of the MERGE statements in one file and ready to run, after review of course. 

Well, here's that alternative and hopefully not just something that will help you, but get you thinking about other possibilities with script automation and SQLCMD mode.

SQLCMD mode can be enabled via the SSMS Menu Query > SQLCMDMode or Tools > Options > Query Execution and checking the "By default, open new queries in SQLCMD Mode.

Besides, what self-respecting DBA doesn’t want to know how to do it via SQL?

What data is our best candidate? Well, just about any type, lookup, setup, or static data, etc... 

We use an extended property called "SupportingData" to identify these tables. This script assumes that you have an EP on all of your supporting data tables, but this can be modified to fit your specific selection criterion. 

This script does NOT handle all situations and I'm not advertising it as a complete script. i.e. data types like Text, NTEXT, XML, Image along with those pesky FK dependencies are not addressed. I’m sure there’s a way, it’s just not in this version.

There are many possible applications here, including:

  1. As this was originally designed to be used with SSDT as a method to get our supporting data into source control. Utilizing a small home built VB app to parse the output file into individual files then including these files in your solution and setting the appropriate build action (Pre/Post deploy). POOF! Your data is now in Source Control !   
  2. You can put this into a stored procedure or function to call by a single table name, but you'll have to remove the SQLCMD parts. This would be beneficial if you need MERGES throughout the day during development.

*** This is provided as-is and with any code from the internet TEST, TEST, TEST! The goal in providing this script is to get the majority of the work done for you and for you to tweak as needed.

If you copy he output to a new query window the formatting should be retained.

Comments, suggestions and improvements are always welcome.

Enjoy!

More »

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.

SQL Server 2014 : Administration - SQL Server 2014

Error: The OLE DB provider "SQLNCLI11" for linked server "HELIXDB" supplied inconsistent metadata for a column. The name was changed at execution time. - Hi While trying to run the sql job folowing error is displaying sometimes, but the job is successfully executing some times. JOB: Step...


SQL Server 2014 : Development - SQL Server 2014

sp_send_dbmail truncates when attaching query results. - Installed SQL Server 2014 CU1. While testing sp_send_dbmail I noticed the query results, when attached are cut off or truncated....


SQL Server 2012 : SQL 2012 - General

Availability Group Listener Creation - I have just set a SQL 2012 availability group up, testing it is working and all seems fine. I am not...

Data migration - I have a cluster hosting multiple GP databases and a second for my data-warehouse I am playing around with (personal...

SQL Server Spatial Data - Working with Circles - Hi there, I am not very familiar with working with spatial data and I am currently trying to work out how...

Index Reorg vs Rebuild - Can anyone easily explain if there are disadvantages of doing an index reorg vs a rebuild? I know the best...

Index Reorg vs Rebuild - Can anyone easily explain if there are disadvantages of doing an index reorg vs a rebuild? I know the best...

Can SQL server 2012 BI data tools co-exist with SQL server 2008 BI studio? - After I install SQL server 2012 client tools on my computer that has SQL server 2008 client tools installed, the...

Sql job to execute multiple queries and email - I have to create a SQL job which will run around 50 queries and email results when the query gets...

SSIS - centralized or distributed? - New to SSIS. Looking for direction, white papers, articles that discuss pros and cons, best practices to installing SSIS stand-alone...

UK date in text field as a true date - I have a date held in a varchar field in a temporary sql table and I want to convert it...

Upgrade - SQL Server 2005 Standard SP2 64-bit to SQL Server 2012 Enterprise 64 bit - Hi, [b]Current SQL Server Details- [/b] Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02 Copyright (c) 1988-2005 Microsoft Corporation Standard...

SQL QUERY HELP - Hi guys, How can i get the total number of each distinct value in the column and write it to another...

Datawarhousing -Different types of Dimension table - Hi, i need small help, i know the type of Dimension but can any one give us real time example for...

Locking behavior on indexed views - Hey, I have a question regarding the locking behavior of indexed views. We have a 3rd party application and something like...

Mirroring - Hi experts, what are the commonly used system tables for mirroring

Add additional SQL instance to existing SQL Server 2012/2014 Cluster - HI I just created SQL Server 2012 active/passive two node cluster. Have F:\ Data G:\ Log for this cluster Now I...

SQL 2012 Enterprise licensing - Hi, I am looking for some independent advice on SQL 2012 licensing. If anyone has example pricing and/or actual pricing for...

log write denied when using Maintenance Plan - Hi All Under the maintenance plan, i run full backup at the same path and it was successful. The maintenance plan...

Always On troubles - Ok, I am about at my limit on this. I am trying to set up SQL 2012 Always On. I...


SQL Server 2012 : SQL Server 2012 - T-SQL

Missing Text Data - Thank you to everyone that read my response yesterday. Also Thank you to the guys that gave great comments. I...

Fill in Missing Data - Hello Everyone I hope that you all had a wonderful weekend. I am working with some data that is not so clean....

Composite Index performance - Hello, thanks in advance for any help. I have a large table with 500M records. It has a primary clustered...

Difference between ROWS UNBOUNDED PRECEDING And ROWS BETWEEN 2 PRECEDING AND CURRENT ROW - Hello, What's difference between 'ROWS UNBOUNDED PRECEDING' And 'ROWS BETWEEN 2 PRECEDING AND CURRENT ROW'? In below set of data, how '75,000'...

Distinct and count - SELECT Distinct MAGINUS_SUPPLIER.SUPPLIER_ACCOUNT, MAGINUS_SUPPLIER.SUPPLIER_NAME,MAGINUS_SUPPLIER.ADDRESS1, MAGINUS_SUPPLIER.ADDRESS2, MAGINUS_SUPPLIER.ADDRESS3, MAGINUS_SUPPLIER.ADDRESS4, MAGINUS_SUPPLIER.ADDRESS5, MAGINUS_SUPPLIER.ADDRESS6, MAGINUS_SUPPLIER.POSTCODE, MAGINUS_SUPPLIER.PAYMENT_TERM, MAGINUS_BANK_DETAILS.BANK_SORT_CODE, MAGINUS_BANK_DETAILS.BANK_ACCOUNT_NUM, MAGINUS_BANK_DETAILS.B


SQL Server 2008 : SQL Server 2008 - General

Can't start Analysis Services on cluster after restoring system databases - Hi all, Last night we had a suspected network issue which caused all connections to several of our SQL servers to...

Data format after SQL Server Export to Excel - Hi Foks, I have a task and it is to perform a daily export of data from SQL Server 2008R2 into...

Identify Application Name - Hi guys, Is there any SQL script that I can use to know what application connected to each databases? Thanks!

Need help in retrive the data from openxml. - Hi All, Please read the following query. DECLARE @MyXML XML SET @MyXML = '<Item> <Item accountnumber="900044010163" versionnumber="1" repaymentdate="2013-09-05" /> </Item>' DECLARE @i INT EXEC sp_xml_preparedocument @i...

PIVOT more than two columns - I have data as below in a table Region Transactions Production Value EAST Sales LUX 1000 EAST Sales Cinthol 1500 EAST Purchases LUX 1000 EAST Purchases Cinthol 1500 NORTH Sales LUX 3000 NORTH Sales Cinthol 3500 NORTH Purchases LUX 30

Distinct Statement Mystery - I have a db of Contacts - it's real simple, NAME, ADDRESS, CITY, ST, ZIP, etc... I CAN DO SELECT ST FROM TABLE...

Insert triggering stored proc fails through ODBC with no error - I have a problem and I don't even know where to start Googling. I have two tables, a header and a...

I am just puzzled by this :crazy:? - This is what puzzled me and I can't stop scratching my head and I am wondering if someone can look...

How would I tune this query? - I have this query that I am trying to tune(Just to practice) [quote]SELECT TOP 7401 T270.C1,T270.C18133,T270.C18005,convert(nvarchar(15),B270.CO18004)+N';'+convert(nvarchar(15),B270.CC18004)+N';'+B270.C18004 B270C18004 FROM T270 LEFT OUTER...

Remote Stop / Start - SQL Services - Hello, In joined new environmet, DBA's are responsible of SQL Server Services (e.g. MSSQLSERVER and SQLSERVERAGENT etc.). When there is restart...

backup log TO DISK NUL and Database Mirror - Dears, My database base DB1 is mirrored to another DB1 on another server. I found the size of log file has...

Log files running out of space after rebuild - Hi .... I have an issue after running the rebuild/reorganize index maintenance job based on demand ... the log files grows very...

High Fragmentation Index ... - Hi All, At the moment I am tuning the indexes with high fragmentation ..I created a maintenance plan for rebuild...

OpenRowset Issue - Hi, I am trying to access remote db server's stored procedure and am using openrowset for that. i am aware of...

SSIS Data Flow "bulk insert" VS. INSERT INTO - We are currently pulling in 1+million rows of data for a monthly process, all records processed in the prior month....

Cannot open New SSIS Project in SQL Server 2008 R2 - I installed SQL Server 2008 R2 and Visual Studio 2008. However, after several installations and un-installations. I could no longer...

A fatal error occurred during a full-text population, Event ID: 30059 - Here's the general error I am receiving [quote] A fatal error occurred during a full-text population and caused the population to be...


SQL Server 2008 : T-SQL (SS2K8)

how to write a proc to upload the xml files into above tables - Hi There are two tables in my database HotelList_Temp, AsiaHotelChildrenAges_Temp I need to write a proc to upload the xml...

Converting Integer Values to Datetime - Hi, As a DBA, I am working on a project where an ETL process(SSIS) takes a long time to aggregate and...

Inserting into a self-referencing table using an identity int - Currently our application uses guids. We are in the conversion process of making the database ints. This is a change from...

SQL Query Help needed - Thank you. - Hello Folks, I'm in need of your kind help here, I have two tables listed below, the first table has employees...

Isolating a list with pattern search - Hi, I'm trying to pull up a report of restored databases from our bug tracking software to audit and see if...

merging intervals with identical data - I'm having issues building a cte sql statement for merging intervals and I would greatly appreciate someone helping me out....

Group by performance FK / PK - Hello all, I have something I can't explain, hope some of you can? We have a medium sized database with the next...


SQL Server 2008 : SQL Server Newbies

Need help evaluating my data import procedure. - Noy Hadar - I am new to php and sql, but learning fast. I'm trying to understand the behavior of the db when...

ORDER BY in a view - Hi, I'll keep this as short as possible. I've read many of the posts re: order by in a view (searched...

Configuration Manager; nothing under SQL Server Services - Honestly, I give up. I can't connect to this database as sa ('a network-related or instance-specific error occurred error 40...


SQL Server 2008 : SQL Server 2008 High Availability

Installing named instance on existing cluster - If I install a named instance on an existing cluster, will the named instance need it's own Clsuter Group, with...


SQL Server 2008 : SQL Server 2008 Administration

Possible to alter the location of both the MDF and LDF in one go? - Hopefully this will be a theoratical question and not something I'll need to do frequently (or again!) Yesterday and today, I...

Transaction Log Sequence Broken.... - Hi All, T.log can not be restored on the secondary Database which is due to that transaction log sequence is broken.in...

DB in Recovery Pending - Hi Experts, Our DW database having size 6TB is in recovery pending state because of space issue in that drive. How...

EMC RecoverPoint and SQL Server - We are trying to implement EMC RecoverPoint with SQL clustering. What we had to do at the DR side after syncing...

Failed "ALTER DATABASE...REMOVE FILE" leaves sys.database_files missing a file - From SSMS I removed a secondary file (named tempdev2) in the PRIMARY filegroup of tempdb and lowered the maximum size...


SQL Server 2008 : Data Corruption (SS2K8 / SS2K8 R2)

Column "pobs_name" value is out of range for data type "varchar". Update column to a legal value - Hi All, I recently found (from our weekend maintenance) that one of our vendor databases encountered a corruption notice and am...


Cloud Computing : SQL Azure - Administration

SQL Server Replication to/from Azure SQL Database - I can't find any other posts on this subject so I thought I would start one as a placeholder and...


SQL Server 2005 : Administering

SQL server drive configurations on SAN - Use to be that you broke your database files out to different drives, even on a SAN. D: for data,...


SQL Server 2005 : Business Intelligence

Please suggest - Hi, we get data every week in ms access. It doesn't come in incremental form but comes in full database. I...

SSIS Help with flat text file issues - I have written a stored procedure to create data to a table. I have one column that is giving me...


SQL Server 2005 : Development

Use a select query to assign parameters to a stored procedure - Hi, I have a stored procedure that accepts 3 parameters - Date, Location and Item and returns the details of the last...

Entity Framework - Adhoc queries... - Are any of ya'll using the Entity Framework to develop? I am told that it generates the SQL statements. I am...


SQL Server 2005 : SQL Server 2005 General Discussion

It seems our sql database is corrupted - Hi, is there a way to completely check a SQL-Anywhere database (5.5.05) integrity? "Validate" won't help: we had databases that...


SQL Server 2005 : SQL Server 2005 Integration Services

Importing Poorly Formatted Text File - I am trying to import a text file to a SQL server table using SISS. I use SSIS but this...

Dyncamically change Column lenght in Foreach Loop container of SSIS - Hi All, I'm trying to load data from multiple files into SQL server using Foreach Loop Container in SSIS 2008. All...

adding new data to a table - hi i have two tables. table 1 is [code] PK_GL Section SectionNumber 1 Assets 1 2 Liabilities 2 3 Revenue 3 4 Expense 4 5 Capital 5 [/code] and my second table [code] PK_GL Section Group Financial Account Description Opening Balance Debits Credits Closing Balance Fund Legal Entity FundStructure Code Period End Date AccountName 3487 Test Test Test


SQL Server 2005 : T-SQL (SS2K5)

Concatenating fields into one - Hi all I'm running SQL 2005 with SSMS 2012. I've got a table with the following fields: Visit ID Abstract ID QuerySeqID (Query Sequence ID) Response The...


Reporting Services : Reporting Services

how to fix unknow command error - I created a database with a table based on an output from a finger scanner device, which export a .dat...

ssrs 2008 r2 pass paramter value to a sort - In a new SSRS 2008 r2 report, I am going to be using sql within a dataset and not a...

Exporting SSRS Report to Excel with formulaes Preserved - Hi Team, I have a request to develop a report / template. In which I have some columns where user have to...


Reporting Services : Reporting Services 2005 Development

Error: "The item '/Data Sources' already exists."?! - Hello, I'm the new guy that was tasked with creating a new report. I've created the report and viewed it. It looks...


Reporting Services : Reporting Services 2008/R2 Administration

web page error in report manager in ssrs 2008 - Hi I am working in ssrs 2008 version of reporting and facing problem of refreshing the web page on apply...

Undelying data sets - What would be the best was to use SSRS to export datasets to excel. In some cases - I want to enter...


Reporting Services : Reporting Services 2008 Development

Cannot read the next data row for the dataset - HI, I have SSRS reports in production which were running fine till 11th July. But suddenly in the evening of 11th...


Programming : General

Correct Age calculation - We are using the following to calculate age: It doesn't seem correct ? Any ideas would be great? Thanks Joe INSERT INTO @TEMPTABLE(TAG_NAME,TAG_DATA) SELECT TAG_NAME = 'CUST_AGE',...


Programming : XML

Removing xmlns="" in child tags and elements - Hi There, I had hard time generating xml through a sql stored proc and using it inside ssis package for saving....


Data Warehousing : Integration Services

How to reflect changes in Oracle db tables into SQL Server db? - Hi, Is there a way to just import changes to tables in a live (Oracle 11g) database into SQL Server, rather...

Control Flow: selectively consuming multiple source files - I've got to find a way for my foreach loop container to recognize the difference between file1_2014_06_20 file2_2014_06_20 file3_2014_06_20 and file1_2014_06_21 file2_2014_06_21 file3_2014_06_21 then import just...

Control Flow: differentiating between source files already processed/not processed - I have to import zip files every day from a vendors ftp site who leaves the last 7 days on...

Display an Excel Sheet using SSIS - I have to schedule a job which query the database and generate an excel report and then email the report. I...

output date to mm/dd/yyyy - In my OLE DB Source, I have a SQL command that output a datetime field to "mm/dd/yyyy", however in my...


Data Warehousing : Strategies and Ideas

SQL as a service? How to manage abuse? - Hello, Consider a set of static data of which I want people to run their own queries against. What methods might...

Add column to View or use Named Query in DSV? - I have a Fact table based on a View. Rather than create a Calculated Measure in the front-end BI application...

Bridge solution for multi-valued attribute structure - I've been looking at using a bridge solution to implement multi-valued attributes for a dimension in my data model (education...

optimal server placement - Just took new job, we have one server that has a read-only log shipped copy of major database, it also...


Data Warehousing : Data Mining

data mining using SSAS design question - Hello - I have a design question and want to understand whether my problem could be solved using SSAS data mining...


SQLServerCentral.com : Anything that is NOT about SQL!

any news on sql in the city 2014? - does anyone know if there is any news on whether Sql In THe City is going to be happening this...

Anyone going to SQL Bits 17-19 June Telford ICC, UK - Is anyone going to SQL bits who would like to meet up on the Wednesday or Thursday. @Gail - I know you...

Are the posted questions getting worse? - Is it me, or are the posted questions getting worse these days? I just read a post by someone apparently in...


SQLServerCentral.com : SQLServerCentral.com Website Issues

Checked the right box for QotD, but said I checked a different one? The Case Of the Downward Pointing Arrow - I was wondering if anybody else has experienced this: I was doing the QotD for 7/2/2014 today, and I checked one...

Problems Clicking Through From Email - Hi Having an issue clicking through from the email - every link (I've selected so far) on the site returns the...

Code Tags not working In IE 10.0 - For about a week, the code tags feature has not been working for me in IE 10.0 It's fairly annoying to...

Active Threads link - The Active Threads link is really inconsistent lately. It does not appear most of the time. When this happens the...

Can't Access the articles. - Hello guys, I am getting a error with this "Please verify your registration To read the rest of this article, we...


SQLServerCentral.com : Suggestions

Recent Posts - different icon for threads I've posted in - Hi It would be helpful when looking at the list of recent posts available in the control panel (or an list...


SQL Server 7,2000 : Working with Oracle

Merge in stored procedure - Hello guys, may you help me why my merge in stored procedure have exception? [code="sql"] CREATE OR REPLACE PROCEDURE mySP ( pID IN...


Career : Certification

How to break into data warehouse management - Hi All, I'm hoping I can get some valuable input from people in the field. My current and past jobs have...

This email has been sent to {user_email}. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com.
This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.
This transmission is ©2014 Red Gate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com