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 ...

When it comes to improving the performance of database systems, there are nearly as many approaches as there are DBA (database administrator) teams. That might sound acceptable at first glance. But, ...

Technology Toolbox: VB.NET, C#, SQL Server "Yukon" All versions of SQL Server prior to SQL Server "Yukon" provide two ways to write procedural code that executes inside the database. The usual way is ...

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.

Despite the plentiful information in Books Online and on the official “SQL Server 2000 Security” document Microsoft offers online, setting up a truly secure SQL Server remains a difficult task. In ...

No fooling: The next version of Microsoft's flagship database will be available on April 1. SQL Server 2014 hit its "release-to-manufacturing" milestone today, which typically falls several weeks ...

You'd have to be living under a rock not to have heard about the growth and uptake of cloud computing. Most enterprises are still exploring cloud computing for their relational databases, but there is ...

SQL Server, Microsoft’s flagship relational database product, is now available on Linux in the form of an early private preview, with a full launch planned for mid-2017. Until now, SQL Server was ...

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.

At the end of July the Google Cloud Platform (GCP) team announced Cloud SQL for Microsoft SQL Server available in alpha. According to Google, Cloud SQL for Microsoft SQL Server will let enterprises ...