Tips for Better Presentations
Brent Ozar gives some advice to those of you who give presentations to user groups and conferences.
2019-06-28
Articles
What’s the Difference Between PERCENT_RANK and CUME_DIST?
Learn a bit about the different results you get from the PERCENT_RANK and CUME_DIST aggregate functions.
2019-06-27
13,083 reads
How can we close the tech skills gap?
One of the most profound challenges faced by technology companies today is talent. According to the latest Harvey Nash survey, 65% of CIOs believe that a shortage of tech skills is affecting their ability to respond to change.
2019-06-27
Improving Tech with Compassionate Code
There is quite a bit of suffering within tech and caused by tech, from poorly commented code to shaming someone who asks a question on a forum. In this article, Samuel Nitsche explains why compassionate coding is a better way to go.
2019-06-27
Collect SQL Server Index Usage Information for all Instances with PowerShell
In this tip we look at a PowerShell script you can use to collect index information for all of your SQL Server instances that you manage.
2019-06-26
Data breach notifications don’t need to be scary
Ever since the GDPR was introduced, the subject of data breach notifications has worried a lot of people. How do you write one? What do you need to include? What will the ramifications be? Will it make your customers run for the hills? Will it get you fired?
2019-06-26
All flash vs adaptive flash storage - which is right for my organisation?
Many data professionals might not worry about hardware, but someone needs to watch for changes and improvements in technology. Learn about how flash storage technology has changed and how this might be useful if you still need to build a fast database server.
2019-06-25
2,862 reads
Displaying the Object Explorer Details Pane in SQL Server Management Studio
You are probably familiar with the Object Explorer pane in SQL Server Management Studio (SSMS), and how to bring it up. But, are you familiar with the Object Explorer Details pane and how to display it? If not, then read on...
2019-06-25
SQL Clone on your Laptop
Phil Factor provides a PowerShell script to disconnect your laptop without risking error 21, if you're working with SQL Clone and need to go offline. The same script will then bring the clone database back online smoothly, once you're reconnected.
2019-06-25
Database provisioning and containers – can you help?
If you work with SQL Server, Redgate would love to talk to you about how you’re using (or thinking of using) containers, how you see databases fitting into your workflows involving them, and any challenges you’ve hit so far.
2019-06-24
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
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:...
More Documentation is Needed
Comments posted to this topic are about the item More Documentation is Needed
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