Changing Table Schema – what goes behind the scenes – Part II
Part two of his series on table schema changes, this article examines those changes that affect the actual data. Read this great article from Alok Dwivedi.
2009-08-05
5,186 reads
Articles
Foreign Key Constraints Revisited
Full/partial schema refreshes across environments are a regular requirement in databases. This article builds on a previous article, providing scripts to disable and re-enable foreign key constraints on all of the tables in a schema.
2009-08-05
3,175 reads
Installing Hyper-V and Beyond
In his previous article “Hyper-V, an introduction” Jaap Wesselius explained about the Hypervisor, the parent partition, the child partition, and Integration Components. In this article Jaap discusses installing Hyper-V, all kinds of Virtual Hard Disks, Virtual Networks, and some best practices.
2009-08-05
2,325 reads
Placing a Value on Data
What's your stolen data worth? It might be worth investigating, as Steve Jones suggests. Then you'll know how much you should be spending to protect it.
2009-08-05
616 reads
Placing a Value on Data
What's your stolen data worth? It might be worth investigating, as Steve Jones suggests. Then you'll know how much you should be spending to protect it.
2009-08-05
667 reads
Placing a Value on Data
What's your stolen data worth? It might be worth investigating, as Steve Jones suggests. Then you'll know how much you should be spending to protect it.
2009-08-05
447 reads
Gain Space Using XML data type
This article is an attempt to explain the application of new XML support in SQL Server 2005 for efficient data storage and performance.
2009-08-04
4,173 reads
SQL Server Logs - SQL School Video
Did you know that SQL Server maintains a great set of text logs about events on the server? MVP Andy Warren shows you how to get information out of the error logs in this SQL School video.
2009-08-04
9,992 reads
Active August posts
I've started a blog to write down and track my personal goals:
The Goal Keeping DBA
Since Active August is part of reaching my goal...
2009-08-04
1,098 reads
Attribute Discretization: Using the “Clusters” Method
Join BI Architect Bill Pearson as he leads hands-on practice with the “Clusters” discretization method in Analysis Services. In this article we continue to explore attribute discretization, as a part of an extended examination of the dimensional model lying at the heart of the integrated Microsoft Business Intelligence solution.
2009-08-04
2,163 reads
Blogs
Reading SQL Server File Headers with DBCC FILEHEADER
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
OpenClaw- Agentic Engineering
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Forums
What's new in R 4.6
Comments posted to this topic are about the item What's new in R 4.6
Interesting Changes in R
Comments posted to this topic are about the item Interesting Changes in R, which...
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers