sqldbachronicles.blogspot.com

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...

http://sqldbachronicles.blogspot.com/

OVERVIEW OF sqldbachronicles.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

9

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR SQLDBACHRONICLES.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

December

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Thursday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 4.2 out of 5 with 11 reviews

5 star

5

4 star

5

3 star

0

2 star

0

1 star

1

Hey there! Start your review of sqldbachronicles.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.3 seconds

FAVICON PREVIEW

16x16
32x32
64x64
128x128

CONTACTS AT SQLDBACHRONICLES.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

9

SSL

EXTERNAL LINKS

0

SITE IP

74.125.29.132

LOAD TIME

0.317 sec

SCORE

6.2

PAGE TITLE

SQL DBA Chronicles | sqldbachronicles.blogspot.com Reviews

<META> DESCRIPTION

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...

<META> KEYWORDS

1 sql dba chronicles

2 step 1

3 step 2

4 step 3

5 step 4;

6 posted by

7 martin taylor

8 no comments

9 email this

10 blogthis

CONTENT

Page content here

KEYWORDS ON PAGE

sql dba chronicles,step 1,step 2,step 3,step 4;,posted by,martin taylor,no comments,email this,blogthis,share to twitter,share to facebook,share to pinterest,older posts,blog archive,about me,followers

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

SQL DBA Chronicles | sqldbachronicles.blogspot.com Reviews

https://sqldbachronicles.blogspot.com

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...

INTERNAL PAGES

sqldbachronicles.blogspot.com

1

SQL DBA Chronicles: 05/01/2011 - 06/01/2011

http://www.sqldbachronicles.blogspot.com/2011_05_01_archive.html

Help, Hints and Tips learnt along the way as a SQL DBA. Wednesday, 25 May 2011. SQL Server - Difference between installing a "Default Instance" vs a "Named Instance". Difference between installing a "Default Instance" vs a "Named Instance". The benefit of the default instance is that you connect by specifying the server name (eg, MYSERVER), whereas a named instance will require an instance name as well (eg, MYSERVER SQL2005). Monday, 23 May 2011. Check Log Space - DBCC SQLPERF(LOGSPACE) : SQL Server.

2

SQL DBA Chronicles: 11/01/2013 - 12/01/2013

http://www.sqldbachronicles.blogspot.com/2013_11_01_archive.html

Help, Hints and Tips learnt along the way as a SQL DBA. Wednesday, 20 November 2013. SQL Server Agent Alerts. Brent's brilliant and FREE sp Blitz script and Windows App are useful tools to point out any weaknesses in our SQL Server instances. Http:/ www.brentozar.com/blitz/. Brent's sp Blitz script or his nifty Windows App will not only point out these weaknesses in configuration but also suggest how to remedy them too. SELECT message id, severity, text. WHERE language id = 1033;. View my complete profile.

3

SQL DBA Chronicles: 06/01/2011 - 07/01/2011

http://www.sqldbachronicles.blogspot.com/2011_06_01_archive.html

Help, Hints and Tips learnt along the way as a SQL DBA. Wednesday, 29 June 2011. DBCC SHOWCONTIG - Key values indicating fragmentation. This blog shows you which key values to look for in the results of DBCC SHOWCONTIG. DBCC SHOWCONTIG : Viewing fragmentation data. Use DBCC SHOWCONTIG to view how much fragmentation an index has. Use the TABLERESULTS options to get extra columns in the output that describe statistics about the index. When looking at the results of DBCC SHOWCONTIG you should concentrate.

4

SQL DBA Chronicles: 05/01/2015 - 06/01/2015

http://www.sqldbachronicles.blogspot.com/2015_05_01_archive.html

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...

5

SQL DBA Chronicles: 06/01/2013 - 07/01/2013

http://www.sqldbachronicles.blogspot.com/2013_06_01_archive.html

Help, Hints and Tips learnt along the way as a SQL DBA. Wednesday, 26 June 2013. Where is 'Performance and Reliability Monitor'. Where is 'Performance and Reliability Monitor'. Have you got Windows Server 2008 R2 or Windows 7 and wondering where the 'Performance and Reliability Monitor' option has gone. Well, the tool has been upgraded and is now called 'Windows Resource Monitor.'. Where is this fabled creature called 'Windows Resource Monitor'? You'll find it here:. Windows 7 and Windows Server 2008 R2.

UPGRADE TO PREMIUM TO VIEW 4 MORE

TOTAL PAGES IN THIS WEBSITE

9

OTHER SITES

sqldba.no

www.sqldba.no | Bunnsolid SQL Server kompetanse!

Bunnsolid SQL Server kompetanse! Rådgivning innenfor SQL drift og utvikling. Optimalisering av SQL Server. Kundereferanser SQL kurs og oppdrag. Kurs i SQL Server 2016. Overvåking av SQL Server og databaser. Rådgivning innenfor SQL drift og utvikling. Optimalisering av SQL Server. Kundereferanser SQL kurs og oppdrag. Kurs i SQL Server 2016. Overvåking av SQL Server og databaser. Kundereferanser SQL kurs og oppdrag. Thor Vestaberg fra Keyforce AS, Oslo. Ganske Enkelt AS, Drammen. Applikasjoner / apper hand...

sqldba101.com

Coming soon

sqldba911.com

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.

sqldbablog.wordpress.com

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...

sqldbacademy.com

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...

sqldbachronicles.blogspot.com

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...

sqldbadiaries.com

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...

sqldbadmin.codeplex.com

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.

sqldbadmin.com

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.