Dreaming of Clouds
Day four of a "Week in the Clouds" has Steve Jones dreaming of some exciting possibilities for SQL Server and cloud computing.
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.
Blogs
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
AI: Blog a Day – Day 2: Generative AI, Multimodal Systems, and Agent AI
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers