(Jackie Zhu, Tuvia Alon, Gregory Arkus, Randy Duran, Marc Haber, Robert Liebke, Frank Morreale Jr., Itzhak Roth and Alan Sumano) What do you know about your data? And how do you know what you know about your data?
Other News
SQL Server performance for NOT EXISTS vs NOT IN
(Vadivel) Though “NOT EXISTS” and “NOT IN” sounds similar there is quite a lot of difference between them. Let’s see few of the differences between them.
Data Mining Query Transformation in SQL Server Integration Services
(Marcin Policht) In one of our recent articles dedicated to SQL Server 2008 R2 Integration Services, we presented the characteristics and usage of Data Mining Query Task. As explained, its primary objective is to execute Data Mining Extension (DMX) queries against data mining models and capture thei
Get started with Hadoop-based data analytics on IBM SmartCloud Enterprise
(Raul F Chong) Cloud computing and big data analytics go together — cloud provides the benefits of elasticity, on-demand access to resources, and utility-like billing while big data processing/analytics delivers a framework to take advantage of cloud resources.
SQL Server performance impacted by new features
(KP Lee) SQL Server is a great system, but it has its quirks that can cause extreme performance issues.
Connecting to SQL Server Using SQLCMD Utility
(Ashish Kumar Mehta) One of the junior SQL Server Database Administrators in my company asked me how he can connect to SQL Server Database Engine using the SQLCMD utility. In this tip I show how to connect to a SQL Server Database Engine using the SQLCMD utility with Windows Authentication and SQL
What will the future be?
What will the future be? I don’t know if I am a hoarder or a pack-rat. When it comes to tech journals, I just can’t seem to throw them away. Recently I have been going back through my piles to see what we thought the future held 10-15 years ago. It’s really interesting to see what ideas became reality and […]
More Code Lookup Options for Enumerations
More Code Lookup Options for Enumerations Following are more ideas for synchronizing Enumerations with database lookup tables. The goal is to have Enumerations usable in application code, validated at compile time, that have the same values as those of lookup tables in external data stores such as relational databases. Many have written to remind us that MySQL an other data […]
Viewmodel extractors in ASP.NET MVC
(Jef Claes) Last week, I wrote something on assembling viewmodels in ASP.NET MVC. In that post, I said it would be nice to have a layer between my controller and my domain services that would assemble viewmodels for me. This would work one-way. In the other direction – from controller to domain serv
Change on a Dime: Agile Design
(John Anderson) What does it mean to have a good experience? Think of your favorite restaurant, the interior of your car, and the software on your phone: how do people craft these experiences? What details, planning, and design go into the process?