We said: "Get ye down all from here; and if, as is sure, there comes to you Guidance from me, whosoever follows My guidance, on them shall be no fear, nor shall they grieve.
http://sqldbacvstockholm.wordpress.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Tuesday
LOAD TIME
1.3 seconds
16x16
PAGES IN
THIS WEBSITE
13
SSL
EXTERNAL LINKS
0
SITE IP
192.0.78.12
LOAD TIME
1.266 sec
SCORE
6.2
Word Of The Day | We said: "Get ye down all from here; and if, as is sure, there comes to you Guidance from me, whosoever follows My guidance, on them shall be no fear, nor shall they grieve. | sqldbacvstockholm.wordpress.com Reviews
https://sqldbacvstockholm.wordpress.com
We said: "Get ye down all from here; and if, as is sure, there comes to you Guidance from me, whosoever follows My guidance, on them shall be no fear, nor shall they grieve.
sqldbacvstockholm.wordpress.com
High Availability | Disaster Recovery solutions in SQL 2012 | Word Of The Day
https://sqldbacvstockholm.wordpress.com/2014/06/13/high-availability-disaster-recovery-solutions-in-sql-2012
Word Of The Day. We said: Get ye down all from here; and if, as is sure, there comes to you Guidance from me, whosoever follows My guidance, on them shall be no fear, nor shall they grieve. BI – SSRS. BI – SSIS. High Availability Disaster Recovery solutions in SQL 2012. Solutions in SQL 2012. Start with, it is important to outline some key terminology. RLO ( Recovery Level Objective): This objective defines the granularity with which you must be able to recover data whether you must be able to recover th...
Hive – Hadoop | Word Of The Day
https://sqldbacvstockholm.wordpress.com/2014/11/06/hive-hadoop-no-sql
Word Of The Day. We said: Get ye down all from here; and if, as is sure, there comes to you Guidance from me, whosoever follows My guidance, on them shall be no fear, nor shall they grieve. BI – SSRS. BI – SSIS. Hive – Hadoop. Hive – Hadoop. Hive (not HIV Disease, this something different🙂 ) HIVE is a framework that sits on top of core Hadoop. It acts as a data warehousing system on top of HDFS and provides easy query mechanisms to the underlying HDFS data. 1 Download and install the Hive ODBC Driver.
BI – SSIS | Word Of The Day
https://sqldbacvstockholm.wordpress.com/microsoft-sql-server-integration-services-ssis-help-bi-ssis-ssas-bi-ssas-cube-with-mdx-adx-data-flow-task-mdx-queries-dt_wstr-to-dt_str-or-dt_numeric-multidimensional-expressions-mdx-querying-multid
Word Of The Day. We said: Get ye down all from here; and if, as is sure, there comes to you Guidance from me, whosoever follows My guidance, on them shall be no fear, nor shall they grieve. BI – SSRS. BI – SSIS. BI – SSIS. SSAS Cube with MDX. Need to set Format=Tabular in the Data Link Extended Properties. Green color is what you will see once you set Format=Tabular in the Data Link Extended Properties. SSIS that data type DT WSTR (nvarchar) will be used instead. Data Analysis Expressions. Here is an...
Installing Mirror Setup in a SQL Server 2012 | Word Of The Day
https://sqldbacvstockholm.wordpress.com/2014/08/06/installing-mirror-setup-in-a-sql-server-2012
Word Of The Day. We said: Get ye down all from here; and if, as is sure, there comes to you Guidance from me, whosoever follows My guidance, on them shall be no fear, nor shall they grieve. BI – SSRS. BI – SSIS. Installing Mirror Setup in a SQL Server 2012. SQL Server 2012 in a Mirror. Select Manage — Add Roles and Features, i used as sp sql1. Install .NET Framework 3.5 Features. The installation has completed. Download and attach media (run from DVD). SQL Server 2012 SP1 Enterprise Edition. I keep the d...
MS SQL 2014 | Word Of The Day
https://sqldbacvstockholm.wordpress.com/ms-sql-2014-sr-sqldba-data-architect-systemforvaltare-databastekniker-it-konsult-drift-systemansvarig-it-infrastruktur-forvaltare-data-architect-sap-bi-stockholm-sweden-sql-dba-data-architect-databas
Word Of The Day. We said: Get ye down all from here; and if, as is sure, there comes to you Guidance from me, whosoever follows My guidance, on them shall be no fear, nor shall they grieve. BI – SSRS. BI – SSIS. SQL Database Engine Instances – 2014. Describes how to configure the properties of an instance. Configure defaults such as file locations and date formats, or how the instance uses operating system resources, such as memory or threads. Configure Database Engine Instances (SQL Server). Describes h...
TOTAL PAGES IN THIS WEBSITE
13
sqldba911 home
Emergensy solutions for your sql databases. MS SQL 6.0 MS SQL 7.0 MS SQL 2000 MS SQL 2005 MS SQL 2008. Clustering replication log shipping mirroring. Backup/recovery performance tunning maintenance. If you are lazy to google them yourself. We deliver complex solution to your problems, not only by fixing the issue but by elimianating the cause of it. We are offering our expertise with Microsoft SQL Server database architecture and design, which will help your business even if you have specialists on site.
Aaron Mathison's SQL Server Blog | Writing about SQL Server related topics
Aaron Mathison's SQL Server Blog. Writing about SQL Server related topics. Productivity Tip: ClipX Clipboard History Manager. April 18, 2011. This post was written originally for my personal blog, but I decided to re-post it here since it is a different audience and the tip is probably more useful to the more technical readers I hope to have here. Enjoy! The other day I was at work and I realized how much time this tiny little application called ClipX. As helpful as I do! SQLSaturday 71 – Boston. Among o...
SQL DBAcademy | .Net and SQL training – Developers and DBAs
Net and SQL training – Developers and DBAs. Selecting data from large set. July 13, 2015. So once again I was given the task of optimizing a proc. After going through my check list , the proc was still not behaving . As a last resort I was inclining towards adding indexes but then my eyes fell on one of the books on rack – ART of SQL. Bingo! I should try rewriting the proc. Learnings : Decide whether you want to INCLUDE data or EXCLUDE data – which one would require less efforts. June 11, 2015. Now If yo...
SQL DBA Chronicles
Help, Hints and Tips learnt along the way as a SQL DBA. Monday, 18 May 2015. WSS Logging Sharepoint Database Size Reduction. Has your Sharepoint WSS Logging database grown massive. See the links below on how to shrink the size of the WSS Logging database. Https:/ guidesharepoint.wordpress.com/2014/03/03/how-to-reduce-the-size-of-logging-database-and-how-to-purge-the-old-data-from-logging-database/. If you need to shrink the database after you have changed the Sharepoint retention settings:. Simple templa...
sqldbacvstockholm.wordpress.com
Word Of The Day | We said: "Get ye down all from here; and if, as is sure, there comes to you Guidance from me, whosoever follows My guidance, on them shall be no fear, nor shall they grieve.
Word Of The Day. We said: Get ye down all from here; and if, as is sure, there comes to you Guidance from me, whosoever follows My guidance, on them shall be no fear, nor shall they grieve. BI – SSRS. BI – SSIS. Cloud based AlwaysOn AG. Microsoft Azure, you need the following:. A virtual network setup in Azure. A storage account setup. A Microsoft Azure domain controller. One or more Microsoft Azure Virtual Machines with SQL Server 2014 installed and configured for AlwaysOn Availability Group. A SQL Serv...
SQL DBA Diaries of Pradeep Adiga
SQL Server DBA Diaries. No transaction is active message when accessing Linked Server. Last week I had worked on an issue related to Linked Server. The customer had migrated the SQL Server Instances to Virtual Servers. They had quite a few Linked Servers setup. After migration any Distributed Transaction like the one below across the linked servers would fail immediately. Select * from RemoteServer.DBName.dbo.TableName. Msg 7391, Level 16, State 2, Line 2. This problem typically occurs if one of the syst...
SQL DB Administrator - Home
Project Hosting for Open Source Software. By clicking Delete, all history, comments and attachments for this page will be deleted and cannot be restored. Change History (all pages). Web based administrator for SQL Server 2005. Last edited Nov 27, 2009 at 6:17 PM. Opera does not support ClickOnce X. To install this application, save it and then open it. Opening it directly from Opera will not work correctly. SQL DB Administrator Release 1.0. Tue Mar 4, 2014 at 7:00 AM. Version 8.4.2015.21029.
404 Not Found
The requested URL was not found on this server. Apache/2.0.50-dev (Unix) Server at 199.244.53.205 Port 80.
SQLDBAgeeks
Thursday, June 11, 2015. Troubleshooting MS SQL 2005 Mirroring. Principal: Backup database FULL recovery. Mirror: restore database with NORecovery mode. Mirror : restore all transaction logs. Principal : Right click database and click mirroring. Principal : add Principal DNS name and Mirror DNS name. Principal: click start mirroring. NDPOINT: Mirroring TO public. Turn off Windows firewall (normal port is 5022). Delete endpoints (the end points are on both Principal and Mirror). Tuesday, March 4, 2014.
Home Page
MS SQL Server 2008 R2 features. How to change the default port in MS SQL server - . Am I seeing double - Find duplicates in a sql tabl. Upgrade service pack on a MS SQL 2000 cluster. Take advantage of over 4 GBs memory in MS Sql ser. Recovering from corrupt master (system) in MS SQL . Learn to kill blocks in MS SQL Server 2000. Find your IP address. Find you MS SQL server version. HOW to run an MS SQL trace. The new version on SQL 2008 has many new useful features. SQl server is better than Mysql.
