vmware Experts Database program EU, SQL Server Event – Sofia
I was honored to be part of very first & very high professional workshop about the vmware and SQL Server. Among...
2017-04-13
451 reads
Dukagjin Maloku
- Interests: Database Admin & BI
PASS Summit 2016 – call for Speakers…
PASS Summit 2016 is the biggest, largest, highest rated summit in the World for the Microsoft SQL Server & BI professionals,...
2016-02-05
776 reads
Azure SQL DB – technical deployment
Take a look this awesome document for the Azure SQL DB technical deployment with lot of the details that you need...
2016-02-02
484 reads
SQL Saturday Tirana (Albania)
I’m very exciting to announce that we will have next SQL Saturday event in Albania, Tirana, which is going to...
2014-06-19
837 reads
MCSA in 90 days… & lot of resources
Another free resource for learning and gaining your knowledge that might be possible to earn MCSA Certifications with few efforts....
2014-02-12
1,444 reads
SQL Server 2014 CTP2 …ready to download
Announced and available for download the SQL Server 2014 CTP2:
Release Note:
http://msdn.microsoft.com/en-us/library/dn169381%28v=sql.15%29.aspx?lc=1033
Download Location:
http://technet.microsoft.com/en-us/evalcenter/dn205290.aspx
…and something that is very welcome for the community...
2013-10-16
1,407 reads
SQL Server MVP for the 2nd time in row!
I’m honored to be recognized as SQL Server MVP for the 2nd time in row and thank you Microsoft to...
2013-10-16
1,023 reads
2013-07-31 (first published: 2008-07-15)
1,589 reads
Recap of our SQL Saturday #225 in Kosovo, Prishtina
SQL Saturday Kosovo #225, happened last week and I’m very happy that we did for the first time in Balkan...
2013-05-27
1,206 reads
SQL Saturday Kosovo #225
I’m so exciting to announce that the SQL Saturday Kosovo is going to be held on May 18, 2013 and...
2013-03-07
1,077 reads
Blogs
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...
Monday Monitor Tips: Projecting Disk Space
By Steve Jones
One of the things that many DBAs struggle with is managing space across an...
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