Land Mines
Security can be a hassle, but Steve Jones talks about why we sometimes put up with the difficulties of implementing strong security.
2008-07-07
51 reads
Articles
SQL Server local disk storage to SANs
Storage area networks (SANs) improve SQL Server performance. Set up SANs on SQL Server with these best practices on migrating to, and configuring SANs.
2008-07-07
4,584 reads
Enough is Enough
When do you decide that enough is enough? When does it make sense to let some bugs go and fix them later? Steve Jones comments on the decisions you sometimes make.
2008-07-06
57 reads
Enough is Enough
When do you decide that enough is enough? When does it make sense to let some bugs go and fix them later? Steve Jones comments on the decisions you sometimes make.
2008-07-06
52 reads
Enough is Enough
When do you decide that enough is enough? When does it make sense to let some bugs go and fix them later? Steve Jones comments on the decisions you sometimes make.
2008-07-06
57 reads
How to Export Data to Microsoft Office Excel 2007 Using SQL Server 2005
This article provides a step by step guide on how to export data to Microsoft Office Excel 2007
2008-07-04
8,937 reads
Managed Data Access Inside SQL Server with ADO.NET and SQLCLR
Using the new SQLCLR feature, managed code can use ADO.NET when running inside SQL Server 2005. Learn about SQLCLR via basic scenarios of in-process data access, SQLCLR constructs, and their interactions.
2008-07-04
2,591 reads
An MVP From Way Down South
Please join us in congratulating one of our longtime community members on MVP status.
2008-07-03
751 reads
2008-07-03
10,708 reads
Happy 4th of July
A blooper collection of mistakes and errors from a variety of editorials on this holiday weekend.
2008-07-03
602 reads
Blogs
Three Ways to Use Snowflake Data in Microsoft Fabric
By James Serra
Organizations increasingly want Snowflake and Microsoft Fabric to coexist without duplicating data or fragmenting...
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 ...
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