Poll: Weekly survey: does size really matter - or is it what you do with it?
Join in this week's poll from SQL Skills. Let us know how your databases are laid out.
The LEVEL_NUMBER Member Property
BI Architect Bill Pearson introduces the LEVEL_NUMBER intrinsic member property, supported by SQL Server 2005 Analysis Services, and leads a hands-on exercise providing sample uses.
You thought SQL Server ate up memory…
Often I tell clients better to much memory than too little. This can be applied to any database engine essentially. If your data set is growing over time you will end up using any memory that is not consumed today.
Large Analysis Database Migration
large Analysis Database migration (hundreds of gigabytes, hundreds of users and thousands of user MDX queries)
Shapes in the Clouds
Continuing on with his week in the clouds, Steve Jones looks at how SQL Server might appear in the cloud world.
Auto generate change scripts in SQL Server Management Studio (SSMS) for tables
This tip shows you an option that exists within SSMS to automatically generate scripts for all table changes when using the table designer.
Becoming a Google Earth
Continuing on with a "Week in the Clouds", today Steve Jones discusses some of the challenges of cloud computing.
Becoming a Google Earth
Continuing on with a "Week in the Clouds", today Steve Jones discusses some of the challenges of cloud computing.
Becoming a Google Earth
Continuing on with a "Week in the Clouds", today Steve Jones discusses some of the challenges of cloud computing.
The challenges of SQL Server consolidation
Despite the benefits of SQL Server consolidation, some IT pros are still reluctant to make the move. Learn which scenarios could pose a challenge to those looking to consolidate.
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