Alwayson availability groups failover monitoring - Part 1
There are a lot of ways to monitor AG, sql server errorlog, window event log, cluster log......, here I list...
2013-08-04
6,568 reads
Gap issue in SQL Server 2012 IDENTITY column
Found a gap issue when using IDENTITY column in SQL Server 2012, every time I restarted sql server service, the current...
2013-07-23
3,752 reads
Find out orphan database file on disk
Sometimes you detach databases, or you delete a database which is in restoring status, the data and log file will...
2013-07-09
2,354 reads
trace flag for backup and restore operation
1. 3004
show the internal backup/restore operation for every step.
ex.
dbcc traceon(3004,3605,-1)
GO
3605 means output the message to errorlog. you can use 3604...
2013-07-02
4,624 reads
SQL Server 2012 AlwaysOn Availability Groups setup scripts - Part 1
Here are some scripts which can be used for setting up 2 nodes AlwaysOn Availability Groups, you can make your own...
2013-06-25
2,539 reads
SQL Server 2012 AlwaysOn Availability Groups setup scripts - Part 2
3. Install SQL Instance
a) Configure the firewall setting on both 2 nodes.
echo Default Instance
netsh advfirewall firewall add rule name="SQLServer"...
2013-06-25
2,115 reads
SQL Server 2012 AlwaysOn Availability Groups setup scripts - Part 3
4. Setup 2 nodes alwayson availability group
a) Enable alwayson on both 2 nodes
enable-sqlalwayson -Path "SQLSERVER:\SQL\SQL2012-01\DEFAULT"
enable-sqlalwayson -Path "SQLSERVER:\SQL\SQL2012-02\DEFAULT"
b) Restore...
2013-06-25
2,257 reads
Huge collection of Free Microsoft eBooks
I must share it, there are many useful resource
http://blogs.msdn.com/b/mssmallbiz/archive/2013/06/18/huge-collection-of-free-microsoft-ebooks-for-you-including-office-office-365-sharepoint-sql-server-system-center-visual-studio-web-development-windows-windows-azure-and-windows-server.aspx?Redirected=true
http://blogs.msdn.com/b/mssmallbiz/archive/2012/07/27/large-collection-of-free-microsoft-ebooks-for-you-including-sharepoint-visual-studio-windows-phone-windows-8-office-365-office-2010-sql-server-2012-azure-and-more.aspx
http://blogs.msdn.com/b/mssmallbiz/archive/2012/07/30/another-large-collection-of-free-microsoft-ebooks-and-resource-kits-for-you-including-sharepoint-2013-office-2013-office-365-duet-2-0-azure-cloud-windows-phone-lync-dynamics-crm-and-more.aspx
Thank you , Eric
2013-06-21
1,958 reads
use Table Variables in transaction
when using table variable, please note table variable doesn't support transaction rollback. here is the words from BOL
Because table variables...
2013-06-20
2,773 reads
Limit running Powershell script under specific path with AppLocker
Say if you have a management server or a script repository server, sometimes users save/test/run their script from different path,...
2013-04-28
1,377 reads
Blogs
Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
KDA: Echoes of Deception - Case 4
By Zikato
Someone hacked Digitown's municipality and stole classified documents. 45 million rows of router traffic,...
EightKB 2026 – Schedule and Registration
Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced!...
Forums
Displaying Money
Comments posted to this topic are about the item Displaying Money
The Slow Growing Problems
Comments posted to this topic are about the item The Slow Growing Problems
Calculating the Harmonic Mean in Power BI
Comments posted to this topic are about the item Calculating the Harmonic Mean in...
Question of the Day
Displaying Money
I want to get the currency sign displayed with my amount stored in a money type. Does this work?
DECLARE @Amount MONEY; SET @Amount = '?1500'; SELECT CAST( @Amount AS VARCHAR(30)) AS EurosSee possible answers