Data Science Education
Data Science is a hot area and one to which quite a few people would like to move. Steve Jones has some thoughts on trying to get certified in this area.
Using SQL Compare with Row Level Security
Row Level Security is one of many new features in SQL Server 2016. It provides a much easier, consistent, and maintainable solution for row-based security rules. In this blog post, Data Platform MVP Steve Jones introduces this new feature, and walks through how Redgate SQL Compare can safely and reliably handle RLS changes.
Stairway to U-SQL Level 8: Joining Tables in U-SQL
U-SQL provides a number of ways to join data sources together. This articles introduces the joins available and how you can use them.
Best Practices For Building Alerts for Using APIs with SQL Server
Tim Smith shares some ideas about how to handle and alert on irregular data coming from APIs when loading your database.
Encryption Keys Matter
Protecting the keys used for encrypion can really matter for companies, and in today's complex world, that can be difficult. Monitoring becomes important to helping here.
Restore Gene Version 6 - User Guide
Read about the Restore Genie and the new support for fork points, Azure and Multiple Concurrent Restores.
Direct Query with Power BI
Power BI allows you to connect directly to the data just as if it were a “standard” connection, and modify and extend the data to support analytics. By using DirectQuery, you can build reports based on extremely large datasets where re-importing data not a practical solution. It also allows you to do data aggregations on the server. There are, of course, restrictions as well but it is nevertheless a worthwhile technique to use where appropriate. Adam Aspin explains all.
Creating Partition on Existing tables and Rolling Partitions
this article describes about creating partitions on our existing Tables and also gives details about how to create rolling partition to support new data
Ignoring Database Version Control
Steve Jones thinks version control is important, even for databases.
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 Kupang Jaya Telpon/WA:083179431313
WhatsApp:083179431313 Jl. Kupang Jaya No.17/I, Sonokwijenan, Kec. Sukomanunggal, Surabaya, Jawa Timur 60189
BCA KCP Ngagel Jaya Selatan Telpon/WA:083179431313
WhatsApp:083179431313 Jl. Ngagel Jaya Selatan No.25, Pucang Sewu, Kec. Gubeng, Surabaya, Jawa Timur 60283
BCA KCP Kertajaya Indah Telpon/WA:083179431313
WhatsApp:083179431313 Jl. Manyar Kertoarjo No.95, Mojo, Kec. Gubeng, Surabaya, Jawa Timur 60285
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