(Rajendra Gupta) SQL Server 2012 Management Studio included a graphical user interface to configure and manage Extended Events within the SQL Server database engine, but it was not available for Analysis Services.
Tag: sql server
What is acceptable database server performance testing
(Jack Vamvas) A new storage vendor with a new faster way of storing and retrieving data pitches their product. Your company is interested in testing out the new platform. The new platform promises consolidation, more flexible provisioning of disk and disk tiers.
SQL SERVER – Installation Error – File Format is Not Valid
(Pinal Dave) The reason I love consulting is because I get to see many flavors of the problems. This new avatar for me is pushing the limits to how I keep learning technologies. My recent interaction with the client has shown one more error and another angle to look at a problem.
Compare Power BI Desktop vs. Power BI Online
(Scott Murray) What is the difference between Power BI Desktop and Power BI Online? What are the main areas of for Power BI Online? What data visualization options are available?
How to Parameterize a Source Query in SSIS Using Attunity Connector for Oracle
(Melissa Coates) The steps we are going to follow include the following:
You don’t need to be a sysadmin
(Kenneth Fisher) Hey, I need sysadmin access to ServerA.
Azure SQL Database Elastic Database Jobs
(Marcin Policht) One of more common concerns among database administrators who consider migrating their estate to Azure SQL Database is their ability to manage efficiently the migrated workloads.
Using SELECT INTO with UNION Statements
(Jason Strate) On occassion, I need to take a number of different result sets and combine them into a single output, which I then want to store in a temporary table. I’ve done this while developing solutions for business needs and when analyzing performance for different environments. Sometimes I ju
Different ways to find Data, log and DB Size
(Prashanth Jayaram) Different ways to get the size of the data , log files and Databases
Quick PS script to get SQL Server Configuration Aliases
(Chris Bell) They can be quite helpful, but they can also be a major pain when setting up new servers or migrating to a new server.
