Got this error below while attempting to run DQC – Data Quality Client – which previously worked on this SQL Server which had previously an ok/verified DQS – Data Quality Server installation. Error text: SQL Server Data Quality Services ——————————————————————————– Message Id: LogOnWindowFailedToConnect Cannot connect to <SERVER>. A .NET Framework error occurred during execution of […]
For SQL 2014/2016: Concise guide here: Quick Start: Extended events in SQL Server – click here Root URL on extended events – click here.
“KB Articles: KB3194714 Security bulletins:SQL Server 2014 MS16-136 Security issues have been identified in SQL Server 2014 Service Pack 2 that could allow an attacker to compromise your system and gain control over it. You can help protect your computer by installing this update from Microsoft. After you install this item, you may have to […]
Click here for the download link for Microsoft SQL Server Data Tools – Business Intelligence for Visual Studio 2013 – this installs Microsoft SQL Server Data Tools Business Intelligence project templates for Analysis Services, Integration Services, and Reporting Services that support Visual Studio 2013, SSIS 2012/2014 etc.
“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 […]
Below are reference links to Microsoft documentation web pages listing deprecated database features from SQL 2005 to SQL 2014…. 2005 http://msdn.microsoft.com/en-us/library/ms143729(v=sql.90).aspx 2008 http://msdn.microsoft.com/en-us/library/ms143729(v=sql.100).aspx 2012 http://technet.microsoft.com/en-us/library/ms143729(v=sql.110).aspx 2014 http://msdn.microsoft.com/en-us/library/ms143729(v=sql.120).aspx
Click here for TechEd North America 2014 Video Prep Sessions now available online.
One important thing to note, if you choose to install this CTP is that it will not install on a host with other SQL server instances as shown below, after a check – SQL Server System Configuration Check.