Upgrade From SQL 2012 to SQL 2016 - Problem with Certificates
You may need to drop and recreate your certificates after migrating from SQL 2012 to SQL 2016+
2018-07-23
2,955 reads
Articles
How to be Accountable for Handling Personal Data
The GDPR is in full effect but meeting the requirements may still be confusing for many companies. In this article, William Brewer discusses what is needed to ensure compliance, including when a Data Protection Impact Assessment is required. He also explains the Data Protection Officer role.
2018-07-23
3,908 reads
How to change an Azure SQL Database Collation
In this tip we look at the steps you can follow to change the collation for an Azure SQL Database.
2018-07-23
3,184 reads
SQL Server Migration
Some SQL migrations require keeping the server name, instance name, IP, and port number. Geoff Ruble shares some notes on his recent experience with a SQL Server migration.
2018-07-20 (first published: 2015-10-12)
8,496 reads
2018-07-20
5,252 reads
Segment Data into Deciles
This short article shows a simple example of how to segment data into deciles
2018-07-19
10,914 reads
Power BI Introduction: Working with Parameters in Power BI Desktop —Part 4
Power BI allows you to use parameters to make your reports dynamic. In this article, Robert Sheldon demonstrates how parameters can be used to substitute connection information, query filters, or even calculations within the query.
2018-07-19
3,727 reads
SQL Server Reporting Services Rest API
What functionality is available in the SQL Server Reporting Services REST API and how should you use it?
2018-07-18
3,886 reads
ETL Performance Auditing - Part 1: Introduction to ETL Auditing
This article shows an easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup.
2018-07-17 (first published: 2012-06-05)
18,581 reads
Setting Permissions to Drop a Database
Learn which permissions are required to drop a database and see a test to show that these apply.
2018-07-17
22,347 reads
Blogs
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
When growing companies outgrow Excel
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Forums
BCA KCP Kertajaya Indah Telpon/WA:083179431313
WhatsApp:083179431313 Jl. Manyar Kertoarjo No.95, Mojo, Kec. Gubeng, Surabaya, Jawa Timur 60285
Alamat kontak resmi BCA KCU BLITAR Telp:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. Cempaka No.17, Sukorejo, Kec. Sukorejo, Kota Blitar, Jawa Timur 66111
BCA KCU BOROBUDUR Telpon/WA:083179431313
WhatsApp:083179431313 Jl. Borobudur No.I, RT.03/RW.07, Mojolangu, Kec. Lowokwaru, Kota Malang, Jawa Timur 65125
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers