(Fernando Laudares) A recurring and very common customer issue seen here at the Percona Support team involves how to make the ibdata1 file “shrink” within MySQL. I can only imagine there’s a degree of regret by some of the InnoDB architects on their design decisions regarding disk-space management b
Other News
Script to drop SQL Server login and all owned objects using PowerShell
(Jeffery Yao) It’s a common task that DBAs need to drop SQL Server logins after a user leaves a company or some business scenario changes. Usually this is not a big task, but in a worst case scenario the SQL Server login may have database user accounts in multiple databases with roles and schemas ow
Know Your Limits
Today I want to talk about a skill that I think is one of the most difficult for any IT professional; knowing when to quit or ask for help. As a professional we are employed for our abilities to solve problems. For me, solving software problems is a blast. I would do it even if it wasn’t my job. I […]
Introduction to Power Query
Pro-Center Video Programming for IT Professionals
Introduction to Power Query
Pro-Center Video Programming for IT Professionals
AXON: The best of JSON, XML and YAML
This post continue the series about AXON and pyaxon.
Configuring PowerShell Remoting with Group Policy
(Derik Hammer) Last week I promised a post on enabling PowerShell Remoting when we discussed automating service account password updates. So, let’s break down the two methods.
Two simple commands that can be a big help in performance tuning.
(Kenneth Fisher) The first thing that always comes to mind when discussing performance tuning is query plans and rightly so. They are the best information about what a query is doing and so how to improve it.
Create Your Own Relationships Between Tables In The Excel Data Model With Power Query
(Chris Webb) You probably know that, when you are importing data from multiple tables in SQL Server into the Excel Data Model in Excel 2013 using Power Query, Power Query will automatically create relationships between those tables in the Data Model. But did you know that you can get Power Query to
Remaining IDUG Events in 2014
(Troy Coleman) I shared my thoughts about the IDUG NA conference in May, but this is just one of IDUG’s three major annual events. The European and Australian conferences are both coming up in a few weeks.