Using LAST_VALUE
When I began using LAST_VALUE, the results were not what I expected at all. Read on to learn the secret!
The End of Big Data
What is next for big data? Some experts claim that data "volumes, velocity, variety and veracity" will only increase over time, requiring more data storage, faster machines and more sophisticated analysis tools. However, this is short-sighted, and does not take into account how data degrades over time. Analysis of historical data will always be with us, but generation of the most useful analyses will be done with data we already have. To adapt, most organizations must grow and mature their analytical environments. Lockwood Lyon shares the steps they must take to prepare for the transition.
Consuming JSON Formatted API Data in 2016
Natively consume JSON data from API sources with SQL 2016 and CLR
The Enterprise DBA Mindset as a Practical Problem-solving Approach
In order to keep the demands of the job under control, any DBA needs to automate as many as possible of the suitable tasks that their role demands. What makes a task suitable? How do you judge whether it is worthwhile? Can we take a 'managed', consistent, decision? Joshua Feierman explains the practicalities with a real example.
CU#6 for SQL Server 2014 SP1 Updated
Please re-apply CU#6 for SQL Server 2014 SP1 as it has been updated.
How to Identify Useful SQL Server Table Statistics
In this article, Fikrat Azizov describes the different approaches to maintaining statistics and shows how you can use the data from your servers for intelligent statistics updates.
More Overloads
The overloading of terms creates confusion, which means that communication is more difficult.
Third Party Visuals in Power BI Desktop
Power BI is as extensible as it is powerful In this article you will see how to impress your users with added visuals
Blogs
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
T-SQL Tuesday #199: Back to the on-prem
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...
Forums
BCA KCU PANAKKUKANG Telp/WA:0817844112
phone/Wa, Cs. 0817844112 Jl. Boulevard No.5 Blok F5, Masale, Kec. Panakkukang, Kota Makassar, Sulawesi...
BCA KCU MAKASSAR Telp/WA:0817844112
phone/Wa, Cs. 0817844112 Jl. Ahmad Yani No.31, Pattunuang, Kec. Wajo, Kota Makassar, Sulawesi Selatan...
BCA KCU AMBON Telp/WA:0817844112
phone/Wa, Cs. 0817844112 Jl. Sultan Hairun No.24, Kel Honipopu, Kec. Sirimau, Kota Ambon, Maluku...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers