Moving Database Files Detach/Attach or ALTER DATABASE?
Learn why ALTER DATABASE should be preferred over Detach/Attach for moving database files on the same SQL Server from MVP Jonathan Kehayias.
Mission Critical: SQL Server Upgrade
You're faced with the task of doing a SQL Server Upgrade? Do you know all the steps, and the right order to do them? You do? Even with interruptions and distractions? Maybe, but it is wise to be able to refer to the Mission-Critical Task checklist.
Setting up your own free Virtualized test environment
If you need to test new software, configurations, patches or operating systems, a virtual machine saves time, risk and hardware. You can set up a virtual test environment for free with some products such as VMware Server 2. All you need is a simple set of instructions about how to set it up; and here it is, thanks to Sean Duffy.
Community Direction
Steve Jones wishes that Microsoft had a way for the community to give better feedback about what we see as a priority in the next version of SQL Server.
Fun with business days, calendar tables, and test-driven development
We shall discuss how to
build a calendar table, and use it in calculations involving business days
Configuring Proactive Caching in SQL Server
Proactive caching helps DBAs to better control the cube data automatic refresh frequency, offering near real-time data for reports. This article covers the settings for HOLAP and ROLAP, and configuring proactive caching.
What Do We Need in SQL Server?
Steve Jones asks us today about what we might like to see in the next few versions of SQL Server.
Renaming SQL Server Policy-Based Management Policies
I have created several policies using Policy-Based Management and need to rename some of them. I don’t see an option in the GUI to rename a Policy. Is there any way I can rename them without dropping and recreating them?
Five Things I Learned at the PASS Summit
Steve Jones has attended the PASS Summit almost every year, and in that time he's learned a few things. He shares a few today that might convince you or your boss that it's worth funding the trip this year.
fn_fixeddrives() : an alternative for xp_fixeddrives
The idea is to create a SQLCLR table valued function that returns all information on drives in a UNIX df-like style.
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCU SOEKARNO HATTA Telp:Cs.08216977726
Whatsapp:08216977726 Jl. Soekarno-Hatta No.240, Kb. Lega, Kec. Bojongloa Kidul, Kota Bandung, Jawa Barat 40227
BCA KCP Pademangan Telpon. 08388331767
WhatsApp 08388331767 Gg. 21 dan 22 No.1, Pademangan Tim., Kec. Pademangan, Jkt Utara, Daerah...
BCA KCP Trunojoyo No.Telpon:083135765355
By CHERRYWIFARM- The Best CBD flowers Europe - Wholesale Hemp Flowers Europe
Whatsapp:083135765355 Jl. Trunojoyo No.145, Kauman, Kepatihan, Kec. Kaliwates, Kabupaten Jember, Jawa Timur 68137
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers