External Article

MDX Essentials : Set Functions: The DRILLDOWNMEMBER() Function

In this article, we will begin an extended examination of the MDX surrounding drilling up and down within our Analysis Services cubes. Comprising an analytical technique by which an information consumer can maneuver between summarized ("drilling up") and detailed ("drilling down") levels of data, drilling up or down occurs along the lines of drilling paths that are defined within the physical structures of our cubes. Often specified by the cube's dimensional hierarchies, these paths can also be based upon alternative relationships that exist within or between dimensions.

External Article

Bogus Resumes and Unblushing Lies

Simple Talk's newest commentator, Phil Factor, reveals the dark side of hiring database specialists: "Soon after he had been shown his desk in our crowded, open-plan IT office, he began laughing out loud, sporadically and inappropriately, while reviewing code. It wasn't my code, so I didn't mind."

SQLServerCentral Article

More Intelligent Backup and Restore

Backups and restores are two fundamental tasks that a DBA must perform correctly. But remembering the syntax, options, decoding filenames, etc. can often be busy work that leaves a DBA open to mistakes. New author Vince Iacoboni brings us his code and techniques for a set of stored procedures to make handling backups and restores very simple.

Technical Article

Review of AdventNet SwisSQL Sybase to SQL Server Migration Tool 2.1

Now it's time to review yet another migration related product from AdventNet. It is called "AdventNet SwisSQL Sybase to SQL Server Migration Tool 2.1". As the name suggests, this migration product automates the conversion of Sybase ASE (Adaptive Server Enterprise) T-SQL stored procedures, inbuilt functions, triggers, tables, views, and other database objects to Microsoft SQL Server T-SQL.

Blogs

How to clear the SSMS cache?

By

How to clear the SSMS cache? If you are reading this,...

Master SQL Subqueries with This Free Course

By

Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...

Using Flyway Prepare for State-Based Deployments

By

One of the neat enhancements made to Flyway was the addition of state-based workflows...

Read the latest Blogs

Forums

display bytea image

By Bruin

I moved a table from MsSql to Postgresql that had a field defined as...

When trying to use a LocalDB, I get an error

By Doctor Who 2

I tried to find an appropriate forum to post the question. This one seems...

Resolving Access Denied Errors During SQL Server Database Attachment

By Noman072

Comments posted to this topic are about the item Resolving Access Denied Errors During...

Visit the forum

Question of the Day

SQL in an Azure VM Backup

If I use the Azure Backup service for automated backups of my SQL Servers in Azure VMs, how often can I configure log backups? (as of Dec 2024)

See possible answers