Database management: what’s in it for me?
Meet Lisa; she’s a marketing manager with an international travel company. She recently bought a new handbag online. She’d spotted...
2019-03-04
395 reads
Danny Riebeek
- Interests: SQL Monitoring
- Website: https://www.sqltreeo.com
Database management: what’s in it for me?
Meet Lisa; she’s a marketing manager with an international travel company. She recently bought a new handbag online. She’d spotted her favorite brand, in the right color and at...
2019-03-04
8 reads
SQLTreeo SSMS Add-In guide
SQLTreeo Add-In plugin for SQL Server Management Studio Version Applies to SQLTreeo Add-In version 0.8.7 or higher. Purpose Informational guide...
2019-02-25
218 reads
SQLTreeo SSMS Add-In guide
SQLTreeo Add-In plugin for SQL Server Management Studio Version Applies to SQLTreeo Add-In version 0.8.7 or higher. Purpose Informational guide on how to use the...
2019-02-25
107 reads
SQLTreeo Add-In guide
SQLTreeo Add-In Plugin for SQL Server Management Studio Version Applies to SQLTreeo Add-In version 0.8.7 or higher. Purpose Informational guide...
2019-02-19
250 reads
SQLTreeo Add-In guide
SQLTreeo Add-In Plugin for SQL Server Management Studio Version Applies to SQLTreeo Add-In version 0.8.7 or higher. Purpose Informational guide on how to use the SQLTreeo...
2019-02-19
78 reads
Four ways good database management can boost your business
Whatever industry you work in, you will almost certainly have come across a story about how data is transforming your...
2019-02-18
232 reads
Four ways good database management can boost your business
Whatever industry you work in, you will almost certainly have come across a story about how data is transforming your sector. That might be helping to cure a disease...
2019-02-18
4 reads
What’s the one thing you must do to win the trust of customers?
We’re all spending much more time in the digital world. Ecommerce continues to grow in popularity and we all benefit...
2019-01-23
191 reads
What’s the one thing you must do to win the trust of customers?
We’re all spending much more time in the digital world. Ecommerce continues to grow in popularity and we all benefit from the convenience of booking holidays and paying bills...
2019-01-23
6 reads
Blogs
Extending a SQL Server Failover Cluster Across Regions in Google Cloud Platform (GCP)
By davebem
I was the principal author of this SIOS whitepaper, which describes how to build...
Heading to 2024 PASS Summit
By Brian Kelley
I am able to head back to Seattle for the PASS Summit this year....
Tell me the positives of your solution
By Brian Kelley
I still have a tendency to talk about all the cons of a proposed...
Forums
The Cloud Security Problem
Comments posted to this topic are about the item The Cloud Security Problem
Virtualizing AWS data by using Fabric Shortcuts: Data Engineering with Fabric
Comments posted to this topic are about the item Virtualizing AWS data by using...
Timescale Brings PostgreSQL into the GenAI Era with pgai Vectorizer
Comments posted to this topic are about the item Timescale Brings PostgreSQL into the...
Question of the Day
The LAGging NULL
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