SQL Server: Functions vs. Stored Procedures to return result sets
A while back, I was building the database schema for a web application which had some reporting functionality and among...
2017-04-19
8,589 reads
SQL Server: DATETIME vs DATETIME2
When it comes to a choice between data types for a field in a SQL Server database's table, an issue...
2017-02-06
1,570 reads
Fastest way to create and distribute a dynamic report from SQL Server
From request to delivery in 5 minutes or less! xSQL RSS Reporter for SQL Server enables you to generate standard...
2017-01-18
170 reads
Tables can't be compared
"I am trying to compare two databases and xSQL Data Compare has marked all table pairs with a red X and...
2017-01-11
166 reads
Database synchronization in the Software Development Life Cycle
Reading the title, most of you are probably thinking: What does database synchronization have to do with the Software Development...
2016-12-12
715 reads
Documenting databases
Open any book or article about database development and administration, and I can all but guarantee that you will find...
2016-12-01
303 reads
Comparing and synchronizing Oracle databases
Applies to: xSQL Oracle Data Compare v1.0 - 2.0
As you may have noticed, most of the articles in this blog focus...
2016-11-22
534 reads
How to deploy your SQL Server database to a remote server
CASE 1: you have direct access to both the SQL Server where the source database is and the SQL Server...
2016-11-11
941 reads
Comparing xSQL Schema Snapshots
Applies to: xSQL Schema Compare v7.0.0 – 9.0.2
Before I develop a scenario where xSQL Schema Compare snapshot comparison is necessary let’s...
2016-11-07
335 reads
Why is SQL Server scanning the clustered index when I have an index on the column I am filtering on?
*Originally published in our old blog on January 2009
I ran into a very simple SQL Server performance related question the...
2016-11-02
175 reads
Blogs
Clustering SAP #ASCS and #ERS on #AWS using Windows Server Failover Clustering
When ensuring high availability for SAP ASCS and ERS running on WIndows Server, the...
Ethics in Modern Data at the Baton Rouge Analytics and Intelligence Network (BRAIN)
By Will Assaf
On July 27, Christine and I will present our joint presentation on Ethics in...
Heading Font Weights and List View Toggles Arrive in Block Editor and WordPress 5.8
By todd-32417
With the WordPress 5.8 release, we're starting to introduce features that overall improve your...
Forums
convert hours into decimal
i have a formula that calculates the difference between two dates and tells me...
Get charges percentage per entity\channel
I trying to figure out what percentage of the total charge for a ME...
How to find islands and get max and min range values
I am trying to create groups for each Name and save the max and...
Ask SSC