(Sara Silva) The mobile applications market is growing faster and faster, and improving the UX of any application is crucial because it increases user loyalty. One of the most important features of modern applications is that they can be kept alive, which means keeping the user informed about the la
Tag: sql server
Create SQL Azure Database(PaaS)
(Vinoth N Manoharan) Today we can see the step by step procedure to create SQL Azure database(PaaS),As mentioned in the previous couple of articles any Microsoft Cloud based service you need a Azure Subscription (http://azure.microsoft.com/en-us/pricing/); Select SQL database section in the pricing
SQL SERVER – Add Node in Cluster – Rule ‘Node and cluster edition match’ failed
(Pinal Dave) Every day I get many emails and blog comment with at least one new problem every day. Recently, one of my blog readers sent an email asking assistance. She already had two node Windows Cluster. Let us call them Node1 and Node2.
A Plethora of PowerShell Pitfalls
(Michael Sorens) PowerShell has some very valuable features, but it is a mistake to believe that all those skills that you’ve derived from more conventional programming languages will transfer over to PowerShell. There are some pitfalls for the unwary.
Backups – They Are Needed, Who Knew?
(Chris Yates) Backups are essential for a successful business model. That statement may or may spark some topics for debate, but at the end of the day if the data professional does not have a form of backup in place for his/her business needs you may, no you will, feel the pain.
Port numbers and SQL Server
(Kenneth Fisher) I made a mistake the other day. I’ll admit it. I was wrong. Now I know all of you are shocked, but it does happen on rare occasions. So what was I wrong about you might ask?
Script out all SQL Server Indexes in a Database using T-SQL
(Percy Reyes) Sometimes as a DBA we need to generate a T-SQL script for dropping and creating indexes in our SQL Server databases. However, SQL Server Management Studio does not have an easy way via the wizard to complete these tasks at the same time. In this tip, we look at a creating a script to d
NaturalInnerJoin And NaturalLeftOuterJoin DAX Functions In Excel 2016
(Chris Webb) Continuing my series on new DAX functions in Excel 2016, here are two more: NaturalInnerJoin() and NaturalLeftOuterJoin(). Both do pretty much what you’d expect.
Monitoring the SSAS Connector in the Power BI Preview
(Melissa Coates) Welcome to part 3 of a 4-part series on using the SSAS Connector with the new Power BI Preview. This information is as of early March 2015 and is subject to change as the Power BI Preview evolves.
How DBAs Can Adopt the Craftsman Mindset
(Joshua Feierman) The job of a DBA requires a fusion of skill and knowledge. To acquire this requires a craftsman mindset. Craftsmen find that the better they get at the work, the more enjoyable the work gets, and the more successful they become. Deliberate practice, Specialization and an appetite f
