While reviewing the new features in SQL Server 2008, we noticed Transparent Data Encryption. This sounds very interesting. Could you provide us with an explanation and the details to implement it?
2008-06-17
3,326 reads
Learn storage area network (SAN) basics that SQL Server DBAs must know. Understand SQL storage concerning RAID levels, redundancy and snapshots vs. backups.
2008-06-16
5,193 reads
SQL Server 2008 February CTP introduces a new feature, SQL Server Audit. This feature facilitates auditing of Database Engine events by providing simple T-SQL statements to enable, store, and view audits on server and database objects. Part 1 of this series focuses on the server level events.
2008-06-16
2,860 reads
Money. It's part of the reason why we all work, though hopefully not all of it. Steve Jones comments a bit on financial matters.
2008-06-16
51 reads
Money. It's part of the reason why we all work, though hopefully not all of it. Steve Jones comments a bit on financial matters.
2008-06-16
46 reads
Money. It's part of the reason why we all work, though hopefully not all of it. Steve Jones comments a bit on financial matters.
2008-06-16
38 reads
Steve Jones talks about being right versus being effective in your IT work.
2008-06-14
32 reads
Steve Jones talks about being right versus being effective in your IT work.
2008-06-14
43 reads
Steve Jones talks about being right versus being effective in your IT work.
2008-06-14
30 reads
Steve Jones looks back at the news of the past, including a look at RC0, the latest release of SQL Server 2008.
2008-06-14
212 reads
By Steve Jones
In a previous post, I deployed a model to a database using SQL Compare...
By SQLPals
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022 ...
By Steve Jones
Last week I spent a few days in Cambridge, UK for the Redgate Company...
I have a table with partition on create_timestamp field. Though we're storing all data...
Comments posted to this topic are about the item Adding and Dropping Columns II
Comments posted to this topic are about the item Leveraging DuckDB for OLAP Workloads:...
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