Analysis Services Enhancements
In SQL Server 2000, Microsoft has closed the gap between its multidimensional database offering, OLAP Services, and the rest of the market place.
In SQL Server 2000, Microsoft has closed the gap between its multidimensional database offering, OLAP Services, and the rest of the market place.
The fourth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
Jon Winer talks about his adventures with Index Server and provides some hints to help you avoid some common problems.
Nothing is more annoying than having to disconnect users one by one. With this script, you will be able to quickly disconnect them with a few keystrokes.
The third part of Steve Jones's series on having SQL Server automatically report information to a DBA.
It is not always possible to run a process on a set schedule. This article by Steve Jones looks at a technique for ensuring that your processes can run on whenever you need them to without any loss of data.
The third part of Steve Jones's series on programming and manipulating strings in T-SQL dealing with REPLACE.
The fourth part of Steve Jones's series on programming and manipulating strings in T-SQL dealing with numeric conversions.
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
This is one of those things that on hindsight was a stupid problem, but...
By kleegeek
We’ve been tracking a weird state with SQL Server virtual machines on VMware and...
Hi, We installed default standalone SSAS in tabulator mode (SQL 2017 license). When they...
Comments posted to this topic are about the item Exporting the Database Encryption Key
Hi Guys, I want to remove duplicates from the table. The duplicate is a...