As well as its multidimensional model, SQL Server Analysis Services (SSAS) now has a tabular model of database that either runs in-memory or in DirectQuery mode. The in-memory analytics engine allows the users of Excel or Power View to base reports on tabular model objects. Having shown how to handle date-based information using the Multi-dimensional model, Dennes now turns his attention on the in-memory tabular model.
Today we have a guest editorial from Andy Warren that asks if the rest of you are intimidated by PowerShell.
The SSIS Script Task allows you to add functionality to your SSIS package that does not already exist with the other predefined tasks. In this article, Daniel Calbimonte looks at how to get started using the SSIS Script Task with a few examples.
It's possible to perform a man-in-the-middle attack against SQL Server. Steve Jones notes you should be aware these attacks could take place inside of your network.
Microsoft cloud platform allows you to provide resiliency for your on-premises SQL Server deployments. Marcin Policht describes this functionality, available as part of the Azure Site Recovery solution.
Redgate’s Arneh Eskandari and Microsoft SQL Server MVP, Steve Jones, will show you how Redgate’s DLM (Database Lifecycle Management) solution works to improve your database development and deployment processes. Today 12noon EDT
The individual's dexterity can impact how we use software. Perhaps we need ways to undo mistakes in various systems.
To be able to make full use of the system catalog to find out more about a database, you need to be familiar with the metadata functions. They save a great deal of time and typing when querying the metadata. Once you get the hang of these functions, the system catalog suddenly seems simple to use, as Robert Sheldon demonstrates in this article.
Today Steve Jones talks about the issues with the sa account, and how you might protect this on all your instances.
It is Friday, the queries are running, and nobody is watching the bill. That...
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
WhatsApp:0818-751-777 Jl. P. Diponegoro No.141, Dukuhtengah, Dukuh Tengah, Kec. Ketanggungan, Kabupaten Brebes, Jawa Tengah...
WhatsApp:0818-751-777 Jl. Jend Sudirman No.46, Curah, Slawi Wetan, Kec. Slawi, Kabupaten Tegal, Jawa Tengah...
WhatsApp:0818-751-777 Jl. M.T. Haryono No.68, Tengah, Kec. Delta Pawan, Kabupaten Ketapang, Kalimantan Barat 78812...
When running bcp on Linux, what is the field terminator?
See possible answers