(Chris Webb) Last week I was doing some performance tuning on SSAS Multidimensional and saw something very strange: when the MDX Script of the cube was executed (as always happens after the cache has been cleared, or processing has taken place – you can monitor this via the Execute MDX Script Begin/
Author: SSWUG Research
ADO.NET: INSERT, UPDATE and DELETE Using the SqlCommandBuilder
(Ged Mead) A few posts ago, I demonstrated one way that you can create a DataGridView instance and then bind data to it by using the Smart Tasks dialog. Although this gave the appearance of having all the features you’ve seen in examples where the wizards and data tools are used, this isn’t strict
Tracking Changes in SQL Server 2012
(Leonard Mwangi) Over the years, I created several custom solutions to help identify Data Manipulation Language (DML) changes and track historical changes. While effective, these solutions were sometimes cumbersome to use and maintain.
SSWUGtv Security Edition: Today, we discuss the Adobe Data Breach, and how they were doing encryption wrong.
Video Programming for IT Professionals
Explanation of SQL Server IO and Latches
(Derek Colley) Recently, I noticed this intriguing message in one of my SQL Server 2008 R2 error logs:
Batched Table Access
(Timur Akhmadeev) When I first saw the suffix BATCHED in an Oracle execution plan from 12c, I was curious to see what is hidden behind and how it works. I had some spare time for testing and wanted to share my findings with you here.
The Folder Browser Dialog Box
(Richard Carr) The .NET framework provides a number of commonly used dialog boxes. These are designed to allow familiar methods for user input. They include font, file and colour selection and printer configuration dialogs. This article describes the folder browser.
SQL SERVER – How to Identify Datatypes and Properties of Variable
(Pinal Dave) Just another day I received very interesting question in email from Zovis and we exchanged few emails. I am converting our conversation in the chat format to understand it easily.
Ways to View Content Published to a Power BI Site
(Melissa Coates) There are multiple ways to view content published to a Power BI site. Four are mentioned below. These screen shots were taken during the Public Preview of Power BI (during which I cleverly called my site “PowerBISite”).
Simple Way to Bind List of Objects to View Using MVC
(Devesh Omar) I would like to show a list of users in a HTML page using MVC. I am assuming you are aware of MVC.