Defining unique records in an Oracle table is necessary for employee data, and manufacturing part numbers and user names, to name a couple of examples. David Fitzjarrell looks at the various ways uniqueness can be defined, and which method may not be acceptable to third-party applications.
2016-02-26
386 reads
It’s easy to get caught up in daily incidents, tickets, and special projects. Like a good scout, though, a core task in a DBA’s job is to be prepared.
2016-02-25
7,615 reads
Koen Verbeeck looks at how to embed data visualizations created with R into Reporting Services (SSRS) reports.
2016-02-24
3,902 reads
Have you ever longed for a way of making the delivery of databases more visible, predictable and measurable? Do you ever wish that they would be of better quality, quicker to change, and cost less? Grant Fritchey explains some of the secrets of doing Continuous Integration for Databases to relieve some of the pain-points of the Database Delivery process.
2016-02-23
4,082 reads
Greg Larsen explores the different ways that you can encrypt your existing confidential data using Always Encrypted Columns in SQL Server 2016.
2016-02-22
4,069 reads
This article gives an overview of the Microsoft Azure SQL Data Warehouse architecture. The new platform-as-a service (PaaS) offering provides independent compute and storage scaling on demand and is currently in public preview.
2016-02-19
4,066 reads
The whole point of using a cloud service is to be able to use it intensively for a brief period just when it is needed and then clear out all your work when you've finished. This means automation to make the process as quick and easy as possible. It is likely to mean creating a VM, provisioning it from scratch and spinning it up using PowerShell. Relax, grab the popcorn, and let Adam Bertram show you how he does it in Azure.
2016-02-18
5,142 reads
Arshad Ali demonstrates what the APPLY operator is, how it differs from regular JOINs, and what its applications are.
2016-02-17
7,571 reads
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
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Comments posted to this topic are about the item SQL Server 2025 Backup Compression...
Comments posted to this topic are about the item The Large Encoded Value
Comments posted to this topic are about the item The Side Job
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers