Traditional deployments of Azure SQL Database involve identifying projected resource requirements and selecting individual Azure SQL Database instances. For fluctuating workloads, this frequently results in over- or under-provisioning. To address this challenge, Microsoft offers another approach to sizing Azure SQL Database that relies on Elastic Database Pools. Marcin Policht takes a look.
2016-02-16
5,037 reads
You can develop a Power BI Dashboard that uses an R machine learning script as its data source and custom visuals. Here is a simple example that shows how to connect to data sources over the Internet, cleanse, transform and enrich the data through the use analytical datasets returned by the R script, design the dashboard and finally share it.
2016-02-15
4,931 reads
Are you thinking about the cloud yet? Redgate is conducting some research into cloud adoption to better understand both the drivers and the blockers. Whether or not you’ve taken the plunge yet, they would love to hear from you. Participate in the survey and be entered into a draw to win an Amazon gift card worth $100.
2016-02-12
4,954 reads
When maintaining or refactoring an unfamiliar database, you'll need a fast way to uncover all sorts of facts about the database, its tables, columns keys and indexes. SQL Server's plethora of system catalog views, INFORMATION_SCHEMA views, and dynamic management views contain all the metadata you need, but it isn't always obvious which views are best to use for which sort of information. Many of us could do with a simple explanation, and who better to provide one than Rob Sheldon?
2016-02-12
6,624 reads
Because SSIS is case sensitive, random VS_NEEDSNEWMETADATA errors on case-insensitive databases may indicate issues in your database change management & deployment process.
2016-02-11
2,459 reads
Are you thinking about the cloud yet? Redgate is conducting some research into cloud adoption to better understand both the drivers and the blockers. Whether or not you’ve taken the plunge yet, they would love to hear from you. Participate in the survey and be entered into a draw to win an Amazon gift card worth $100.
2016-02-11
4,517 reads
Rajendra Gupta takes a look at the additional enhancements made to Row Level Security in SQL Server 2016 CTP 3.1 and explores the new features with examples.
2016-02-11
3,492 reads
2016-02-10
197 reads
Are you thinking about the cloud yet? Redgate is conducting some research into cloud adoption to better understand both the drivers and the blockers. Whether or not you’ve taken the plunge yet, they would love to hear from you. Participate in the survey and be entered into a draw to win an Amazon gift card worth $100.
2016-02-10
5,272 reads
Enabling Transparent Data Encryption on Databases in Always On Scenario
2016-02-09
13,540 reads
In last months one of the scenarios where you can use AI has been...
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Comments posted to this topic are about the item Backup to Immutable Storage
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Comments posted to this topic are about the item Expanding into Print
In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?
See possible answers