PASS attendees will get the chance to learn about Database Lifecycle Management (DLM) straight from its chief proponent: Red Gate Software, the database and .NET tooling company.
2014-11-03
192 reads
I have a fact table in my data warehouse that tracks durations of certain events as the total number of seconds that have passed. When users browse the cube, I’d like to show these durations formatted as time using the hh:mm:ss format. How can I do this in Analysis Services (SSAS)? - Koen Verbeeck responds.
2014-11-03
7,093 reads
This article shows an easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup.
2014-10-31 (first published: 2012-06-05)
18,587 reads
There’s a joke doing the rounds at SQL conferences and seminars: three DBAs walk into a NoSQL bar and leave when they can’t find a table. You may have heard it before, but it made Matt Hilbert sit down and ponder. What’s happening? Is there a division opening up between the newly fashionable NoSQL followers and DBAs? Matt enters the world of NoSQL to investigate.
2014-10-30
11,568 reads
How to compare two databases and email the results to every one who needs to know
2014-10-29
1,827 reads
As a society, we have an unrealistic respect for data, especially if it has a decimal point somewhere and uses metric units. We who are in the business of data need to cultivate a renewed interest in the sceptical and rigorous science of statistics: it is too important to leave to 'Data Scientists'. If the data is wrong, or the way we analyse or report it is misleading, much of what we do is pointless.
2014-10-28
8,058 reads
This metric is a great general indicator of performance problems. High stall times indicate I/O problems, which can be attributed to busy physical disks or queries that return large data sets to the client.
2014-10-28
7,321 reads
This article demonstrates the use of custom code and cell expressions referencing that custom code to toggle the background color of groups of rows in an SSRS report based upon value-changes in one of the fields.
2014-10-27
34,796 reads
Big data applications are now fairly commonplace in large organizations. It is, however, difficult to simply ‘drop’ these applications into an existing IT infrastructure and expect to run smoothly. In addition to energy and cooling requirements for new hardware to support the new big data application, other IT areas need to prepare.
2014-10-27
9,144 reads
DBCC is a mechanism that can protect you against corruptions causing substantial data loss in your database. If you use it.
2014-10-24 (first published: 2012-11-08)
22,091 reads
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Hub Via Wa:628218154374 Alamat: Jl. Suryopranoto No.40, RT.12/RW.7, Petojo Utara, Kecamatan Gambir, Kota Jakarta...
Hub Via Wa:628218154374 Alamat: Jl. P Jayakarta Komp. No.127, RT.7/RW.7, Mangga Dua Sel., Kecamatan...
Hub Via Wa:628218154374 Alamat: Jl. Mangga Dua Raya Jalan Kavling No.1 Blok C-5, RT.11/RW.5,...
If I run this statement in SQL Server 2025, how is the password encrypted?
CREATE SYMMETRIC KEY MySymmetricKey WITH ALGORITHM = AES_256, KEY_SOURCE = 'My secret key source passphrase', IDENTITY_VALUE = 'My secret identity value' ENCRYPTION BY PASSWORD = 'S&perS#cretP@ssword7'; GOSee possible answers