SQL Server Error 3257 – Causes and Solution
Overview
While working with SQL server, users may encounters numerous errors in different stages. These errors creates huddles in SQL transactions...
2016-07-12
910 reads
Ganapathi's MSSQLLover
Simple Way to Decrypt SQL Server Stored Procedure
When stored procedures are created in SQL Server, their entire text body is accessible to all those who have the...
2016-05-20
48,658 reads
What's New in SQL Server 2016 Release Candidate 3
Microsoft announced SQL Server 2016 Release Candidate 3 Evaluations
Benefits of SQL Server 2016 Release candidate 3:
Enhanced in-memory performance provide up...
2016-04-16
160 reads
SQL Server Failover Cluster Configuration & its Hardware Compatibility
Introduction
Failover cluster in SQL Server is a type of cluster in which two or more independent servers are interconnected with...
2016-03-29
833 reads
Fixing Maintenance Plan Error code 0x534
Recently I have posted a article in SQLServerCentral on Fixing Maintenance Plan Error code 0x534
Read My Article "Here"
For more updates:
Subscribe for...
2016-03-25
146 reads
Troubleshooting SQL Server Operating System Error 995
Operating System Error Message
Error: 18210, Severity: 16, State:1
BackupMedium::ReportIoError: write failure on backup device ‘VDI_ DeviceID ‘. Operating system error 995...
2016-01-16
14,507 reads
Error: Microsoft .NET framework 3.5 service pack 1 is Required- SQL Server 2014
Read My Article "Here"
Ganapathi varmaSenior SQL Engineer, MCP
For more updates:
Subscribe for Blog posts [Click Here]
Follow FB Page [Click Here]
Follow FB Group [Click Here]
For...
2016-01-12
93 reads
SQL Server 2016 AlwaysOn Availablility Enhancements
In this Article I have listed out SQL Server 2016 AlwaysOn Availability Enhancements.SQL Server 2016 [CTP 3.2] SQL Server 2016 CTP Standard Edition...
2015-12-24
447 reads
What's New in SQL Server 2016, Community Technology Preview 3 (CTP 3.1)
What's New in SQL Server 2016
Benefits of SQL Server 2016:
Enhanced in-memory performance provides up to 30x faster transactions, more than...
2015-12-07
130 reads
Announcing SQL Server Management Studio - November 2015 Release
For Summary On Improvements In the Latest Release
Please go through the below link.
Summary On Improvements In SSMS Nov 2015
To Download...
2015-12-01
75 reads
Blogs
Modifying a Trigger to Capture More Info: #SQLNewBlogger
By Steve Jones
I had someone ask me about using triggers to detect changes in their tables....
SQL Server Agent Jobs: Set It and Forget It?
By Kevin3NF
Useful tips to make your jobs more stable Too many IT teams treat SQL...
From SQL Server to PostgreSQL: A Story of 5 Key SQL Differences
After spending decades working in SQL Server, getting familiar with PostgreSQL felt like traveling...
Forums
One big server with multiple instances, or multiple smaller servers...
We're currently on SQL 2019 and will likely be looking to migrate to a...
Transitioning AlwaysOn Availability Group to Synchronous Commit Mode
Hello, I have a SQL Server with an AlwaysOn configuration consisting of three replicas...
CDC & Azure Managed Instances - Performance degredation
Anyone got any good advice for performance tuning CDC on a Managed Instance? We...
Question of the Day
The Trigger Updated Column(s)
In a trigger, I can use UPDATE() or UPDATED_COLUMNS() to determine which columns were changed. For these functions, which one accepts a column name as a parameter?
See possible answers