Read this tech brief to discover how SharePlex for SQL Server provides ZeroIMPACT data replication from Oracle to SQL Server, high availability, near real-time SQL Server data integration with other systems, and comprehensive support across datatypes – al
After recently upgrading a SQL Server instance to SQL Server 2012 a few days ago, you noticed that your application is not functioning properly. You decided to roll back the upgrade by downgrading the SQL Server database engine to SQL Server 2008 R2. Aft
One of the benefits of SQL is the ability to write a query and use parameters to dynamically act upon the resultset. Depending on the situation, there can be benefits to parameterizing queries, but it is not always clear when or how to do this. In this t
One issue that I am often faced with is determining what service pack is installed on the SQL Server. Until recently the version of SQL Server that was installed was just a number, but now with the later service releases for SQL Server 2000 you can also
To continue this series on Step-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster, we will look at adding a node to an existing SQL Server 2016 failover clustered instance (FCI).
Some of our developers noticed an issue a few days after celebrating our successful SQL Server 2012 upgrade. When they run a query in SSMS and copy and paste the results to Excel, each row gets split into many rows in Excel instead of one row like it used
SQL Server Reporting Services (SSRS) 2016 introduced Mobile Report Publisher which is intended to develop reports for mobile devices, tablets as well as desktops. It ships with 30 different visualizations that can be used to develop mobile dashboards.
There are times when a SQL Server DBA needs to backup (both schema and data) one or more tables out of a large database, so the table can be restored/recreated in another environment. What kind of methods can I use to backup a SQL Server table?
On June 5, 2006 MSSQLTips.com started with just one tip in an effort to offer solutions to real world SQL Server problems. Ten years later, we never expected MSSQLTips.com to grow into a global community of millions of SQL Server Professionals.