Our Ginger Slides’ Primer – Thinking To Move Your Data From On-Premise SQL Server to AWS DynamoDB?
The benefits of running databases in the AWS are compelling but how do you get your data there? In this...
2017-11-14
391 reads
The benefits of running databases in the AWS are compelling but how do you get your data there? In this...
2017-11-14
391 reads
I know we are living in a world where phones and other devices with advanced biometric authentication have been increasingly...
2017-11-10
300 reads
In the big-data ecosystem, it is often necessary to move the data from Hadoop file system to external storage containers...
2017-11-06
339 reads
With some applications, there may be a need to pull data from other database instances, or from other databases within...
2017-07-06
744 reads
Using SSH keys provide a more secure way of logging into a remote computer when compared to password authentication, and today...
2016-12-10
371 reads
In this post, let’s learn how to use chgrp and chown commands to change group and user ownership of a...
2016-12-07
337 reads
We are happy to announce the birth of DataGinger. Starting today we officially re-branded ourselves as DataGinger.com (previously SQLServerZest.com). The...
2016-07-15
387 reads
Disk space is one of those things that frequently runs out of space no matter how much you bump it...
2016-06-09
1,307 reads
Starting with SQL Server 2012, AlwaysOn Availability Groups provided group level high availability for any number of databases for multiple...
2015-10-01
1,403 reads
Read-only routing refers to the ability of SQL Server to route incoming read-intent connection requests, which are directed to an...
2015-10-01
451 reads
By davebem
I was the principal author of this SIOS whitepaper, which describes how to build...
By Brian Kelley
I am able to head back to Seattle for the PASS Summit this year....
By Brian Kelley
I still have a tendency to talk about all the cons of a proposed...
Comments posted to this topic are about the item The Cloud Security Problem
Comments posted to this topic are about the item Virtualizing AWS data by using...
Comments posted to this topic are about the item Timescale Brings PostgreSQL into the...
I have this data in a SQL Server 2022 table:
player yearid team HR Alex Rodriguez 2012 NYY 18 Alex Rodriguez 2013 NYY 7 Alex Rodriguez 2014 NYY NULL Alex Rodriguez 2015 NYY 12 Alex Rodriguez 2016 NYY 9If I run this code, what are the results returned in the hrgrowth column?
SELECT player , yearid , hr , hr - LAG (hr, 1, 0) IGNORE NULLS OVER (ORDER BY yearid) AS hrgrowth FROM dbo.playerstats;See possible answers