A BI project should return value to the company quickly, not only after months or even years of work. In this article by Gogula Aryalingam, Ruthie, the intern, determines which items from her manager's requirements she can complete before the big meeting. She continues working on her semantic model by including a Date table, the star schema, measures, formatting, and more.
Phil Factor feels that the database gets the short shrift in any outage - it's time to stop saying "the database has gone down" and time to start thinking about the resilience of the entire system.
Learn about the fundamental differences between the ROLLUP and CUBE operators.
In this tip we look at how to change the SQL Server setting for a tables identity column to not for replication for existing tables.
While architecting cloud native applications, you need to ensure that your system is highly available, performant, scalable, fault tolerant, and has the capability to recover from a disaster scenario. In this article, Samir Behara discusses the options available when designing the database architecture to achieve scalability.
Empower developers to refresh their own test systems with production backups.
The idea of serverless computing is interesting, and with Azure Stack, might be something more of us embrace.
SQL Server contains many built-in views and functions that can be used to understand what is going on “under the hood,” and security is no exception. In this article, Robert Sheldon explains the security related catalogue views, dynamic management views, and system functions
You’ve got one SQL Server hosting a bunch of databases, and performance is bad. Which database should you focus on first?
A data scientist needs some specialized skills. Today Steve Jones talks a bit about the requirements to be good at this job.
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
In all recent versions of the database you can call DBMS_UTILITY.EXPAND_SQL_TEXT to get the...
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
??????????????+Q?1825214279??????????????+Q?1825214279??????????????+Q?1825214279
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers