SQLSaturday Bloopers
Traveling to Charlotte, NC for SQL Saturday #33, Steve Jones takes a break from writing with a short piece, and quite a few mistakes from this year.
Implementing User-Defined Hierarchies in SQL Server Analysis Services
To be able to drill into multidimensional cube data at several levels, you must implement all of the hierarchies on the database dimensions. Then you'll create the attribute relationships necessary to optimize performance. Analysis Services hierarchies offer plenty of possibilities for displaying the data that your business requires. Rob Sheldon continues his series on SQL Server Analysis Services 2008.
Mnesia: A Distributed DBMS Rooted in Concurrency
Find out what makes Mnesia, the Erlang-based database management system, perfect for distribution across a network of computers.
Should DBAs be Paid Overtime?
For the past several weeks, I have been running a poll on www.bradmcgehee.com, asking visitors if they thought that DBAs...
A Cheap Fix?
Does it make sense to set up another instance of SQL Server just for a power user? Is it a good use of resources? Steve Jones comments today on this DBA tool for enhancing performance.
Calculating Moving Averages with T-SQL
How to efficiently calculate moving averages with SQL Server using Stock Market data.
Multiplatform ODBC support for SQLServer
The Microsoft SQL Server Connectivity team has a survey on the need for ODBC support for other platforms. If you use SQL Server from other platforms, let them know.
Querying Oracle from Powershell Part 1
In this two part blog post we will demonstrate how to query an Oracle database from Powershell. Before we can...
Querying Oracle from Powershell Part 2
In part one we installed and configured the Oracle client software, in this post we will query an Oracle database...
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat Kantor Resmi BCA KCU MANADO Tlp:08218154393
WA:08218154393 Jl. Sam Ratulangi No.17-19, Wenang Utara, Kec. Wenang, Kota Manado, Sulawesi Utara 95111
Alamat Kantor Resmi BCA KCU PANAKKUKANG Tlp:08218154393
WA:08218154393 Jl. Boulevard No.5 Blok F5, Masale, Kec. Panakkukang, Kota Makassar, Sulawesi Selatan 90231
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers