Oracle Error When Importing An Interval Partitioned Table
Oracle 12.1.0.2 can throw an ORA-01438 when importing an interval partitioned table. In this post, David Fitzjarrell suggests a work-around until Oracle patches the bug.
Correct Old Mistakes
We all make mistakes, but it's important that we revise our code to correct them over time.
Data Mining Part 34: Preparing for a certification exam
In this article we will talk about the Microsoft certifications related to Data Mining.
SQL Server Data Tools (SSDT) and Database References
SQL Server Data Tools (SSDT) provides, via the DacPac, interesting support for verifying not only those references within the database, but also those to other databases even if they are on other servers. Although it is adds an extra level of complexity to deployments, it can increase the probability that deployments will succeed without errors due to broken references or binding errors. Ed Elliot investigates.
The Boardgame of Office Politics
Sometimes the stress of interdepartmental friction withing organisations, can get on top of you, especially between the business and IT when the going gets tough. Simple-Talk's answer is a board game to put it all into perspective. Instead of getting carried away, play the board game instead and reach catharsis.
Advanced Mathematical Formulas using the M Language
The Power BI desktop designer contains a rich set of advanced mathematical functions. In this article, John Miner shows how you can combine these functions together in a computed column to solve numerical business problems.
Hacking Data
A new series of attacks were proven recently using music files to attach embedded systems in cars. Could this be another attack vector that we need to worry about?
Partitioning on a Budget
Enterprise Edition customers enjoy the manageability and performance benefits offered by table partitioning, but this feature is not available in Standard Edition. Aaron Bertrand explains his idea for achieving at least some of partitioning's upsides on any edition.
Blogs
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Forums
Bagaimana Cara Reschedule Tiket di BookCabin
Anda cukup menghubungi CS resmi BookCabin di nomor 082162909071 Dan Bisa Via wa resmi...
Cara Refund Tiket di BookCabin
Cara nya cukup menghubungi CS resmi BookCabin di nomor 082162909071 Dan Bisa melalui whatsapp...
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers