How to Run Scheduled Jobs in Azure SQL Databases
This article will help you to schedule jobs in Azure SQL.
2016-08-01
14,172 reads
Articles
Introduction to Azure SQL Database Temporal Tables
As announced on June 1, 2016, SQL Server 2016 has reached its general availability. This means that you finally have the option to implement some of its new features in the production environment. While we still have to wait for their full support in Azure SQL Database V12, it is likely that their preview stage will be concluded soon. In this article, we will focus on Temporal tables, which is one example of these new features.
2016-08-01
4,507 reads
Execute SQL Server DBCC SHRINKFILE Without Causing Index Fragmentation
Simon Liew shows how to execute SQL Server DBCC SHRINKFILE without causing index fragmentation and example conditions that cause fragmentation.
2016-07-29
4,889 reads
Data Quality - Addressing non-stated requirements
Producing a crib sheet for data quality drives a shared understanding of the data used to power the business.
2016-07-28
1,330 reads
A Real-World React.js Setup for ASP.NET Core and MVC5
React is a front-end user interface library developed by Facebook, originally to help them improve their own site. Since then it has grown into somewhat of a phenomenon, with many active users. In this article, Jon Smith provides multiple examples of how to use React with recently released ASP.NET Core MVC, and the existing ASP.NET MVC5 framework.
2016-07-28
3,666 reads
Temporal Data Part 2 - Creating and Deleting System-Versioned Tables
Greg Larsen expands on his topic of how to modify an existing table to take advantage of the new temporal data feature in SQL Server 2016. In this article he shows you how to create and deleted system-versioned tables and the associated history temporal table.
2016-07-27
2,927 reads
Azure SQL Limitations compared with a SQL Server Enterprise
In this article, we will compare a traditional SQL Server Enterprise Edition with an Azure SQL Database and see the differences.
2016-07-26
15,124 reads
Redgate’s 2016 Roadmap
What do you get for your Support & Upgrades package? Read this blog post to learn about the new functionality and improvements Redgate is releasing this year. Find out more.
2016-07-26
3,068 reads
What's "Actually" going on with that Seek?
Rob Farley digs deeper into seeks and actual rows read, demonstrating a case where you want a non-sargable expression in the WHERE clause.
2016-07-26
3,541 reads
The IT Manager's perspective: People as an Asset
Information Technology is fast-changing, but the people who work in IT need to have a good chance of a long-term career. That means keeping up to date, not only in their current speciality, but in the wider sphere of the technology they work with. IT managers must make sure that keeping up to date with technology is part of the day to day activity of their people. How should they make sure it happens?
2016-07-25
3,286 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers