Hadoop many flavors of SQL
What are the most popular SQL implementations for Hadoop? How different are they from T-SQL?
2015-11-24
5,191 reads
Articles
Azure SQL Database - Transparent Data Encryption
Transparent Data Encryption offers the ability to encrypt content of the database, its transaction logs, as well as backups while at rest. Encryption and decryption are performed in real-time, at the individual page level, as the database is being written to and read from storage, without necessitating changes to applications accessing their data. Marcin Policht reviews the feature.
2015-11-24
4,471 reads
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,380 reads
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,836 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
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers