I have been looking at a lot of Red-Gate's tools for SQL Server and I have to say I am very excited about them. (Maybe I'm just easy to please and enjoy shiny objects... it's possible)<BR><BR>Anyway, ...

In SQL Server 2005, Microsoft introduced the Upgrade Advisor. This was a great idea to be able to analyze your current SQL Server in a safe environment and start the planning process of an important ...

Helping & empowering business owners for over 15 years, helping them to understand how to protect own interests, build bridges to amplify joint ventures, adapting new business practices and solutions.

In April, the number of web attacks rose sharply, and Microsoft was quickly blamed for the problems. The software giant investigated and concluded that security groups had jumped to conclusions and ...

In this second delve into data cleanliness (read the first, How clean is your data?, here), we’ll test-drive the data profiling tool provided with Microsoft SQL Server. Other profiling tools have ...

Microsoft's SQL Server toolbox is a morass of acronyms, from SMO to SSMS to SOS, and differentiating one from the other can be a challenge. I recently caught up with Vicky Harp, lead program manager ...

SQL Developer can now import and export data from spreadsheets and other sources, saving tedious re-entry of data. It can browse the tables and data of non-Oracle databases, primarily SQL Server and ...

The new SQL Analytics software provides a more effective, more cost-efficient alternative to complex data warehouse systems, according to the big data company. Fast-growing big data company Databricks ...