2008-05-14
31 reads
Articles
Modifying Microsoft Access Linked Tables from SQL Server
In a previous tip we saw how easy it was to link to SQL Server tables from Microsoft Access. As is the case with all systems, how does Access manage the changes? What happens when you modify the structure of the underlying SQL Server table? What happens to the SQL Server table if you delete the linked table in Access? We will look at each of these situations in this tip.
2008-05-14
3,960 reads
2008-05-13
8,464 reads
Encrypting Data
Encrypting data is the easy part of dealing with encryption and databases. Steve Jones talks about some of the other, more difficult, issues you must handle.
2008-05-13
39 reads
Encrypting Data
Encrypting data is the easy part of dealing with encryption and databases. Steve Jones talks about some of the other, more difficult, issues you must handle.
2008-05-13
41 reads
Encrypting Data
Encrypting data is the easy part of dealing with encryption and databases. Steve Jones talks about some of the other, more difficult, issues you must handle.
2008-05-13
35 reads
Essential Steps for the Integrated Enterprise Data Warehouse, Part 1
This article provides guidance to what an integrated EDW is and what design elements are needed to achieve integration.
2008-05-13
2,998 reads
SQL Server Management Studio Reports and Dashboard
This article examines the built in reports called SQL Server Management Studio Reports and an additional add-on called Performance Dashboard.
2008-05-13
5,062 reads
Mirrored Backups
One very interesting new feature in SQL Server 2005 is the ability to run backups to multiple locations, ensuring you have a second copy of the backup file if your first one were to be corrupted. SQL Server expert Andy Warren takes a look at how this feature works and the implications of using it.
2008-05-12 (first published: 2007-06-12)
8,476 reads
Moving Databases
SQL Server trainer and longtime expert, Andy Warren brings us a great article on one basic skill that every DBA should know.
2008-05-12
12,606 reads
Blogs
Deploying an Updated Model with SQL Compare 16
By Steve Jones
In a previous post, I deployed a model to a database using SQL Compare...
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022
By SQLPals
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022 ...
Looking Back at the Redgate 2026 Company Kickoff
By Steve Jones
Last week I spent a few days in Cambridge, UK for the Redgate Company...
Forums
Create filegroups in partition
I have a table with partition on create_timestamp field. Though we're storing all data...
Adding and Dropping Columns II
Comments posted to this topic are about the item Adding and Dropping Columns II
Leveraging DuckDB for OLAP Workloads: The Fabric Modern Data Platform
Comments posted to this topic are about the item Leveraging DuckDB for OLAP Workloads:...
Question of the Day
Adding and Dropping Columns II
I have this table in my SQL Server 2022 database:
CREATE TABLE [dbo].[CityList] ( [CityNameID] [int] NOT NULL IDENTITY(1, 1), [CityName] [varchar] (30) , [Country2] [char] (3), [stateprovince2] [char] (2), [Country] [char] (3), [stateprovince] [char] ) ON [PRIMARY] GOI decide to drop the stateprovince2 and country2 columns. What code should I use? See possible answers