SQL and NoSQL Database Features and Differences
In this tip we will talk about the features and main differences between SQL and NoSQL databases.
2019-04-10
Articles
Configuring Azure SQL Databases Using Azure Resource Manager Templates
Template-based provisioning simplifies deployment and promotes principles of DevOps and Infrastructure as Code, making it the recommended method for implementing cloud-based services. However, its benefits extend beyond initial implementation, since you can apply it to configuring and maintaining existing Azure SQL Database instances. In this article, you explore an example of this approach.
2019-04-09
How are you using tools to design and model databases?
Redgate invite you to participate in their survey on database modeling. In order to inform their future product decisions, they'd like to better understand the needs and motivations behind the use of such tools.
2019-04-08
Introduction to SQL Server Security — Part 4
The sa account is the most powerful account in a SQL Server instance, and most DBAs disable it. There are several other built-in accounts that you may not think about that often. Robert Sheldon continues his SQL Server security series with an article about built-in accounts.
2019-04-08
A Database Developer’s Guide to SQL Clone
Phil Factor explains how SQL Clone works, and its multiple benefits when used in daily development and testing work, as well as for other tasks such as training staff to use a new application.
2019-04-05
How to Implement In-Memory OLTP Quickly and Easily
When you first hear about it, SQL Server’s In-Memory OLTP sounds like a new feature that’s hard to implement, requires a lot of schema changes, and takes planning and downtime. Here Brent Ozar tells you how it’s simply not true, and you can do it in just 3 steps.
2019-04-05
Crosstab queries using PIVOT in SQL Server
In this tip we look at how to construct a SQL Server PIVOT query with an example and explanation.
2019-04-04
How to Monitor IDENTITY columns to prevent unplanned downtime
If a table runs out of IDENTITY values then it, and any dependent services and applications, will be "read-only" until the problem is fixed. Steve Jones explains how to set up a custom monitor to detect and prevent such problems.
2019-04-04
Help us define the state of SQL Server monitoring in 2019
Last year we ran the industry’s first ever state of SQL Server monitoring survey, the results not only gave great insight for the community but helped us shape our product development to ensure we were meeting the needs that you were asking for. So what has changed in a year? Tell us for your chance to win a $250 Amazon voucher.
2019-04-03 (first published: 2019-03-21)
2,280 reads
Reaping the benefits of the Window functions in T-SQL
Exploring the potential benefits of the T-SQL Window functions (OVER, LAG, and LEAD) in this piece. You can learn how to achieve up to 50% performance boost by replacing a single function call.
2019-04-02 (first published: 2014-03-24)
25,941 reads
Blogs
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers