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.
2010-09-24 (first published: 2009-05-27)
31,700 reads
Articles
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.
2010-09-24
4,416 reads
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.
2010-09-24
3,860 reads
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
2010-09-23
7,700 reads
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.
2010-09-23
2,779 reads
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?
2010-09-22
2,209 reads
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.
2010-09-21 (first published: 2010-05-17)
5,232 reads
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.
2010-09-21
9,876 reads
Late September Free Training from PASS VCs
The DBA and Virtualization Virtual Chapters hope that last weeks 24 Hours of PASS got you in the mood for more free training. Here's what they have on tap for you this week:
2010-09-21
721 reads
SQL Profiler Through StreamInsight Sample Solution
In this postI show how you can use StreamInsight to take events coming from SQL Server Profiler in real-time and do some analytics whilst the data is in flight. Here is the solution for that post. The download contains Project that reads events from a previously recorded trace file Project that starts a trace and captures events in real-time from a custom trace definition file (Included) It is a very simple solution and could be extended.
2010-09-21
2,192 reads
Blogs
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Questions and Answers from Running a Local LLM
By Steve Jones
I had a few random questions from my Running a Local LLM on Your...
Forums
A question about how to store the address in the database
I have an app that has an address field on the customer and the...
SSIS package failing intermittently on last Excel Component
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers