Getting ready for Hadoop
Before adopting Hadoop into your organisation there are a number of factors to consider. This article highlights some of the key points.
2015-11-23
6,375 reads
Articles
SQL Server Heaps, and Their Fragmentation
In SQL Server, heaps are rightly treated with suspicion. Although there are rare cases where they perform well, they are likely to be the cause of poor performance. If a table is likely to have a large number of changes, then it can become fragmented due to way that space is allocated and forward pointers used. How does one detect this problem? Is it significant? How does one deal with it, if necessary? Neeraj Tripathi explains.
2015-11-23
3,694 reads
Using SQL Prompt to Accelerate the Top 10 Most Common Database Scripts
There may be some people who enjoy repetitive typing, but Grant Fritchey doesn't. He's always preferred SQL Prompt. The standard snippets suit developers fine but aren't so DBA-oriented, so he set about asking the SQLServerCentral community what they typed in the most, and set about producing a set of DBA snippets with the results.
2015-11-20
4,144 reads
Installing SQL Server 2016
Greg Larson walks through the GUI installation process for SQL Server 2016 and explore these new installation options.
2015-11-19
4,175 reads
Webinar: Unit Testing in SQL Server with tSQLt
Join tSQLt developer, Sebastian Meine, and Steve Jones as they answer your questions and show you how to unit test T-SQL code.
2015-11-19 (first published: 2015-11-10)
9,014 reads
SQL Prompt Tips #6 - Insert Semicolons
A quick SQL Prompt tip to automatically add semicolons to your code.
2015-11-18 (first published: 2015-01-20)
5,821 reads
Is SQL Server killing your application’s performance?
When an application suffers from performance problems, it’s common to assume the database is at fault. Ben Emmett examines why this often isn’t the case, and shows how you can dig into a .NET application’s use of SQL Server.
2015-11-18
4,405 reads
Database Lifecycle Management Webinar
Join Steve Jones for a Database Lifecycle Management webinar on Nov 17 at 11am EDT. Watch to see how smooth a database development pipeline can be.
2015-11-17 (first published: 2015-11-09)
6,349 reads
Questions About CUBE, ROLLUP and GROUPING SETs That You Were Too Shy to Ask
There are few parts of SQL Syntax as familiar as the GROUP BY clause of the SELECT statement. On the other hand, CUBE and ROLLUP remain mysterious despite their usefulness and GROUPING SET is positively arcane, especially if you are too shy to reveal your ignorance of the subject by asking! William Brewer saves you the hassle.
2015-11-17
4,187 reads
SQL Server 2016 Stretch Database
SQL Server 2016 brings a new feature called Stretch Database, which allows a database to keep transactional data on local instance and warm and cold data on the Azure SQL database platform.
2015-11-16
5,342 reads
Blogs
Flyway Tips: AI Helps with Commit Messages
By Steve Jones
At Redgate, we’re experimenting with how AI can help developers and DBAs become better...
Startup scripts in SQL Server containers
I was messing around performing investigative work on a pod running SQL Server 2025...
Using SQL Compare with Redgate Data Modeler
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
Forums
What is Page Density
Comments posted to this topic are about the item What is Page Density
T-SQL in SQL Server 2025: Fuzzy String Search II
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Azure-SSIS, Self-Hosted Integration Runtime, & Data Gateway?
Looking to confirm my understanding of these three products and how they can be...
Question of the Day
What is Page Density
In SQL Server, there is a concept of page density. This is determined by how much data is stored on each page. What is a page density of 90%?
See possible answers